How to calculate memory the db is allocating?

[Former Member]

Hello, we have a 9.1.3 BW-database running with 4 partitions on AIX 5.3 64-bit. We have set the bufferpools for partion 0 to 1.6GB and for the others each to 1.2GB. The server has 36GB RAM but nmon or topas shows that this is already complete allocated and additional 10GB Swaps are allocated.

Is there a way to calculate all memory the database is allocating? Maybe we missed something. We want to reduce the memory consumption of the db, to get the db out of the swap space.

Regards,

Alexander

[Former Member · Accepted solution]

Alexander,

The db2pd command, with the -memsets option, can be used to monitor the amount of unused memory left in the instance shared memory region. Is the instance_memory dbm parameter set with a fixed value or to automatic? This was a problem in our V9.5 databases. See hint 1225540.

Best reagrds,

Joachim