Select an instance Instance to see the following information for that instance:
The Instance Members table shows resource allocation and configuration details (CPU Load, Memory) for members (hosts) on a single IBM DB2 instance. Click a row to drill-down to details in the Member Summary display.
The Instance Databases table shows utilization and processing metrics for databases on a single IBM DB2 instance. Click a row to drill-down to details in the Database Summary display.
|
Instance Members Table Each row is a different host member. Column values describe the host. |
||||
|
Member Count: |
The number of members in the table. |
|||
|
|
Host Name |
The name of the host. |
||
|
|
Expired |
When checked, performance data has not been received within the time specified by your administrator for the Expire Time. If your administrator has also set the Delete Time, this row will be deleted if no data is received within the time specified for deletion. |
||
|
|
Member |
The member number. |
||
|
|
OS |
The installed operating system. |
||
|
|
CPUs |
The number of CPUs and the number of CPUs in use. |
||
|
|
CPU Speed |
The processor speed. |
||
|
|
Total RAM |
The total amount of RAM, in megabytes. |
||
|
|
Total Virtual Memory |
The total amount of virtual memory, in megabytes. |
||
|
|
CPU Load Short |
Amount of processor load over the short term (defined by the IBM DB2 system, for example, 1-5 minutes). |
||
|
|
CPU Load Medium |
Amount of processor load over the medium term (defined by the IBM DB2 system, for example, 5-10 minutes). |
||
|
|
CPU Load Long |
Percentage of CPU load over the long term (defined by the IBM DB2 system, for example, 10-15 minutes). |
||
|
|
% CPU Usage |
The percentage of CPU used. |
||
|
Instance Databases Table Each row is a different database. Column values describe the database. |
||||
|
Database Count: |
The number of databases in the table. |
|||
|
|
Database |
The name of the database. |
||
|
|
Expired |
When checked, performance data has not been received within the time specified by your administrator for the Expire Time. If your administrator has also set the Delete Time, this row will be deleted if no data is received within the time specified for deletion. |
||
|
|
Connected |
When checked, the database is connected. |
||
|
|
Severity |
The alert status:
|
||
|
|
Response Time |
The response time, in milliseconds. |
||
|
|
I/O Wait Time % |
The percentage wait time taken by I/O operations. |
||
|
|
Network Wait Time % |
The percentage wait time taken by the network. |
||
|
|
Agent Wait Time % |
The percentage wait time taken by agents. |
||
|
|
Avg Deadlocks per Activity |
The average number of application deadlocks per activity. |
||
|
|
Avg Lock Escalations per Activity |
The average number of application deadlock escalations per activity. |
||
|
|
Avg Lock Timeouts per Activity |
The average number of application deadlock timeouts per activity. |
||
|
|
Avg Lock Waits per Activity |
The average number of application deadlock waits per activity. |
||
|
|
Rows Read per Rows Returned |
The number of rows read per number of rows returned. |
||
|
|
Activites/sec |
The number of activities per second. |
||
|
|
App Requests/sec |
The number of application requests per second. |
||
|
|
Commits/sec |
The number of application commits per second. |
||
|
|
Rollbacks/sec |
The number of application rollbacks per second. |
||
|
|
Buffer Pool Hit Ratio % |
The current buffer pool hit ratio, which is the total number of pool hits divided by the total number of buffer pool lookups. |
||
|
|
Activity Wait Time % |
The percentage wait time taken by activities. |
||
|
|
Avg Request CPU Time |
The average amount of CPU time used by requests, in seconds. |
||
|
|
Compile Proc Time % |
The percentage of time used for compiling processes. |
||
|
|
Routine Time Request % |
The percentage of time used for routine request processes. |
||
|
|
Section Time % |
The percentage of time used for section processes. |
||
|
|
Section Sort Time % |
The percentage of time used for sorting section processes. |
||
|
|
BP Hit Ratio % |
The current buffer pool hit ratio, which is the total number of pool hits divided by the total number of buffer pool lookups. |
||
|
|
Transaction Time % |
The percentage of time used for transaction processes. |
||
|
|
Utils Proc Time % |
The percentage of time used for utilities processes. |
||
|
|
Timestamp |
The data and time this data was last updated. |
||
Green indicates that no metrics have exceeded their alert thresholds.