Thread History By Correlation ID

This panel provides information about thread activity grouped by correlation ID for a selected report interval or subinterval.


________________ ZHAGTX   VTM     O2       V540.#P DA41 11/06/13 12:10:49   3 
> Help PF1         Back PF3         Up PF7         Down PF8          Zoom PF11 
>                                                                              
>                   Enter a selection letter on the top line.                  
>                                                                              
> A-BY PLAN       B-BY AUTHID       C-BY PLAN,AUTHID       D-BY AUTHID,PLAN    
> O-OPTIONS       *-BY CORRID                                                  
===============================================================================
>                            THREAD HISTORY BY CORRID                          
 HAGP                                                                          
+ Report Interval:   15 mins                     Start: 11/06 10:15:00.000000  
+ Report Filtered:       NO                        End: 11/06 10:29:59.999999  
 corr                                                                          
+                                                                              
+                                     DLk/ In-DB2  In-DB2  In-DB2          GetP
+Corrid       Thrds Commit Abrt DML   TOut Elap Tm CPU Tm  Wait Tm Getpage RIO 
+------------ ----- ------ ---- ----- ---- ------- ------- ------- ------- ----
+DB2PEAgent.e    19    181    0   456    0      .5     .09      .2     650  .7K
===============================================================================

Navigation

For additional information about
  • a report subinterval, move the cursor to the line you want, enter one of the following selection letters, and press Enter.
    A
    Thread history by Plan. For more information, see the description of panel Thread History By Plan.
    B
    Thread history by Authid. For more information, see the description of panel Thread History By Authid.
    C
    Thread history by Plan, Authid. For more information, see the description of panel Thread History By Plan, Authid.
    D
    Thread history by Authid, Plan. For more information, see the description of panel Thread History By Authid, Plan.
    O
    Thread history display options. For more information, see the description of the panel Thread History Display Options.
  • threads associated with a correlation ID, move the cursor to the line you want and press F11 (Zoom).
  • other topics, use the PF keys.

Fields

Report Interval
The time interval by which the report period is partitioned. For more information, see the description of panel Near-Term Thread History Filter Options.
Start
The start date and time of the first interval in the display.
Report Filtered
This field shows YES if thread filter values were used to create this display. Otherwise, NO is displayed.
End
The end date and time of the last interval in the display.
Corrid
The Db2 correlation identifier.
Thrds
The number of completed threads for the correlation identifier.
Commit
The number of successful commits run with the correlation identifier. For attachments that use two-phase-commit protocol, this count represents the number of phase two commits. For others, this count represents the number of single-phase commit (sync) requests.
Abort
The number of successful rollbacks performed by threads running with the correlation identifier.
DML
The number of DML calls issued by threads running with the correlation identifier.
DLk/TOut
The number deadlocks and timeouts that occurred for threads run with the correlation identifier.
In-DB2 Elap Tm
The elapsed time spent in DB2 for threads run with the correlation identifier. Accounting class 2 data is required. Displays N/A if accounting class 2 data is not available.
In-DB2 CPU Tm
The CPU time spent in Db2 for threads run with the correlation identifier. Accounting class 2 data is required. Displays N/A if accounting class 2 data is not available.
In-DB2 Wait Tm
The time spent waiting in DB2 for threads run with the correlation identifier. Accounting class 3 data is required. Displays N/A if accounting class 3 data is not available. DB2 Accounting class 3 wait events are:
  • Synchronous I/O waits
  • Asynchronous Read I/O waits
  • Asynchronous Write I/O waits
  • Lock/latch waits
  • Page latch waits
  • Drain lock waits
  • Drain of claims waits
  • Db2 service task waits
  • Archive Log Mode(QUIESCE) waits
  • Archive read from tape waits
Getpage
The number of Getpage requests issued by threads run with the correlation identifier.
GetP/RIO
The ratio of Getpage requests to synchronous Read I/Os for the correlation identifier.