Provides complete report of memory status, for instances, databases, agents, and applications.
The same information is also available from the Snapshot monitor.
In a partitioned database environment, this command can be invoked from any database partition defined in the db2nodes.cfg file. Apart from when instance level information is returned, the command returns information only for that database partition. This command does not return information for remote servers.
One of the following authorities:
Instance. The application creates a default instance attachment if one is not present.
>>-db2mtrk--+-----+--+-----+--+-----+--+-----+--+-----+---------> '- -i-' '- -d-' '- -p-' +- -m-+ '- -a-' '- -w-' >--+--------------------------+--+-----+--+-----+-------------->< '- -r--interval--+-------+-' '- -v-' '- -h-' '-count-'
Replaced with -a parameter to show application memory usage.
db2mtrk -i -d -v -r 10
Consider the following output samples:
Tracking Memory on: 2006/01/17 at 15:24:38
Memory for instance
monh other
576.0K 8.0M
Memory for database: AJSTORM
utilh pckcacheh catcacheh bph (1) bph (S32K) bph (S16K) bph (S8K)
64.0K 640.0K 128.0K 34.2M 576.0K 320.0K 192.0K
bph (S4K) shsorth lockh dbh apph (13) appshrh
128.0K 64.0K 9.6M 4.8M 64.0K 256.0K
Memory for database: CMGARCIA
utilh pckcacheh catcacheh bph (1) bph (S32K) bph (S16K) bph (S8K)
64.0K 640.0K 128.0K 34.2M 576.0K 320.0K 192.0K
bph (S4K) shsorth lockh dbh apph (26) appshrh
128.0K 64.0K 9.6M 4.8M 64.0K 256.0K
Tracking Memory on: 2007/01/15 at 11:30:38
Memory for instance
other monh fcmbp
11.5M 64.0K 640.0K
Memory for database: SAMPLE
utilh pckcacheh other catcacheh bph (1) bph (S32K) bph (S16K)
64.0K 1.0M 576.0K 448.0K 1.3M 832.0K 576.0K
bph (S8K) bph (S4K) shsorth lockh dbh apph (12) apph (11)
448.0K 384.0K 192.0K 320.0K 10.4M 64.0K 64.0K
apph (10) apph (9) apph (8)
64.0K 64.0K 64.0K
Application Memory for database: SAMPLE
appshrh
256.0K
Memory for application 11
apph other
64.0K 64.0K
Memory for application 10
apph other
64.0K 64.0K
Memory for application 9
apph other
64.0K 64.0K
Memory for application 8
apph other
64.0K 448.0K
Tracking Memory on: 2007/01/15 at 11:22:56
Memory for instance
Other Memory is of size 12058624 bytes
Database Monitor Heap is of size 65536 bytes
FCMBP Heap is of size 655360 bytes
Total: 12779520 bytes
Memory for database: SAMPLE
Backup/Restore/Util Heap is of size 65536 bytes
Package Cache is of size 1048576 bytes
Other Memory is of size 589824 bytes
Catalog Cache Heap is of size 458752 bytes
Buffer Pool Heap (1) is of size 1376256 bytes
Buffer Pool Heap (System 32k buffer pool) is of size 851968 bytes
Buffer Pool Heap (System 16k buffer pool) is of size 589824 bytes
Buffer Pool Heap (System 8k buffer pool) is of size 458752 bytes
Buffer Pool Heap (System 4k buffer pool) is of size 393216 bytes
Shared Sort Heap is of size 196608 bytes
Lock Manager Heap is of size 327680 bytes
Database Heap is of size 10944512 bytes
Application Heap (12) is of size 65536 bytes
Application Heap (11) is of size 65536 bytes
Application Heap (10) is of size 65536 bytes
Application Heap (9) is of size 65536 bytes
Application Heap (8) is of size 65536 bytes
Applications Shared Heap is of size 524288 bytes
Total: 18153472 bytes
Application Memory for database: SAMPLE
Applications Shared Heap is of size 524288 bytes
Total: 524288 bytes
Memory for application 11
Application Heap is of size 65536 bytes
Other Memory is of size 65536 bytes
Total: 131072 bytes
Memory for application 10
Application Heap is of size 65536 bytes
Other Memory is of size 65536 bytes
Total: 131072 bytes
Memory for application 9
Application Heap is of size 65536 bytes
Other Memory is of size 65536 bytes
Total: 131072 bytes
Memory for application 8
Application Heap is of size 65536 bytes
Other Memory is of size 458752 bytes
Total: 524288 bytes
Total: 1441792 bytes