2 IBM DB2 Database Metrics

This chapter provides descriptions for all IBM DB2 Database metric categories, and tables list and describe associated metrics for each category. The tables also provide user actions if any of the metrics for a particular category support user actions. Shaded rows represent key columns for a particular category.

• Viewing Metrics

• Connections

• Database Manager Configuration Information

• Health Indicators/Alarms

• Monitoring Information

• Performance

• Response

• Detailed Response

• Storage Information

• System Configuration Information

• DB2 Diag Log File Monitoring

• HADR Status Metrics

• Top Statements by CPU Time Metrics

• Top Statements by Execution Count Metrics

• Lock Waits Metrics

• Lock Waits by Table Metrics

• Lock Waits by Blocked Application Metrics

• Lock Waits by Blocking Application Metrics