Volume Thread Activity by Database

This panel shows volume activity information for each thread that generated I/O activity to the database during the collection interval. Use this information to analyze which threads are generating I/O activity for a single volume from a Db2 database perspective.


________________ ZOJT2    VTM     O2       V550.#P SE12 11/06/13 10:27:13   2 
> Help PF1        Back PF3          Up PF7          Down PF8          Sort PF10
>                                                                              
===============================================================================
>                       VOLUME THREAD ACTIVITY BY DATABASE                     
 OJT2                                                                          
+ Interval Time   = 00:05:00                      Interval Elapsed   = 00:02:29
+ Volume/Unit     = PMOSDB/4C2F                   Total I/O Rate/sec =       .0
+ Device Type     = 3390                          DB2   I/O Rate/sec =       .0
+                                                                              
+ Database = DSN00212                                                          
+ *                                                                            
+                                  ------I/O Rates----- -------I/O Counts------
+ Planname  Authid    Correlation  Total  Read   Write  Total   Read    Write  
+ --------  --------  ------------ ------ ------ ------ ------- ------- -------
+           SYSOPR                     .0     .0     .0       1       0       1
+ DSNESPCS  MIS       MIS              .0     .0     .0       1       1       0
===============================================================================

If you move the cursor to any entry in a column and press F10, OMEGAMON® for Db2 PE will sort on that column.

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) originating 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.
Database: The name of the database for which thread activity has occurred.
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 database for the time elapsed.
Read I/O Rate: The Read I/O rate (per second) that is attributable to the database for the time elapsed.
Write I/O Rate: The Write I/O rate (per second) that is attributable to the database for the time elapsed.
Total I/O Count: The total I/O count that is attributable to the database for the time elapsed.
Read I/O Count: The Read I/O count that is attributable to the database for the time elapsed.
Write I/O Count: The Write I/O count that is attributable to the database for the time elapsed.