Hi Everyone ,



I have a DB2 V9.1 server running on AIX which has 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

Thanks,
Kamal

On Jan 18, 1:35*am, Gladiator <vkamalnath1... (AT) gmail (DOT) com> wrote:
Have you looked at your file system cache? This is the most common
place for free memory to get used. Look for 'file pages' and numperm
(which tells you the percentage of memory occupied by the file system
cache) in the output of `vmstat -v`.