Thread History Db2 Lock/Scan/Sort Summary

This panel provides a summary of thread lock, sort, and scan information for a selected report interval.


________________ ZHATLOC  VTM     O2       V540.#P DA41 11/06/13 12:19:47   2 
> Help PF1         Back PF3         Up PF7         Down PF8          Zoom PF11 
>                                                                              
>                    Enter a selection letter on the top line.                 
>                                                                              
> A-Summary    B-Buffer Pool    C-DB2 Time    *-Lock/Scan/Sort    E-Alt Summary
> O-OPTIONS                                                                    
===============================================================================
>                    Thread History Lock/Scan/Sort Summary                     
 HATH                                                                          
+ Report Interval:   15 mins                     Start: 11/06 10:00:00.000000  
+ Report Filtered:       NO                        End: 11/06 10:14:59.999999  
 locs                                                                          
+                                                                              
+                                        Dlk/  Lock   Lock     TS        Recs  
+ End Time       Plan     Authid   Locks  Tout Waits  Wait Tm  Scan Sort Sorted
+ ------------   -------- -------- ------ ---- -----  -------  ---- ---- ------
+ 10:14:46.339 D DISTSERV MIS          38    0     0     .000    63    0      0
+ 10:13:44.882 D DISTSERV MIS          38    0     0     .000    53    0      0
+ 10:12:45.707 D DISTSERV MIS          38    0     0     .000    43    0      0
+ 10:11:46.491 D DISTSERV MIS          36    0     0     .000    33    0      0
+ 10:11:32.884 D DISTSERV MIS          97    0     0     .000    23    0      0
===============================================================================

Navigation

For additional information about
  • a particular thread, move the cursor to the thread information line and press F11 (Zoom).
  • related topics, choose on of the options at the top of the panel.
  • other topics, use the PF keys.

Fields

Report Interval
The time of the thread summary report displayed.
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.
End Time
The end time of the Db2 thread execution.
If this thread involves parallel processing or if it invokes autonomous procedures, one of the following identifiers is displayed after the elapsed time to provide more information about this thread:
*
This thread is a parallel task initiated on behalf of another (originating) thread to process a query request in parallel.
A
This thread is an autonomous procedure rollup record.
D
This thread is a RRSAF/DDF rollup record due to ZPARM ACCUMACC >= 2.
O
This thread is the originating thread that invokes autonomous procedures.
P
This thread is the parent or the originating thread of the parallel tasks that are created to process a query request in parallel. Activity that is performed for this (originating) thread is reflected under the parallel tasks.
R
This thread is a parallel task rollup record due to ZPARM PTASKROL = YES.
Plan
The Db2 plan name.
Authid
The Db2 authorization identifier of the threads.
Locks
The number of Internal Resource Lock Manager (IRLM) lock requests issued.
DLk/TOut
The number of deadlocks and timeouts occurred.
Lock Waits
The total number of waits because of lock or latch suspension. Accounting class 3 is required. Displays N/A if accounting class 3 data is not available.
Lock WaitTm
The time spent waiting as a result of lock or latch suspension. Accounting class 3 is required. Displays N/A if accounting class 3 data is not available.
TS Scan
The number of tablespace scans. Scan data required. Displays N/A if sort data is not available.
Sort
The number of sorts performed. Sort data required. Displays N/A if sort data is not available.
Recs Sorted
The total number of records sorted. Sort data required. Displays N/A if sort data is not available.