You increased the NUMBER of pages (size), not the size of the pages in the
bufferpool (page_size). In addition, the command will NOT always take
affect immediately. You will have to reactivate the database if there was
not enough shared database memory available to process the request.

Good luck.

David Baker
UDB World Site Admin
www.udbworld.com
[Email address protected]

-----Original Message-----
From: Rahul Yadav
[mailto:db2udbdba-ezmlmshield-x42496830.[Email address protected]
Sent: Saturday, August 19, 2006 3:26 AM
To: LazyDBA Discussion
Subject: Bufferpool page size

HI ,
i am facing a buffer pool hit ratio of 48%,so i decided to increase the
page size

" alter bufferpool IBMDEFAULT immediate size 24000"

but it still showing me the same page size,am i required to do anything else
to implement the changes also am i right to increase the page size there???


Cheers,
Rahul


---------------------------------------------------------------------
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