Page History
...
The following table describes the information displayed in the In DB2 tab.
Table 5-19 In 19 In DB2 tab
Column Description
...
| Column | Description |
|---|---|
| Program | Program name. |
| 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-20 Statistics tab
Column Description
Program Program name
...
20 Statistics tab
| Column | Description |
|---|---|
| Program | Program name. |
| Lock Escalations | Total number of lock escalations. |
| Lock |
...
| Timeouts | Total number of lock timeouts. |
| BP Data Read I/ |
...
| O | Total data 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 |
Table 5-20 Statistics tab
Column Description
...
| of rows selected. |
| Rows |
...
| Affected | Number of rows affected. |
| Internal Row |
...
| Affected | Number of internal rows affected. |
Selected Program
The following table describes the information displayed in the Over Time tab.
Table 5-21 Over 21 Over Time tab
| Column |
|---|
...
| 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 the Overview tab.
Table 5-22 Overview tab
Column Description
...
22 Overview tab
| Column | Description |
|---|---|
| Details | Detailed activity information. |
| In DB2 (Summed) |
...
| The In DB2 breakdowns. | |
| Statistics |
...
| Statistic counters overview. |
The following table describes the information displayed in the Statistics tab.
Table 5-23 Statistics 23 Statistics tab
| Column |
|---|
...
| Description |
|---|
| Rows Read/ |
...
| Written | Number of rows read/written. |
| Rows Selected/ |
...
| Affected | Number of rows selected/affected. |
| Bufferpool Physical I/ |
...
| O | Physical I/O over time (in pages). |
| Locks |
...
| Number of lock escalations and lock timeouts overtime. |
| Anchor | ||||
|---|---|---|---|---|
|
These are the statements Precise for DB2 is executing. Statements are collapsed.
Statement Comparison
The following table describes the information displayed in the General tab.
Table 5-24 General tab
Column Description
...
24 General tab
| Column | Description |
|---|---|
| Icon | Launch to SQL tab for statement tuning. |
| Statement |
...
| Statement name. |
| In DB2 (Summed) |
...
| The In DB2 breakdowns. | |
| % |
...
| The In DB2 percentage as a % of total rows. |
| In DB2 (Avg) |
...
| The average In DB2 time per statement execution. | |
| Executions |
...
| Total statement executions within the selected time frame. Available for statements, tables, and indexes. |
| Text |
...
| Statement text. |
The following table describes the information displayed in the In DB2 tab.
Table 5-25 In 25 In DB2 tab
Column Description
...
| Column | Description |
|---|---|
| Icon | Launch to SQL tab for statement tuning. |
...
| Statement | Statement name. |
| In DB2 (Summed) |
...
| The In DB2 breakdowns overtime. | |
| Using |
...
| CPU | In DB2 breakdown description. |
| Wait 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. |
Selected Statement
The following table describes the information displayed in the Over Time tab.
Table 5-26 Over 26 Over Time tab
| Column |
|---|
...
| Description |
|---|
| In DB2 (Summed) |
...
| The In DB2 breakdowns over time. | |
| In DB2 (Avg) |
...
| The average In DB2 time per statement execution. | |
| Statement |
...
| Executions | Total statement executions within the selected time. |
The following table describes the information displayed in the Overview tab.
Table 5-27 Overview 27 Overview tab
Column Description
Details Detailed activity information and last explain details
...