"Pablo" <th************@gmail.com> wrote in message
news:ct**********@news1.nivel5.cl...
Hi Db2 Administrators..
I have a doubt respect of change in size of bufferpools, I know
when change of bufferpool size I must reconfigure the parameter dbhash ...
someone has a thumb rule for calculate this value ?
Thanks in advance
PID
Not sure what you are talking about with regard to dbhash. What OS are you
using?
Change the bufferpool size with alter bufferpool.
The total of all bufferpools in all active databases on your server should
be about 50% - 75% of the real memory available on that machine (Linux,
UNIX, Windows). You need to have real memory available for bufferpools.
However, if you use 32 bit DB2 on LUW, you are limited by your OS as to how
much memory can be allocated to DB2. This varies from about 1 GB to 1.75 GB
total (bufferpools plus other DB2 memory), but there are a few exceptions.