Page History
...
| Info |
|---|
If you are working with SAP, PeopleSoft, or Siebel, and ERP support is installed, the Activity tab displays information on the historical Precise for DB2 activity in relation to the ERP application and users, and specific information on executed views and transactions. |
| Anchor | ||||
|---|---|---|---|---|
|
Figure 5- 1 Precise for DB2 Activity tab
...
- Right-click on an entity in the tree, and then click Sort and Filter.
- In the Associate With dialog box, on the Entries tab, select the entity you want to associate data with from the Populate table with list.
- In the Sort entries by list, determine according to which criteria you want the information to be sorted and in which order.
- From the Display top list, select the number of rows to display.
- On the Criteria tab, do the following for each entity you want to associate data with:
From the left drop-down list Select list, select an entity.
From the middle drop-down list Select list, select an operator, such as, Like, <>, Not Like, In, Not In.
In the text box Type , type the criteria (case-sensitive) for the selected entity.
If you select the operator Like or Not Like, you can use the % wildcard character. If you select the operator In or Not In, type a comma to separate values. - Click OK.
...
The following table describes the information displayed in the Over Time tab.
Table 5- 1 Over Time tab
| Item | Description |
|---|---|
| In DB2 (Summed) | The In DB2 breakdowns over time. |
| Overall Activity (Summed) | Application overall activity over time. |
| Sessions | Number of sessions over time. |
| Compile and Recompile | The time the application spent for compiles and recompiles over time. |
| Commits and Rollbacks | The time the application spent for commits and rollbacks over time. |
The following table describes the information displayed in the Overview tab.
Table 5- 2 Overview tab
| Item | Description |
|---|---|
| Details | Summed information for the chosen time frame of Total In db2, Sessions, etc. |
| In DB2 (Summed) | The summed In DB2 breakdowns. |
| Statistics | Summed statistics information such as locks escalations, locks timeouts, etc. |
The following table describes the information displayed in the Statistics tab.
Table 5- 3 Statistics tab
| Item | Description |
|---|---|
| Rows Read/Written | The number of rows read and written over time. |
| Rows Selected/Affected | The number of rows selected and rows affected over time. |
| Bufferpool Physical I/O | Pages read over time. |
| Locks | Locks escalations and locks timeouts over time. |
| Anchor | ||||
|---|---|---|---|---|
|
...
The following table describes the information displayed in the General tab.
Table 5- 4 General 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. |
| % | 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 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 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 Time tab
| 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 tab
| Item | 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- 9 Statistics tab
| Item | 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 over time. |
The following table describes the information displayed in the Storage tab.
Table 5- 10 Storage tab
| Item | Description |
|---|---|
| Devices in Use | List of devices used by DB2 database partition. Storage Statistics information is shown for each device. Selecting one of devices will present detailed information about the selected device in other components below. |
| Device <unit name> <device number>’s Cache Hits | Historical overtime graph of read, write, and combined cache hit ratio (%) of the selected device. |
| Containers and Tablespaces on Device <unit name><device number> | List of Containers and Table spaces stored on the selected device. |
| Device <unit name> <device number>’s Requests | Historical overtime bars graph for read and write requests for the selected device. |
| Device <unit name> <device number>’s Throughput | Historical overtime graph for Throughput (Mb/Sec) of the selected device. |
| Device <unit name> <device number>’s I/O Rate | Historical overtime graph for I/O rate (Sec/Req) on the selected device. |
| Anchor | ||||
|---|---|---|---|---|
|
...
The following table describes the information displayed in the General tab.
Table 5- 11 General tab
| Column | Description |
|---|---|
| Database | Name of the database where the statement is running. |
| 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 Executions | Total statement executions within the selected time. |
| Sessions | Number of sessions. |
The following table describes the information displayed in the In DB2 tab.
Table 5- 12 In DB2 tab
| Column | Description |
|---|---|
| Database | Name of the database where the statement is running. |
| 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- 13 Statistics tab
| Column | Description |
|---|---|
| Database | Name of the database where the statement is running. |
| 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
The following table describes the information displayed in the Over Time tab.
Table 5- 14 Over Time tab
| 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 the Overview tab.
Table 5- 15 Overview tab
| Item | 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- 16 Statistics tab
| Item | 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 over time. |
The following table describes the information displayed in the Storage tab.
Table 5- 17 Storage tab
| Item | Description |
|---|---|
| Devices in Use | Information about devices that are in use. |
| Device <unit name> <device number>’s Cache Hits | The amount of Cache Hits for the selected device. |
| Containers and Tablespaces on Device <unit name><device number> | Information on the Containers and Tablespaces that are defined for this specific device. |
| Device <unit name> <device number>’s Requests | The amount of Requests for the selected device. |
| Device <unit name> <device number>’s Throughput | The Throughput for the selected device. |
| Device <unit name> <device number>’s I/O Rate | The I/O Rate for the selected device. |
| Anchor | ||||
|---|---|---|---|---|
|
...
The following table describes the information displayed in the General tab.
Table 5- 18 General tab
| Column | Description |
|---|---|
| Program | Program name. |
| 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 Executions | Total statement executions within the selected time. |
| Sessions | Number of sessions. |
The following table describes the information displayed in the In DB2 tab.
Table 5- 19 In DB2 tab
| 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. |
| 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 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 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 |
|---|---|
| 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 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 | ||||
|---|---|---|---|---|
|
...
The following table describes the information displayed in the General tab.
Table 5- 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 DB2 tab
| 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 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 tab
| Column | Description |
|---|---|
| Details | Detailed activity information and last explain details. |
| In DB2 (Summed) | The In DB2 breakdowns. |
| Text | Statement text. |
| Anchor | ||||
|---|---|---|---|---|
|
...
The following table describes the information displayed in the General tab.
Table 5- 28 General tab
| Column | Description |
|---|---|
| Icon | Launch to Objects tab. |
| Type | The object type. |
| Object | The object name. |
| Schema | The object schema name. |
| Base Table Name | The name of the table. |
| In DB2 (Summed) | The In DB2 time. |
| % | The In DB2 percentage as a % of total rows. |
| Sequential Prefetch I/O | I/O time used for sequential prefetch. |
| List Prefetch I/O | I/O time used for list prefetch. |
| No Prefetch I/O | I/O time used with no prefetch. |
Selected Object
The following table describes the information displayed in the Overview tab.
Table 5- 29 Overview tab
| Column | Description |
|---|---|
| Details | Object details. |
| In DB2 (Summed) | The In DB2 time. |
| Prefetched I/O (Summed) | Over time information or I/O separated by Sequential prefetch, List prefetch, and No prefetch. |
| Anchor | ||||
|---|---|---|---|---|
|
...
The following table describes the information displayed in the General tab.
Table 5- 30 General tab
| Column | Description |
|---|---|
| Machine | Machine name. |
| 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 Executions | Total statement executions within the selected time. |
| Sessions | Number of sessions. |
The following table describes the information displayed in the In DB2 tab.
Table 5- 31 In DB2 tab
| Column | Description |
|---|---|
| Machine | Machine 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-3232 Statistics tab
| Column | Description |
|---|---|
| Machine | Machine 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). |
| 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 Machine
The following table describes the information displayed in the Over Time tab.
Table 5- 33 Over Time tab
| 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 the Overview tab.
Table 5- 34 Overview tab
| Item | 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- 35 Statistics tab
| Item | 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 over time. |
| Anchor | ||||
|---|---|---|---|---|
|
...
The following table describes the information displayed in the General tab.
Table 5- 36 General tab
| Column | Description |
|---|---|
| Module | Module name. |
| 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 Executions | Total statement executions within the selected time. |
| Sessions | Number of sessions. |
The following table describes the information displayed in the In DB2 tab.
Table 5- 37 In DB2 tab
| Column | Description |
|---|---|
| Module | Module 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- 38 Statistics tab
| Column | Description |
|---|---|
| Module | Module 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). |
| 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 Module
The following table describes the information displayed in the Over Time tab.
Table 5- 39 Over Time tab
| 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 the Overview tab.
Table 5- 40 Overview tab
| Item | 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- 41 Statistics tab
| Item | 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 over time. |
| Anchor | ||||
|---|---|---|---|---|
|
...
The following table describes the information displayed in the General tab.
Table 5- 42 General tab
| Column | Description |
|---|---|
| Action | Action name. |
| 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 Executions | Total statement executions within the selected time. |
| Sessions | Number of sessions. |
The following table describes the information displayed in the In DB2 tab.
Table 5- 43 In DB2 tab
| Column | Description |
|---|---|
| Action | Action 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- 44 Statistics tab
| Column | Description |
|---|---|
| Action | Action 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). |
| 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 Action
The following table describes the information displayed in the Over Time tab.
Table 5- 45 Over Time tab
| 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 the Overview tab.
Table 5- 46 Overview tab
| Item | 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- 47 Statistics tab
| Item | 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 over time. |
| Anchor | ||||
|---|---|---|---|---|
|
...
The following table describes the information displayed in the General tab.
Table 5- 48 General tab
| Column | Description |
|---|---|
| OS User | OS User name. |
| 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 Executions | Total statement executions within the selected time. |
| Sessions | Number of sessions. |
The following table describes the information displayed in the In DB2 tab.
Table 5- 49 In DB2 tab
| Column | Description |
|---|---|
| OS User | OS User 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- 50 Statistics tab
| Column | Description |
|---|---|
| OS User | OS User 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). |
| 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 OS User
The following table describes the information displayed in the Over Time tab.
Table 5- 51 Over Time tab
| 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 the Overview tab.
Table 5- 52 Overview tab
| Item | 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- 53 Statistics tab
| Item | 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 over time. |
| Anchor | ||||
|---|---|---|---|---|
|
...
The following table describes the information displayed in the General tab.
Table 5- 54 General tab
| Column | Description |
|---|---|
| DB User | Database User name. |
| 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 Executions | Total statement executions within the selected time. |
| Sessions | Number of sessions. |
The following table describes the information displayed in the In DB2 tab.
Table 5- 55 In DB2 tab
| Column | Description |
|---|---|
| DB User | Database User 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- 56 Statistics tab
| Column | Description |
|---|---|
| DB User | Database User 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). |
| 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 DB User
The following table describes the information displayed in the Over Time tab.
Table 5- 57 Over Time tab
| 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 the Overview tab.
Table 5- 58 Overview tab
| Item | 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- 59 Statistics tab
| Item | 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 over time. |
| Anchor | ||||
|---|---|---|---|---|
|
...
Tablespace Comparison
Table 5- 60 General tab
| Column | Desription |
|---|---|
| Tablespace | The name of the tablespace. |
| I/O Time (Summed) | Total I/O time breakdown. |
| I/O Count | Total I/O count breakdown (in pages). |
| Page Size | The tablespace’s page size. |
| Pages | The number of pages. |
| No Victim Available | The number of times an agent did not have a pre-selected victim buffer available. |
The following table describes the information displayed in the I/O Time tab.
Table 5- 61 I/O Time tab
| Column | Description |
|---|---|
| Tablespace | The name of the tablespace. |
| I/O Time (Summed) | Total I/O time breakdown. |
| Synchronous Read Time | The total Synchronous Read Time. |
| Asynchronous Read Time | The total Asynchronous Read Time. |
| Direct Read Time | The total Direct Read Time. |
| Synchronous Write Time | The total Synchronous Write Time. |
| Asynchronous Write Time | The total Asynchronous Write Time. |
| Direct Write Time | The total Direct Write Time. |
The following table describes the information displayed in the I/O Count tab.
Table 5- 62 I/O Count tab
| Column | Description |
|---|---|
| Tablespace | The name of the tablespace. |
| I/O Count | The total I/O Count. |
| Synchronous Data Reads | The total Synchronous Data Reads. |
| Synchronous Index Reads | The total Synchronous Index Reads. |
| Asynchronous Data Reads | The total Asynchronous Data Reads. |
| Asynchronous Index Reads | The total Asynchronous Index Reads. |
| Direct Reads | The total Direct Reads. |
| Synchronous Data Writes | The total Synchronous Data Writes. |
| Synchronous Index Writes | The total Synchronous Index Writes. |
| Asynchronous Data Writes | The total Asynchronous Data Writes. |
| Asynchronous Index Writes | The total Asynchronous Index Writes. |
| Direct Writes | The total Direct Writes. |
The following table describes the information displayed in the Response Time tab.
Table 5- 63 Response Time tab
| Column | Description |
|---|---|
| Tablespace | The name of the tablespace. |
| Synchronous Read Response Time | The average Synchronous Read Response Time. |
| Asynchronous Read Response | The average Asynchronous Read Response. |
| Direct Read Response Time | The average Direct Read Response Time. |
| Synchronous Write Response Time | The average Synchronous Write Response Time. |
| Asynchronous Write Response | The average Asynchronous Write Response. |
| Direct Write Response Time | The average Direct Write Response Time. |
Selected Tablespace
The following table describes the information displayed in the Over Time tab.
Table 5- 64 Over Time tab
| Item | Description |
|---|---|
| Hit Ratio | The tablespace Hit Ratio over time. |
| I/O Time | The tablespace I/O time breakdown over time. |
| Response Time (Avg) | The tablespace average Response Time over time. |
| I/O Count | The tablespace I/O Count breakdown over time (in pages). |
The following table describes the information displayed in the Overview tab.
Table 5- 65 Overview tab
| Item | Description |
|---|---|
| Details | Details about the selected tablespace. |
| I/O Time | Total I/O time breakdowns (in Pie chart). |
| I/O Count | Total I/O Count breakdowns (in Pie chart). |
| Anchor | ||||
|---|---|---|---|---|
|
...
The following table describes the information displayed in the General tab.
Table 5- 66 General tab
| Column | Description |
|---|---|
| Bufferpool | The name of the bufferpool. |
| I/O Time (Summed) | Total I/O time breakdown. |
| I/O Count | Total I/O count breakdown (in pages). |
| Page Size | The bufferpool’s page size. |
| Pages | The number of pages. |
| No Victim Available | The number of times an agent did not have a pre-selected victim buffer available. |
The following table describes the information displayed in the I/O Time tab.
Table 5- 67 I/O Time tab
| Column | Description |
|---|---|
| Bufferpool | The name of the bufferpool. |
| I/O Time (Summed) | Total I/O time breakdown. |
| Synchronous Read Time | The total Synchronous Read Time. |
| Asynchronous Read Time | The total Asynchronous Read Time. |
| Direct Read Time | The total Direct Read Time. |
| Synchronous Write Time | The total Synchronous Write Time. |
| Asynchronous Write Time | The total Asynchronous Write Time. |
| Direct Write Time | The total Direct Write Time. |
The following table describes the information displayed in the I/O Count tab.
Table 5- 68 I/O Count tab
| Column | Description |
|---|---|
| Bufferpool | The name of the bufferpool. |
| I/O Count | The total I/O Count. |
| Synchronous Data Reads | The total Synchronous Data Reads. |
| Synchronous Index Reads | The total Synchronous Index Reads. |
| Asynchronous Data Reads | The total Asynchronous Data Reads. |
| Asynchronous Index Reads | The total Asynchronous Index Reads. |
| Direct Reads | The total Direct Reads. |
| Synchronous Data Writes | The total Synchronous Data Writes. |
| Synchronous Index Writes | The total Synchronous Index Writes. |
| Asynchronous Data Writes | The total Asynchronous Data Writes. |
| Asynchronous Index Writes | The total Asynchronous Index Writes. |
| Direct Writes | The total Direct Writes. |
The following table describes the information displayed in the Response Time tab.
Table 5- 69 Response Time tab
| Column | Description |
|---|---|
| Bufferpool | The bufferpool name. |
| Synchronous Read Response Time | The average Synchronous Read Response Time. |
| Asynchronous Read Response | The average Asynchronous Read Response. |
| Direct Read Response Time | The average Direct Read Response Time. |
| Synchronous Write Response Time | The average Synchronous Write Response Time. |
| Asynchronous Write Response | The average Asynchronous Write Response. |
| Direct Write Response Time | The average Direct Write Response Time. |
Selected Bufferpool
The following table describes the information displayed in the Over Time tab.
Table 5- 70 Over Time tab
| Item | Description |
|---|---|
| Hit Ratio | The bufferpool Hit Ratio over time. |
| I/O Time | The bufferpool I/O time breakdown over time. |
| Response Time (Avg) | The bufferpool average Response Time over time. |
| I/O Count | The bufferpool I/O Count breakdown over time (in pages). |
The following table describes the information displayed in the Overview tab.
Table 5- 71 Overview tab
| Item | Description |
|---|---|
| Details | Details about the selected bufferpool. |
| I/O Time | Total I/O time breakdowns. |
| I/O Count | Total I/O Count breakdowns. |