on 11-06-2008 6:13 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Alexander,
In addition to the above recommendations you can use the following command syntax for db2mtrk
to find out the actual memory usage (db2mtrk -i -d -v). Here is an example on a 4 partitioned system:
node0: usage 2.9GB, configured 7.2GB
node1: usage 1.6GB, configured 6.4GB
node2: usage 1.7GB, configured 6.4GB
node3: usage 2.1GB, configured 6.4GB
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Alexander,
Have a look at the the db2mtrk command. This command is the db2 memory tracker and together with db2pd and the database snapshots can be used to monitor the memory allocated to your system.
For documentation about this command, take a look at:
[db2mtrk - Memory tracker command|http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm.db2.udb.admin.doc/doc/r0008712.htm]
[Memory allocation in DB2|http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm.db2.udb.admin.doc/doc/c0005383.htm]
Hope this helps.
Best regards, Edgardo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.