Timeout Trace Example

View an example of a timeout trace.

Timeout trace example shows a sample Timeout trace, produced by the following command:

 
LOCKING
     TRACE
        LEVEL (TIMEOUT)

Timeout trace example

This is a sample Timeout trace:

   LOCATION: STLEC1                       IBM OMEGAMON FOR DB2 PERFORMANCE EXPERT (V5R5M0)                 PAGE: 1-1
      GROUP: N/P                                  LOCKING TRACE - TIMEOUT                       REQUESTED FROM: NOT SPECIFIED
     MEMBER: N/P                                                                                            TO: NOT SPECIFIED
  SUBSYSTEM: VA1A                                                                                  ACTUAL FROM: 06/04/15 00:15:44.20
DB2 VERSION: V10                                       SCOPE: MEMBER                                 PAGE DATE: 06/04/15

PRIMAUTH CORRNAME CONNTYPE
ORIGAUTH CORRNMBR INSTANCE     EVENT TIMESTAMP            --- L O C K   R E S O U R C E ---
PLANNAME CONNECT               RELATED TIMESTAMP EVENT    TYPE      NAME                    EVENT SPECIFIC DATA
------------------------------ ----------------- -------- --------- ----------------------- ----------------------------------------
SYSADM   L829UTT2 TSO          00:15:44.20054922 TIMEOUT  SKPT                              REQUEST =LOCK      UNCONDITIONAL
SYSADM   'BLANK'  C448AF2328DD N/P                                                          STATE   =U         ZPARM INTERVAL=   60
DSNTEP3  BATCH                                                      CTKN=0000000000000000   DURATION=MANUAL    INTERV.COUNTER=    1
                                                                                            HASH    =X'0804B402'
                                                                                            STMTINFO=DYNAMIC
                                                                                            STMTID  =X'0000000000000001'
                                                                    COLL(HEX)=              X'112233445566778899001122334455667788'
                                                                    PKID(HEX=               X'1122334455667788'   
                                                                                            ------------ HOLDERS/WAITERS -----------
                                                                                            HOLDER
                                                                                            LUW=USIBMSY.SYEC1DB2.C448AF1E53C6
                                                                                            MEMBER  =N/P       CONNECT =BATCH
                                                                                            PLANNAME=DSNTEP3   CORRID  =L829UTT1
                                                                                            DURATION=COMMIT    PRIMAUTH=SYSADM
                                                                                            STATE   =X         STMTINFO=DYNAMIC
                                                                                            STMTID  =X'0000000000000001'





LOCKING TRACE COMPLETE