Before attempting to monitor your DB2 database with SelectStar, ensure you are running DB2 9.5 or greater.
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.
The following information is required by SelectStar in order to monitor to your DB2 databases:
Name of the database in your instance to monitor
Hostname or IP address of the system on which your database is running
Port on which your database is listening [default: 50000]
JDBC DB2 user
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 ..... ..... .....