The command, db2mtrk is use to provide information details of the memory status. The command outputs will provide the status for instance, databases, agents and applications.
Command Options
Below are the options available for the db2mtrk command.
db2mtrk -h
Usage: db2mtrk -i | -d | -a | -p [-m | -w] [-v] [-r interval [count]] [-h]
-i Display instance level memory usage
-d Display database level memory usage
-a Display application level memory usage
-p Display agent private memory usage
-m Display maximum usage information
-w Display watermark usage information
-v Display verbose memory usage information
-r Run in repeat mode
interval Amount of seconds to wait between reports
count Number of reports to generate before quitting
-h Display this help screen
Example
Current memory usage for instance and all databases
> db2mtrk -i -d Tracking Memory on: 2013/12/19 at 16:48:14 Memory for instance other fcmbp monh 13.9M 832.0K 384.0K Memory for database: ARA utilh pckcacheh other catcacheh bph (1) bph (S32K) 2.8M 114.6M 192.0K 69.8M 4.3G 832.0K bph (S16K) bph (S8K) bph (S4K) shsorth lockh dbh 576.0K 448.0K 384.0K 192.0K 44.5M 132.5M apph (1689) apph (50102)apph (49858)apph (48748)apph (17352)apph (39) 64.0K 448.0K 384.0K 256.0K 192.0K 512.0K apph (38) apph (37) apph (36) apph (35) apph (34) apph (33) 512.0K 192.0K 512.0K 640.0K 512.0K 64.0K apph (32) apph (31) apph (30) apph (26) apph (25) apph (23) 512.0K 64.0K 128.0K 64.0K 64.0K 576.0K apph (16) apph (15) apph (14) apph (13) apph (12) apph (11) 64.0K 64.0K 64.0K 64.0K 64.0K 3.8M apph (10) apph (9) apph (8) appshrh 64.0K 64.0K 64.0K 4.1M
Maximum allowable size for instance and agent private memory
> db2mtrk -i -p -m Tracking Memory on: 2013/12/19 at 16:49:12 Memory for instance other fcmbp monh 45.9M 832.0K 384.0K Memory for agent 6684 other 8.0G Memory for agent 8227 other 8.0G Memory for agent 9512 other 8.0G Memory for agent 8484 other 8.0G Memory for agent 2828 other 8.0G
