DB2 system monitor

Data collected by the DB2® system monitor is organized into logical groups, with the data collection for each group being controlled by a set of DB2 monitor switches. These monitor switches enable or disable the collection of the logical groups of monitored data for the system monitor.

Because the Db2 agent collects attribute data from the DB2 system monitor, the DB2 agent requires dependent monitor switches to be enabled while the agent is running. To that end, the DB2 agent automatically enables the required set of monitor switches during agent startup. Because of DB2 data collection constraints, monitor switch enablement is at the database manager level. When the DB2 agent is stopped, the monitor switch settings are restored to their previous values.

Table 1 lists the DB2 monitor switches that are automatically enabled by the Db2 agent and the associated information whose collection is controlled by that monitor switch.

Table 1. DB2 monitor switches
Monitor switch	Monitor information
BUFFERPOOL	Number of reads and writes, time taken
LOCK	Lock wait times, deadlocks
SORT	Number of heaps used, sort performance
STATEMENT	Start and stop time, statement identification
TABLE	Measure of activity (rows read or written)
TIMESTAMP	Timestamps
UOW	Start and end times, completion status