Page History
...
| 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 9 Statistics tab
| Item |
|---|
...
| Description |
|---|
| Rows Read/ |
...
Table 5-9 Statistics tab
Item Description
| 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 10 Storage tabItem Description
| 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. |
About Databases
Databases list activity by database. All database partition information is aggregated to the database level.
Database Comparison
The following table describes the information displayed in the General tab.
Table 5-11 General 11 General tab
Column Description
Database Name of the database where the statement is running
...