This monitor allows you to monitor all of the buffer pools for your DB2 instance. The monitor collects the stats for all of the buffer pools defined on the DB2 instance (For example, IBMDEFAULTBP, BP4K, 8K, 16K, 32K).
1) Uncompress the contents of db2bufferpool.zip into your uptime4/scripts directory
2) Load the db2BfferPoolManifest-.xml file that is appropriate for your monitoring station
run: erdcloader -x scripts/db2BufferPoolManifest.-.xml
3) If you are running on a Unix monitoring station you may have to `chown uptime db2*` and `chmod 744 db2*` to set the proper file permissions.
Note: If you already have installed the DB2 Basic Monitor, you will get overrwrite messages about the ./lib directory containing the jar files for the DB2 JDBC drivers.
You will now have a DB2 buffer pool monitor under the advanced monitors section of 'add new service monitor'
Under the DB2 Buffer Pool monitor settings, you will have to provide the database connection port, instance name to monitor and a userid/password
The userid requires the following security permissions:
– SELECT or CONTROL privilege on the BP_HITRATIO, BP_READ_IO, BP_WRITE_IO and SNAPBP administrative views.
– SYSMON, SYSCTRL, SYSMAINT, or SYSADM authority is also required to access snapshot monitor data.
The monitor provides the following 13 buffer pool stats:
ASYNC_NOT_READ_PERCENT
AVERAGE_ASYNC_READ_TIME_MS
AVERAGE_ASYNC_WRITE_TIME_MS
AVERAGE_READ_TIME_MS
AVERAGE_SYNC_READ_TIME_MS
AVERAGE_SYNC_WRITE_TIME_MS
AVERAGE_WRITE_TIME_MS
DATA_HIT_RATIO_PERCENT
INDEX_HIT_RATIO_PERCENT
PERCENT_SYNC_READS
PERCENT_WRITES_ASYNC
TOTAL_HIT_RATIO_PERCENT
XDA_HIT_RATIO_PERCENT
The details on these stats are available at: