To start with, was it pinned because of physical reads?

If the system has sufficient memory and if you allocated the said table to a BP of it's own then
you may not see any difference.

Typical DBA answer is, it depends so needs testing in OAT/production sized system :-)

Praveen


-----Original Message-----
From: Ashok Rathi
[mailto:db2udbdba-ezmlmshield-x51515931.[Email address protected]
Sent: 21 April 2006 18:43
To: LazyDBA Discussion
Subject: Pinned Vs. Unpinned Bufferpool



Currently we are running UDB 8.1/FP-10. We have deliberately pinned the
bufferpools to improve response time. Now we do have multiple databases
on a 2-CPU Opteron box, and I am thinking about turning the registry
variable DB2_PINNED_BP to 'NO'.

Has anyone done some analysis as to what negative impact I will see?
Just curious...

Thanks a lot!

-- ashok


**************************************************************************

DemandTec Email Notice

This email and any attachments may contain confidential and/or proprietary information and
is intended solely for the use of the addressee. If you are not the intended recipient we
request that you notify us via email or telephone and delete all copies of the message
from your systems. Additionally, although DemandTec has taken reasonable precautions to
ensure the security of this email and any attachments, we encourage you to take similar
precautions and accept no liability for any loss or damage resulting from its use.
DemandTec, 1 Circle Star Way, Suite 200, San Carlos, CA 94070, 650-226-4600


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



DB2 & UDB email list listserv db2-l LazyDBA home page