A few special configurations are required on the DB2 database side in order for the Management Pack to collect metrics correctly.

Procedure

  1. Enable DB2 configuration parameter HEALTH_MON (i.e., turn on health indicators for instance and database objects).
  2. Enable switch for monitoring statements.
  3. Set up permissions for Management Pack to query the lock waits administrative view.
  4. Enable table monitoring (DFT_MON_TABLE) for the database you are monitoring.
  5. To complete the above configurations, run the following commands by Command Line Processor (CLP) at the db2 prompt:

    update dbm cfg using HEALTH_MON on
    update dbm cfg using DFT_MON_STMT on
    update dbm cfg using DFT_MON_LOCK on
    update dbm cfg using DFT_MON_TABLE on
    update dbm cfg using DFT_MON_BUFPOOL on
  6. To check if your changes are effective, run the following command:

    db2==> get dbm cfg

The following is the output:

.....

.....

.....

Monitor health of instance and databases (HEALTH_MON) = ON

Default database monitor switches

Buffer pool (DFT_MON_BUFPOOL) = ON

Lock (DFT_MON_LOCK) = ON

Sort (DFT_MON_SORT) = OFF

Statement (DFT_MON_STMT) = ON

Table (DFT_MON_TABLE) = ON

Timestamp (DFT_MON_TIMESTAMP) = ON

Unit of work (DFT_MON_UOW) = OFF

Monitor health of instance and databases (HEALTH_MON) = ON

.....

.....

.....

What to do next

Enabling SSL (IBM DB2)