Thread Activity by Spacename

This panel shows thread activity information for each thread that generated I/O activity to the spacename during the collection interval. Use this information to analyze which threads are generating I/O activity for a selected spacename.


________________ ZOJT7    VTM     O2       V550.#P SE12 11/06/13 10:23:09   2 
> Help PF1        Back PF3          Up PF7          Down PF8          Sort PF10
>                                                                              
===============================================================================
>                           THREAD ACTIVITY BY SPACENAME                       
 OJT7                                                                          
+ Interval Time   = 00:05:00                       Interval Elapsed = 00:03:25 
+ Total Getpage   =       14                       Total I/O        =        0 
+                                                                              
+ Database = DSNDB06        Spacename = DSNACX01                               
+ *                                                                            
+                                            Sync     ------ Prefetch I/O -----
+ Planname  Authid    Correlation   Getpage  Read       Seq      List   Dynamic
+ --------  --------  ------------  -------  -------  -------  -------  -------
+ DSNESPCS  MIS       MIS                14        0        0        0        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.
Total Getpage
The total number of Getpage requests since the beginning of the collection interval.
Total I/O
The total number of I/O requests since the beginning of the collection interval.
Database
The name of the selected database for which thread activity has occurred.
Spacename
The name of the selected spacename 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.
Getpage
The number of Getpage requests made by the thread.
Sync Read
The number synchronous reads made by the thread.
Sequential Prefetch
The number of Sequential Prefetch Read I/Os made by the thread.
List Prefetch
The number of List Prefetch Read I/Os made by the thread.