Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Ops Monitor for Db2 13.1 image-2024-5-19_8-5-1.png .

Lock trace—suspensions


This topic describes the Lock trace suspensions report (BLKTRCSU).

    LOCATION: DGR                                                                                    DATA FROM: 08/19/2013 11:39:38
     D/S GRP: DSNDGR   MBR: DGR1                     LOCK SUMMARY TRACE - SUSPENSIONS                       TO: 08/21/2013 13:49:24
        SSID: DGR1     VER: 10.1
    PRIMAUTH: DMRQA01              CONNECT: DB2CALL               CORRNAME: CYRANQXT                         CONNTYPE: DB2 CALL
    ORIGAUTH: DMRQA01              PLAN   : QXSTWKLD              CORRID  : CYRANQXT
    ENDUSER : DMRQA01              WSNAME : DB2CALL               TRXNAME : CYRANQXT
    LUWID   : USBMCN01.DGR1LU.CBD60B56B971                        ACE ADDR: 226C9EF0

    EVENT TIMESTAMP            ---------------- LOCK RESOURCE ---------------
     ELAPSED TIME     EVENT    TYPE         NAME                              EVENT SPECIFIC DATA
    ================= =======  ============ ================================= =====================================================
    11:39:38.77317700 LOCK     SYSLGRNG REC DSNDB06 .SYSTSSTG.LGRN.0000000100 DURATION: MANUAL      STATE: X     XES TYPE : L-LOCK
                      SUSPEND               HEX= 000607F200000001000000000000 ORIG RSN: INTER-SYSTEM COMM        XES PROP : Y
                                            HEX= 0000000000000000000000000000   PARENT: 00000000                 XES ASYNC: Y
                                                                                  HASH: 0700F107                 XES FORCE: Y

    11:39:38.77330500 LOCK                                                    RESUME REASON    : NORMAL
    00:00:00.00012700 RESUME                                                  SUSPEND REASONS
                                                                               LOCAL CONTENTION: N             GLOBAL RSRC: N
                                                                               LATCH CONTENTION: N             NOTIFY MSG : N
                                                                               IRLM QUEUED REQ : N             GLOBAL COMM: Y
                                                                               RETAINED LOCK   : N              XES RSRC  : N
                                                                               FALSE CONTENTION: N              IRLM RSRC : N

Following table describes the fields in the Lock trace—suspensions.

Field

Description

DURATION

Lock duration

ORIG RSN

Lock suspend reason

PARENT

Parent lock token

HASH

Lock resource hash value

STATE

Lock state

XES TYPE

Lock request type

XES PROP

Request sent/not sent

XES ASYNC

Request sync/async

XES FORCE

Lock request type

RESUME REASON

Reason lock resumed

LOCAL CONTENTION

Local resource contention

LATCH CONTENTION

IRLM latch contention

IRLM QUEUED REQ

IRLM queued request

RETAINED LOCK

Contention retained lock

FALSE CONTENTION

False resource contention

GLOBAL RSRC

Global resource contention

NOTIFY MSG

Inter-system message sending

GLOBAL COMM

Intersystem communication

XES RSRC

XES contention

IRLM RSRC

IRLM global

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Ops Monitor for Db2 12.2