Default language.

Space announcement The Using section of the MainView for DB2 documentation is now available in Japanese. The displayed language is dependent on your browser language. You can switch languages from the Language menu.

DB2 deadlock report (BDEADLCK)

The following figure shows a sample of the DB2 deadlock report (BDEADLCK).

Note

This report is based on DB2 performance lock trace IFCID 172.

1                       BDEADLCK: DB2 DEADLOCKS                                          01/07/15 16:53:24    PAGE     1

    DB2 SSID : DEFF 10.1
 +  ---------------------------------------------------------------------------------------------------
    01/05/15  10:45:02   DETECTED: 10:45:02.043263   INTV CNT:   206124   NMBR RESOURCES:      2

    RESOURCE: BMCUTIL .001B    .TABL.0000000000      TYPE: TABLE
      DB/PS:  0109     001B      PAGE:        0      HASH: 00011B09

      ============== HOLDER =========================   =============== WAITER ========================
      STATE   : X         DURATION: COMMIT              STATE   : IX        DURATION: COMMIT
                                                        FUNCTION: LOCK         WORTH:       18
      AUTHID  : IOA           PLAN: ARUDEV              AUTHID  : IOA           PLAN: ARUDEV
      CONNECT : DB2CALL     CORRID: WURFFSE2            CONNECT : DB2CALL     CORRID: WURFF$U2
      LUWID: USBMCN01. DEFFLU  . CE4FAAF06031           LUWID   : USBMCN01. DEFFLU  . CE4FA9F076D3
      THREAD TOKEN     :    44186                       THREAD TOKEN     :    43297
      OWNING WORK UNIT : 00D7002C1FDA2C00               OWNING WORK UNIT : 00D700211FDA2140
                                                        REQUEST WORK UNIT: 00D700211FDA2200
      DB2 MEMBER   : DEFF                               DB2 MEMBER   : DEFF
      END USER ID  : IOA                                END USER ID  : IOA
      WORK STATION : DB2CALL                            WORK STATION : DB2CALL
      TRANSACTION  : WURFFSE2                           TRANSACTION  : WURFF$U2
      PROGRAM NAME : ARUSMAIN                           PROGRAM NAME : ARUSMAIN
      COLLECTIONID : ARUDEV                             COLLECTIONID : ARUDEV
      LOCATION NAME:                                    LOCATION NAME:
      CONSIS. TOKEN: 19C9E0D71FE12D51                   CONSIS. TOKEN: 19C9E0D71FE12D51

    RESOURCE: BMCUTIL .001C    .TABL.0000000000      TYPE: TABLE
      DB/PS:  0109     001C      PAGE:        0      HASH: 00011C09

      ============== HOLDER =========================   =============== WAITER ========================
      STATE   : IX        DURATION: COMMIT              STATE   : X         DURATION: COMMIT
                                                        FUNCTION: LOCK         WORTH:       17
      AUTHID  : IOA           PLAN: ARUDEV              AUTHID  : IOA           PLAN: ARUDEV
      CONNECT : DB2CALL     CORRID: WURFF$U2            CONNECT : DB2CALL     CORRID: WURFFSE2
      LUWID: USBMCN01. DEFFLU  . CE4FA9F076D3           LUWID   : USBMCN01. DEFFLU  . CE4FAAF06031
      THREAD TOKEN     :    43297                       THREAD TOKEN     :    44186
      OWNING WORK UNIT : 00D700211FDA2140               OWNING WORK UNIT : 00D7002C1FDA2C00
                                                        REQUEST WORK UNIT: 00D7002C1FDA2CC0
      DB2 MEMBER   : DEFF                               DB2 MEMBER   : DEFF
      END USER ID  : IOA                                END USER ID  : IOA
      WORK STATION : DB2CALL                            WORK STATION : DB2CALL
      TRANSACTION  : WURFF$U2                           TRANSACTION  : WURFFSE2
      PROGRAM NAME : ARUSMAIN                           PROGRAM NAME : ARUSMAIN
      COLLECTIONID : ARUDEV                             COLLECTIONID : ARUDEV
      LOCATION NAME:                                    LOCATION NAME:
      CONSIS. TOKEN: 19C9E0D71FE12D51                   CONSIS. TOKEN: 19C9E0D71FE12D51

 +  ---------------------------------------------------------------------------------------------------
    01/06/15  02:09:49   DETECTED: 02:09:49.260959   INTV CNT:   261557   NMBR RESOURCES:      2

1                       BDEADLCK: DB2 DEADLOCKS                                          01/07/15 16:53:24    PAGE     2

    DB2 SSID : DEFF 10.1
    RESOURCE: BMCUTIL .001B    .TABL.0000000000      TYPE: TABLE
      DB/PS:  0109     001B      PAGE:        0      HASH: 00011B09

      ============== HOLDER =========================   =============== WAITER ========================
      STATE   : X         DURATION: COMMIT              STATE   : IX        DURATION: COMMIT
                                                        FUNCTION: LOCK         WORTH:       18
      AUTHID  : IOA           PLAN: ARUDEV              AUTHID  : IOA           PLAN: ARU1020I
      CONNECT : DB2CALL     CORRID: WURFF$U2            CONNECT : DB2CALL     CORRID: ARUFFMVR
      LUWID: USBMCN01. DEFFLU  . CE507987FD00           LUWID   : USBMCN01. DEFFLU  . CE50782E798F
      THREAD TOKEN     :    65211                       THREAD TOKEN     :    63865
      OWNING WORK UNIT : 00D700441FDA4430               OWNING WORK UNIT : 00D700541FDA5450
                                                        REQUEST WORK UNIT: 00D700541FDA5510
      DB2 MEMBER   : DEFF                               DB2 MEMBER   : DEFF
      END USER ID  : IOA                                END USER ID  : IOA
      WORK STATION : DB2CALL                            WORK STATION : DB2CALL
      TRANSACTION  : WURFF$U2                           TRANSACTION  : ARUFFMVR
      PROGRAM NAME : ARUSMAIN                           PROGRAM NAME : ARUSMAIN
      COLLECTIONID : ARUDEV                             COLLECTIONID : ARU1020I
      LOCATION NAME:                                    LOCATION NAME:
      CONSIS. TOKEN: 19C9E0D71FE12D51                   CONSIS. TOKEN: 19B85D09191E8141

    RESOURCE: BMCUTIL .001C    .TABL.0000000000      TYPE: TABLE
      DB/PS:  0109     001C      PAGE:        0      HASH: 00011C09

      ============== HOLDER =========================   =============== WAITER ========================
      STATE   : IX        DURATION: COMMIT              STATE   : X         DURATION: COMMIT
                                                        FUNCTION: LOCK         WORTH:       17
      AUTHID  : IOA           PLAN: ARU1020I            AUTHID  : IOA           PLAN: ARUDEV
      CONNECT : DB2CALL     CORRID: ARUFFMVR            CONNECT : DB2CALL     CORRID: WURFF$U2
      LUWID: USBMCN01. DEFFLU  . CE50782E798F           LUWID   : USBMCN01. DEFFLU  . CE507987FD00
      THREAD TOKEN     :    63865                       THREAD TOKEN     :    65211
      OWNING WORK UNIT : 00D700541FDA5450               OWNING WORK UNIT : 00D700441FDA4430
                                                        REQUEST WORK UNIT: 00D700441FDA44F0
      DB2 MEMBER   : DEFF                               DB2 MEMBER   : DEFF
      END USER ID  : IOA                                END USER ID  : IOA
      WORK STATION : DB2CALL                            WORK STATION : DB2CALL
      TRANSACTION  : ARUFFMVR                           TRANSACTION  : WURFF$U2
      PROGRAM NAME : ARUSMAIN                           PROGRAM NAME : ARUSMAIN
      COLLECTIONID : ARU1020I                           COLLECTIONID : ARUDEV
      LOCATION NAME:                                    LOCATION NAME:
      CONSIS. TOKEN: 19B85D09191E8141                   CONSIS. TOKEN: 19C9E0D71FE12D51

Related topic

Locking-activity-reports

 

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