Page History
...
The following table describes the information displayed in the General tab.
Table 5-4 General 4 General tabColumn Description
Column | Description |
---|---|
Database |
...
Partition | The name of the database: |
Catalog |
...
Server | The server of the catalog partition. |
In DB2 (Summed) |
...
The In DB2 breakdowns. |
...
% | The In DB2 percentage as a % of total rows. |
Statement in DB2 (Avg) |
...
The average In DB2 time for the statement. | |
Statement |
...
Execution | Total statement executions within the selected time. |
Sessions |
...
Number of sessions. |
...
Info |
---|
As pointed out in the About the Details pane in the Activity tab section, the graph at the bottom of the screen displays detailed information for the Data Partition selected in the table above. |
The following table describes the information displayed in the In DB2 tab.
Table 5-5 In 5 In DB2 tab
Column |
---|
...
Description |
---|
Database |
...
Partition | The name of the database: |
Catalog |
...
Server | The server of the catalog partition. |
In DB2 (Summed) |
...
The In DB2 breakdowns overtime. | |
Using |
...
CPU | In DB2 breakdown description. |
Waiting for |
...
CPU | In DB2 breakdown description. |
Sync I/O |
...
Wait | In DB2 breakdown description. |
Direct I/O |
...
Wait | In DB2 breakdown description. |
Prefetch |
...
Wait | In DB2 breakdown description. |
Lock |
...
Wait | In DB2 breakdown description. |
I/O Error |
...
Wait | In DB2 breakdown description. |
Remote Query |
...
Wait | In DB2 breakdown description. |
Utility |
...
Active | In DB2 breakdown description. |
The following table describes the information displayed in the Statistics tab.
Table 5-6 Statistics 6 Statistics tab
Column |
---|
...
Description |
---|
Database |
...
Partition | The name of the database: |
Catalog |
...
Server | The server of the catalog partition. |
Lock |
...
Escalations | Total number of lock escalations. |
Lock |
...
Timeouts | Total number of lock timeouts. |
BP Data Read I/ |
...
O | Total data reads (in pages). |
BP Index Read I/ |
...
O | Total index reads (in pages). |
Direct Read/Write I/ |
...
O | Total of direct reads and writes (in pages). |
Rows |
...
Read | Number of rows read. |
Rows |
...
Written | Number of rows written. |
Rows |
...
Selected | Number of rows selected. |
Rows |
...
Affected | Number of rows affected. |
Internal Row |
...
Affected | Number of internal rows affected. |
Selected Database Partition
The following table describes the information displayed in the Over Time tab.
Table 5-7 Over 7 Over Time tabItem Description
Item | Description |
---|---|
In DB2 (Summed) |
...
The In DB2 breakdowns over time. | |
Overall Activity (Summed) |
...
The application’s overall activity including In DB2 over time. | |
Sessions |
...
Number of sessions. |
Compile and |
...
Recompile | The time the application spent for commits & recompiles over time. |
Commits and |
...
Rollbacks | The time the application spent for commits & rollbacks over time. |
The following table describes the information displayed in Overview tab.
Table 5-8 Overview 8 Overview tab
Item Description
...
Item | Description |
---|---|
Details | Detailed activity information. |
In DB2 (Summed) The In DB2 breakdowns
...