SelectStar

Prerequisites

Before attempting to monitor your DB2 database with SelectStar, ensure you are running DB2 9.5 or greater.

Note

If your DB2 database system is set up to use SSL, you must add the DB2 SSL certificate to the collector's Java keystore prior to attempting to monitor your database.

Connection Information

The following information is required by SelectStar in order to monitor to your DB2 databases:

Field
API Field
Description

Database

database_name

Name of the database in your instance to monitor

Host

host

Hostname or IP address of the system on which your database is running

Port

port

Port on which your database is listening [default: 50000]

Credentials

Field
API Field
Description

Username

username

JDBC DB2 user

Password

password

User's password

Access Rights

In order to access and return certain metrics from your database, specific privileges must be granted to the designated DB2 user:

  • Enable DB2 configuration parameter HEALTH_MON (i.e., turn on health indicators for instance and database objects).
  • Enable switch for monitoring statements.
  • Set up permissions for the monitoring user to query the lock waits administrative view.
  • Enable table monitoring (DFT_MON_TABLE) for the database you are monitoring. 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

To check if your changes are effective, run the following command: get dbm cfg

You should see the following output:

.....
.....
.....
Monitor health of instance and databases (HEALTH_MON) = ON
Default database monitor switches
Buffer pool (DFT_MON_BUFPOOL) = OFF
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
.....
.....
.....