How to Find Information on DB2 Memory



Share this article :

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

Tags:

Related posts

Activate & Deactivate DB2 Database
Find Installed Instances in DB2
Determine Network Response Time between Client & DB2 Database
Find DB2 Database Process Status on Windows & UNIX/Linux
© 2017 ITsiti. All Rights Reserved
Powered by KEEM