Yes, you do.

You need first to increase the the DATABASE_MEMORY size to be at least
as big as the new bufferpool size you need.
Use the following command to check your current DATABASE_MEMORY size.
> db2 get db cfg for XXX show detail | grep memory (where XXX = your
db_name).
Use the following command to increase this size:
> db2 update db cfg for XXX using DATABASE_MEMORY new_size (where XXX =
your db_name, new_size = your db_new_size in pages of 4Kb).
In addition when altering bufferpool you do not need to explicitly write
"immediate" because it is done anyway for bufferpool.

Good luck,
Jacob.



On Sat, 2006-08-19 at 12:56 +0530, Rahul Yadav wrote:

> 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