I havent done any analysis, but in your case its probably a good thing. You
will give both databases a chance to get the
buffers it wants rather than failing to get the contiguous space.





"Ashok Rathi "
<db2udbdba-ezmlms
hield-x51515931.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
04/21/2006 01:42
PM 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