Thread History By Authid, Plan

This panel provides information about thread activity grouped by plan and authid for a selected report interval or subinterval.


 ________________ ZHAGAP   VTM     O2       V550.#P DA41 11/06/13 12:07:48   2 
> 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       *-BY AUTHID,PLAN    
> O-OPTIONS       G-BY CORRID                                                  
==============================================================================
>                       THREAD HISTORY BY AUTHID, PLAN                         
 HAGP                                                                          
+ Report Interval:   15 mins                     Start: 11/06 10:15:00.000000  
+ Report Filtered:       NO                        End: 11/06 10:29:59.999999  
 autp                                                                          
+                                                                              
+                                      In-DB2   In-DB2   In-DB2           GetP/
+ Authid   Plan     Thrds Commit  DML  Elap Tm  CPU Tm   Wait Tm  Getpage RIO  
+ -------- -------- ----- ------ ----- -------  -------  -------  ------- -----
+ MIS      DISTSERV    19    181   456      .5      .09       .2      650  .7K 
===============================================================================

Navigation

For additional information about
  • a report interval, 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.
    O
    Thread history display options. For more information, see the description of the panel Thread History Display Options.
    G
    Thread history summary by correlation ID. For more information, see the description of panel Thread History By Correlation ID.
  • threads associated with an authorization ID and plan, 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 interval currently displayed.
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 interval currently displayed.
Authid
The Db2 authorization ID. The authorization ID is displayed on the only first line within a group. However, if you sort this panel on a field other than the Authid+Plan combination, the authorization ID is displayed on each line.
Plan
The Db2 plan name.
Thrds
The number of threads completed for the authid,plan.
Commit
The number of successful commits performed by this authid,plan. 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.
DML
The number of DML calls issued.
In-DB2 Elap Tm
The elapsed time spent in Db2. 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 this authid. 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. Accounting class 3 data is required. Displays N/A if accounting class 3 data is not available.
Getpage
The number of Getpage requests issued.
GetP/RIO
The ratio of Getpage requests to synchronous Read I/Os.