Hi,
I have got a problem with resizing the bufferpool of a DB2 v.8.2
instance.
The DB2 runs on an AIX 5.x platform.
Problem is that an "ALTER BUFFERPOOL ..." command is not persistent if
the database is stopped with the db2stop and restarted with the
db2start command.
The bufferpool which I try to resize is the IBMDEFAULTBP.
Another problem that occurs is that all DB instances use the same
large bufferpoolsize when allocating memory although their size is set
to default value (1000 pages - IBMDEFAULTBP).
I once set that value of IBMDEFAULTBTP to 131072 and now every
Bufferpool on that DB2 instance seems to use that value despite the
actual setting of the DB-instances.
I see no way on how to change the value of the bufferpool and this
leads the AIX to crash if many instances are activated because all the
memory is allocated.
Hope someone can help me ...
Greetings
Christian Berg