Thread Lock/Claim/Drain Activity

Edit online

This panel provides detail information about current lock, claim, and drain activity of a selected thread.

________________ ZTLOCT   VTM     O2       V610.#P DA41 11/04/13  9:10:16   2 
> Help PF1                                                            Back PF3 
                                                                               
>       THREAD INFORMATION:  Enter a selection letter on the top line.         
                                                                               
> A-THREAD DETAIL *-LOCK COUNTS C-LOCK WAITS     D-LOCKS OWNED  E-GLOBAL LOCKS 
> F-CURRENT SQL   G-SQL COUNTS  H-DISTRIBUTED    I-BUFFER POOL  J-GROUP BP     
> K-PACKAGES      L-RES LIMIT   M-PARALLEL TASKS N-UTILITY      O-OBJECTS      
> P-CANCEL THREAD Q-DB2 CONSOLE R-DSN ACTIVITY   S-APPL TRACE   T-ENCLAVE      
> U-LONG NAMES                  W-ACCEL ACTIVITY                               
===============================================================================
>                    THREAD LOCK/CLAIM/DRAIN ACTIVITY                          
 PLAN                                                                          
+ Thread:  Plan=ADB       Connid=TSO      Corrid=MIS          Authid=MIS       
+ Attach:  TSO            Userid=MIS                          Region asid= 224 
+ Package: ADB2GET                        Collection=ADBL                      
+ Luwid=DEIBMIPS.IPSATA41.CC3659CD8774=796                                     
 loct                                                                          
+ Lock Requests          =          2   Deadlocks Detected         =          0
+ Unlock Requests        =          1   Timeouts Detected          =          0
+ Query Requests         =          0   Suspends - Lock Only       =          0
+ Change Requests        =          0   Suspends - Latch Only      =          0
+ Other IRLM Requests    =          0   Suspends - Other           =          0
+ Escalations to Shared  =          0   Escalations to Exclusive   =          0
+ Maximum Page/Row Locks =          0                                          
+                                                                              
+ Claim Requests         =          0   Claims Failed              =          0
+ Drain Requests         =          0   Drains Failed              =          0
===============================================================================

Navigation

You can scroll through the information using F7 and F8.

For additional information about:
  • Related topics, select one of the options at the top of the panel.
  • Other topics, use the PF keys.