ChannelDB2

Hi Everyone ,

 

I have a DB2 V9.1 server running on AIX which there is 8GB of memory .

 

svmon output shows the memory is completely used as given below

 

               size       inuse        free         pin     virtual
memory      2097152     2091166        5986      513907     1522706
pg space    4194304      899433

 

but db2mtrk command says the DB is using around 1-2 GB . There is nothing else running on the Server except the database .

 

The question is the output shown by db2mtrk is it the overall memory used by the database/instance ?  or is there anything else we should consider. if db2mtrk is right any clue where my remaninng 6GB memory is being used ?

 

 

db2mtrk -d -i -v -p
Tracking Memory on: 2012/01/18 at 02:26:09

Memory for instance

   Database Monitor Heap is of size 327680 bytes
   Other Memory is of size 15925248 bytes
   Total: 16252928 bytes

Memory for database :

   Backup/Restore/Util Heap is of size 67895296 bytes
   Package Cache is of size 69599232 bytes
   Catalog Cache Heap is of size 1638400 bytes
   Buffer Pool Heap (4) is of size 33095680 bytes
   Buffer Pool Heap (3) is of size 744751104 bytes
   Buffer Pool Heap (2) is of size 8519680 bytes
   Buffer Pool Heap (1) is of size 106758144 bytes
   Buffer Pool Heap (System 32k buffer pool) is of size 720896 bytes
   Buffer Pool Heap (System 16k buffer pool) is of size 458752 bytes
   Buffer Pool Heap (System 8k buffer pool) is of size 327680 bytes
   Buffer Pool Heap (System 4k buffer pool) is of size 262144 bytes
   Shared Sort Heap is of size 524288 bytes
   Lock Manager Heap is of size 6422528 bytes
   Database Heap is of size 8257536 bytes
   Other Memory is of size 196608 bytes
   Total: 1049427968 bytes

Memory for agent 925928

   Other Memory is of size 196608 bytes
   Application Control Heap is of size 65536 bytes
   Application Heap is of size 262144 bytes
   Total: 524288 bytes

Memory for agent 2912498

   Other Memory is of size 196608 bytes
   Application Control Heap is of size 65536 bytes
   Application Heap is of size 589824 bytes
   Total: 851968 bytes

Memory for agent 1986692

   Other Memory is of size 196608 bytes
   Application Control Heap is of size 65536 bytes
   Application Heap is of size 655360 bytes
   Total: 917504 bytes

Memory for agent 3346620

   Other Memory is of size 196608 bytes
   Application Heap is of size 655360 bytes
   Application Control Heap is of size 65536 bytes
   Total: 917504 bytes

Memory for agent 1372410

   Other Memory is of size 196608 bytes
   Application Heap is of size 720896 bytes
   Application Control Heap is of size 65536 bytes
   Total: 983040 bytes

Memory for agent 2642036

   Other Memory is of size 131072 bytes
   Application Control Heap is of size 65536 bytes
   Application Heap is of size 524288 bytes
   Total: 720896 bytes

Memory for agent 2379892

   Other Memory is of size 196608 bytes
   Application Control Heap is of size 65536 bytes
   Application Heap is of size 720896 bytes
   Total: 983040 bytes

Memory for agent 1691810

   Other Memory is of size 196608 bytes
   Application Control Heap is of size 65536 bytes
   Application Heap is of size 327680 bytes
   Total: 589824 bytes

Memory for agent 2576524

   Other Memory is of size 196608 bytes
   Application Heap is of size 655360 bytes
   Application Control Heap is of size 65536 bytes
   Total: 917504 bytes

Memory for agent 2211994

   Other Memory is of size 196608 bytes
   Application Heap is of size 720896 bytes
   Application Control Heap is of size 65536 bytes
   Total: 983040 bytes

Memory for agent 2687036

   Other Memory is of size 196608 bytes
   Application Heap is of size 1245184 bytes
   Application Control Heap is of size 65536 bytes
   Total: 1507328 bytes

Memory for agent 1163272

   Other Memory is of size 196608 bytes
   Application Heap is of size 720896 bytes
   Application Control Heap is of size 65536 bytes
   Total: 983040 bytes

Memory for agent 3330146

   Other Memory is of size 196608 bytes
   Application Control Heap is of size 65536 bytes
   Application Heap is of size 786432 bytes
   Total: 1048576 bytes

Memory for agent 2433176

   Other Memory is of size 131072 bytes
   Application Heap is of size 65536 bytes
   Total: 196608 bytes

Memory for agent 3026974

   Other Memory is of size 131072 bytes
   Application Heap is of size 65536 bytes
   Total: 196608 bytes

Memory for agent 2023532

   Other Memory is of size 131072 bytes
   Application Heap is of size 65536 bytes
   Total: 196608 bytes

Memory for agent 1351780

   Other Memory is of size 131072 bytes
   Application Heap is of size 65536 bytes
   Application Control Heap is of size 65536 bytes
   Total: 262144 bytes

Memory for agent 516306

   Other Memory is of size 131072 bytes
   Application Heap is of size 65536 bytes
   Application Control Heap is of size 65536 bytes
   Total: 262144 bytes

Views: 748

Reply to This

Try BLU Acceleration on Cloud

© 2014   Created by channeldb2.

Badges  |  Report an Issue  |  Terms of Service