Page History
...
The following table describes the information displayed in the General tab.
Table 5-54 General tabColumn Description
| 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 tabColumn Description
| 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
...
| 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 | ||||
|---|---|---|---|---|
|
Tablespaces list activity by Tablespace. This entity is only available for the Database and Database Partition entities. To display activity by tablespace, drill from the Database or Database Partition to the tablespaces entity.
The following table describes the information displayed in the General tab.
Tablespace Comparison
Table 5-60 General 60 General tab
Column Description
...
| 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 I61 I/O Time tab
Column Description
...
| 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 I62 I/O Count tab
Column Description
...
| 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 63 Response Time tab
Column Description
...
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 64 Over Time tab
Item Description
...
The following table describes the information displayed in the Overview tab.
Table 5-65 Overview 65 Overview tab
Item Description
Details Details about the selected tablespace
...