Thread History By Subinterval

This panel provides information about thread activity for a selected interval from the Thread History by Report Interval panel.

Each time displayed in this panel reflects the start of a subinterval. The subinterval is determined by the near-term history data collection options keyword NTAINTERVAL, which is specified by means of the Configuration Tool. For more information, see Configuration and Customization.


________________ ZHARS    VTM     O2       V550.#P DA41 11/06/13 12:09:54   2 
> Help PF1               Back PF3               Up PF7                 Down PF8
>                                                                              
>       Type a selection letter next to a Subinterval and press Enter.         
>                                                                              
> A-BY PLAN           B-BY AUTHID        C-BY PLAN,AUTHID     D-BY AUTHID,PLAN 
> E-THREAD SUMMARY    *-BY SUBINTERVAL   G-BY CORRID                           
===============================================================================
>                          THREAD HISTORY BY SUBINTERVAL                       
 HARS                                                                          
+ Report Interval:  15 mins                     Start:   11/06 10:15:00.000000 
+ Report Filtered:       NO                       End:   11/06 10:29:59.999999 
+                                                                              
+                                  Dlk/  In-DB2  In-DB2  In-DB2           GetP/
+   Time  Thrds Commit Abort DML   TOut  Elap Tm CPU Tm  Wait Tm  Getpage RIO  
+   ----- ----- ------ ----- ----- ----  ------- ------- -------  ------- -----
: _ 10:29     2     20     0    63    0       .0     .01      .0       67   .0 
: _ 10:28     1     10     0    24    0       .0     .00      .0       38   .0 
: _ 10:27     1     10     0    23    0       .0     .00      .0       37   .0 
: _ 10:26     1     10     0    23    0       .0     .00      .0       40   .0 
: _ 10:25     1     10     0    24    0       .0     .00      .0       35   .0 
: _ 10:24     1     10     0    24    0       .0     .00      .0       38   .0 
: _ 10:23     2     11     0    25    0       .1     .00      .0       43 43.0 
: _ 10:22     1     10     0    24    0       .0     .00      .0       38   .0 
: _ 10:21     2     20     0    45    0       .0     .01      .0       59   .0 
: _ 10:20     1     10     0    24    0       .0     .00      .0       38   .0 
: _ 10:19     2     20     0    63    0       .0     .01      .0       67   .0 
: _ 10:18     1     10     0    24    0       .0     .00      .0       38   .0 
: _ 10:17     1     10     0    23    0       .1     .00      .0       37   .0 
: _ 10:16     1     10     0    23    0       .0     .00      .0       40   .0 
: _ 10:15     1     10     0    24    0       .0     .00      .0       35   .0 
===============================================================================

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.
    E
    Thread history summary (no grouping). For more information, see the description of panel Thread History Summary.
    G
    Thread history summary by correlation ID. For more information, see the description of panel Thread History By Correlation ID.
  • 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 time of the last subinterval in the display.
Time
The time of the start of the report subinterval.
Thrds
The number of threads completed in this subinterval.
Commit
The number of successful commits performed in this subinterval. 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 in this subinterval.
DML
The number of DML calls issued in this subinterval.
DLk/TOut
The number deadlocks and timeouts occurred in this subinterval.
In-DB2 Elap Tm
The elapsed time spent in Db2 for this subinterval. 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 this subinterval. 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 this subinterval. 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 in this subinterval.
GetP/RIO
The ratio of Getpage requests to synchronous Read I/Os for this subinterval.