Page History
...
The following table describes the information displayed in the Overview tab.
Table 5-27 Overview tab
Column Description
...
| Column | Description |
|---|---|
| Details | Detailed activity information and last explain details. |
| In DB2 (Summed) |
...
| The In DB2 breakdowns. | |
| Text |
...
| Statement text. |
| Anchor | ||||
|---|---|---|---|---|
|
Lists of tables and indexes in use.
Object Comparison
The following table describes the information displayed in the General tab.
Table 5-28 General tab
Column Description
...
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 29 Overview tab
Column Description
...
| 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 | ||||
|---|---|---|---|---|
|
This is a list of the machines from which the users are logging in.
Machine Comparison
The following table describes the information displayed in the General tab.
Table 5-30 General 30 General tab
Column Description
...
| 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 31 In DB2 tab
Column Description
...
| 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-32 Statistics tab
Column Description
Machine Machine name
...
32 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 |
Table 5-32 Statistics tab
Column Description
...
| 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 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
...
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 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 | ||||
|---|---|---|---|---|
|
Modules represent the name of the package that was activated.
Module Comparison
The following table describes the information displayed in the General tab.
Table 5-36 General tab
Column Description
...
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 37 In DB2 tab
Column Description
...
| 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
...
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 |
Table 5-38 Statistics tab
Column Description
...
| 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 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
...
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 41 Statistics tabItem Description
| 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 | ||||
|---|---|---|---|---|
|
These are the account strings that were activated from the client information.
Action Comparison
The following table describes the information displayed in the General tab.
Table 5-42 General tab
Column Description
...
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 43 In DB2 tab
Column Description
...
| 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 44 Statistics tab
Column Description
Action Action name
...
| 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 |
Table 5-44 Statistics tab
Column Description
...
| 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 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 46 Overview tab
Item Description
...
| 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 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 | ||||
|---|---|---|---|---|
|
These are the names of the users that logged into the machine and executed activity in DB2.
OS User Comparison
The following table describes the information displayed in the General tab.
Table 5-48 General tab
Column Description
...
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 49 In DB2 tabColumn Description
| 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 50 Statistics tabColumn Description
| 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 |
Table 5-50 Statistics tab
Column Description
...
| 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 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
...
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 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 | ||||
|---|---|---|---|---|
|
These are the names of the users that logged into the DB2 database.
DB User Comparison
The following table describes the information displayed in the General tab.
Table 5-54 General 54 General tab
Column Description
DB User Database User name
...
The following table describes the information displayed in the In DB2 tab.
Table 5-55 In 55 In DB2 tab
Column Description
...
The following table describes the information displayed in the Statistics tab.
Table 5-56 Statistics 56 Statistics tab
Column Description
DB User Database User name
...
Rows Written Number of rows written
Table 5-56 Statistics tab
Column Description
Rows Selected Number of rows selected
...
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 57 Over Time tab
Item Description
...
The following table describes the information displayed in the Overview tab.
Table 5-58 Overview 58 Overview tab
Item Description
Details Detailed activity information
...
The following table describes the information displayed in the Statistics tab.
Table 5-59 Statistics 59 Statistics tab
Item Description
Rows Read/Written Number of rows read/written
...