5 IBM DB2 Database Reports

This chapter provides a list of out-of-box reports available for System Monitoring Plug-In for IBM DB2 Database.

Table 5-1 IBM DB2 Database Reports

Report Name Report Elements

IBM DB2 Database System Configuration

  • System Configuration

  • Product Overview

  • Instances

  • Partitions

  • Registry Settings

IBM DB2 Database DB Manager Configuration

  • DB Manager Capacity

  • DB Manager Database Instance

  • DB Manager Log and Recovery

  • DB Manager Partitioned DB Environment

  • DB Manager Connections

IBM DB2 Database DB Disk Storage Statistics

  • Disk Space Utilization

  • Disk Space Utilization Summary

  • Disk Space Utilization Details

IBM DB2 Database Bufferpool and Non-Buffered IO Statistics

  • Bufferpool Activity Summary

  • Non Buffered IO Activity Summary

  • Reads per sec

  • Index Read Rate

  • Index and Data Write Rate

  • Non Buffered IO

IBM DB2 Database Cache Statistics

  • Package Cache Summary

  • Catalog Cache Summary

  • Catalog Cache OverflowsCatalog Cache Hit RatioPackage Cache Overflows Package Cache Hit Ratio

  • Catalog Cache Heapfull

IBM DB2 Database Sort Heap and Hash Join Statistics

  • Total Sorts and Hash Joins

  • Active Sorts

  • Active Sorts Summary

  • Average Sort Space Used

  • Average Sort Time Per Sort

  • Sorts Overflow Ratio

  • Hash Join Small Overflows and Overflows

  • Hash Join Small Overflows to Overflows Ratio

IBM DB2 Database DB Manager Sorts Statistics

  • Database Manager Sorts Summary

  • Post Threshold Sorts and Joins

  • Piped Sorts Rejection Rate

IBM DB2 Database Locks Statistics

  • Lock Summary

  • Average Lock Wait Time

  • Locks Held and Waiting

  • Application Escalations and Timeouts

  • Deadlocks and Internal Deadlock Rollbacks

IBM DB2 Database DB Manager Agents and Connections Statistics

  • Agent Configuration

  • Agent Pool Activity

  • Agents Creation to Assignment Ratio

  • Idle Agents

  • Agents Watiting on Token

  • Remote Connections

  • Remote Connections Summary

  • Local Connections

  • Local Connections Summary

IBM DB2 Database Applications Lock Performance

  • Top 10 Applications Based on Average Lock Wait Time (ms)

  • Top 10 Applications Based on Number of Locks Held

  • Top 10 Applications Based on Number of Lock Timeouts

IBM DB2 Database CPU Usage

  • Top 10 Applications Based on Total CPU Usage (ms)

  • Top 10 Applications Based on Total Idle Time (ms)

IBM DB2 Database Applications Row Accesses and Sorts Performance

  • Top 10 Applications Based on Rows Read

  • Top 10 Applications Based on Rows Written

  • Top 10 Applications Based on Time Spent in Sorts (ms)

IBM DB2 Database SQL Statement Performance

  • Top 10 Statements Based on Rows Read

  • Top 10 Statements Based on Rows Written

  • Top 10 Statements Based on Average Sort Time (ms)

  • Top 10 Statements Based on CPU Usage (ms)

IBM DB2 Database DB Health

  • Database Health Information

  • Database Health Indicator

  • Database Collection Health Indicator

IBM DB2 Database DB Manager Health

  • Database Manager Health Information

  • Database Manager Health Indicator

IBM DB2 Database Tablespace Health

  • Tablespace Health Information

  • Tablespace Health Indicator

IBM DB2 Database Container Health

  • Container Health Information

  • Container Health Indicator

IBM DB2 Database Tablespace Statistics

  • Top 5 Tablespaces by Space Available (%)

  • Tablespaces Summary

The following shows the DB Manager Agents and Connections Statistics report available for IBM DB2 Database:

Figure 5-1 IBM DB2 Database DB Manager Agents and Connections Statistics Report

DB Manager Agents and Connections Statistics Report