Thread Activity by Volume
This panel shows activity information for each thread that generated I/O activity to the selected volume during the collection interval. Use this information to determine which DB2 threads are generating I/O on the selected volume.
________________ ZOJT1 VTM O2 V550.#P SE12 11/06/13 10:29:21 2
> Help PF1 Back PF3 Up PF7 Down PF8 Sort PF10
>
===============================================================================
> THREAD ACTIVITY BY VOLUME
OJT1
+ Interval Time = 00:05:00 Interval Elapsed = 00:04:37
+ Volume/Unit = PMOSDB/4C2F Total I/O Rate/sec = .0
+ Device Type = 3390 DB2 I/O Rate/sec = .0
+ *
+ ------I/O Rates----- -------I/O Counts------
+ Planname Authid Correlation Total Read Write Total Read Write
+ -------- -------- ------------ ------ ------ ------ ------- ------- -------
+ SYSOPR .0 .0 .0 2 0 2
+ DSNESPCS MIS MIS .0 .0 .0 2 2 0
=============================================================================== Navigation
For additional information about other topics, use the PF keys.
Fields
- Interval Time
- The collection interval currently in use by the object analysis collector. At the end of this time interval, the collector resets its collection statistics.
- Interval Elapsed
- The elapsed time within the current collection interval. It is the period of time for which the displayed information is applicable.
- Volume/Unit
- The name and address of the volume.
- Total I/O Rate/sec
- The total number of I/Os per second for the volume. This value is from an MVS™ perspective. If the volume is shared by multiple MVS systems, this value might not reflect all I/O activity to the volume.
- Device Type
- The device type of the volume displayed.
- Db2 I/O Rate/Sec
- The total number of I/Os per second (for the volume) that originated from the Db2 subsystem being monitored. This is a subset of total I/Os per second if I/O to the volume is also occurring from address spaces other than the Db2 subsystem being monitored.
- Planname
- The name of the plan associated with the thread.
- Authid
- The authid associated with the thread.
- Correlation
- The correlation ID associated with the thread.
- Total I/O Rate
- The total I/O rate (per second) that is attributable to the volume for the time elapsed.
- Read I/O Rate
- The Read I/O rate (per second) that is attributable to the volume for the time elapsed.
- Write I/O Rate
- The Write I/O rate (per second) that is attributable to the volume for the time elapsed.
- Total I/O Count
- The total I/O count that is attributable to the volume for the time elapsed.
- Read I/O Count
- The Read I/O count that is attributable to the volume for the time elapsed.
- Write I/O Count
- The Write I/O count that is attributable to the volume for the time elapsed.