The following section describes the device dashboards that are included in the IBM: Db2 PowerPack:
Device Dashboard
The IBM: Db2 PowerPack includes device dashboards that provide summary information for Db2 databases and tablespaces.
IBM Db2: Database
The IBM Db2: Database device dashboard displays the following information:
- Six gauges that display the following metrics:
- I/O Wait Time
- Compile Wait Time
- Req. Wait Time
- Net. Wait Time
- Act. Wait Time
- Lock Wait Time
- A line graph that displays the following information:
- Average Request CPU Time (s)
- Total Application Requests Completed (Count)
- Total Activities Completed (Count)
- Total Application Commits (Count)
- Total Application Rollbacks (Count)
- A line graph that displays the following information on sections:
- Sections Sort Time (%)
- Sections Process Time (%)
- Transactions End Process Time (%)
- A line graph that displays the following information on locks:
- Average Lock Timeouts Per Activities (Count)
- Average Deadlocks per Activities (Count)
- Average Lock Waits Per Activities (Count)
- A line graph that displays the following information on wait times:
- Network Wait Time (%)
- Caching Wait Time (%)
- I/O Wait Time (%)
- Requests Wait Time (%)
IBM: DB2 Tablespace
The IBM DB2: Tablespace device dashboard displays the following information:
- Three gauges that display the following metrics:
- Hit Ratio
- Size Utilization
- Pages Utilization
- A line graph that displays the following information:
- Total Pages (Count)
- Usable Size (KB)
- Total Size (KB)
- Used Size (KB)
- Free Size (KB)
- A line graph that displays the following information:
- Direct Reads (Count)
- Direct Writes (Count)
- Logical Reads (Count)
- A line graph that displays the following information:
- Direct Write Time (ms)
- Direct Read Time (ms)
- Pool Write Time (ms)
- Pool Read Time (ms)