As part of the initial diagnosis, the database administrator looks for familiar patterns of symptoms to categorize the problem at a high level. This example uses the MONREPORT.DBSUMMARY
report. The Summary report contains in-depth monitor data for the entire database, as well as key performance indicators for each connection, workload, service class, and database member. This report is implemented as a stored procedure in MONREPORT module. The MONREPORT module provides a set of procedures for retrieving variety of monitoring data and generating text reports.
MONREPORT.DBSUMMARY
TOTAL_WAIT_TIME
TOTAL_WAIT_TIME
TOTAL_WAIT_TIME
for requests and activities shows that applications are waiting most of the time.LOCK_WAIT_TIME
shows that DB2 is waiting for locks most of the time. This can be due to lock contention.