Using the Deadlock report

The Deadlock report provides information about record lockouts (also known as a deadly embrace) between two or more transactions.

In lockouts, a transaction locks record A and attempts to lock record B. However, a second transaction has already locked record B and is attempting to lock record A. Because neither transaction can continue until the other transaction releases its locks, IMS typically issues a user 777 or 123 pseudo-abend for one of the transactions.

 

Related topics

Working-with-batch-reports

The following example shows a Deadlock report.

2025-076                                           BMC AMI Log Analyzer for IMS V1.7.00.14                                 Page 1                                                                                                      
                                                 Deadlock report           (DEADLOCK) R=15                                                                                                                                             
LOG time span: FROM 2023-188 10:08:09.15 TO 2023-188 10:12:32.67 DURATION 00:04:23                                                                                                                                                     
Deadlock # 00001   (# participants=002  Source=IRLM)
timestamp=2023-188 10:08:34.2

DMB name=DI21PART  Lock name=00028001800701D7
key is root key for lock
Key Dump:
00000000   C8F6F7D4 D4C4D2F1 E6D3D2E6 F7F90000  00                                    *H67MMDK1WLKW79...               *
Status  IMS       Tran-Job  PSB name  PCB-DBD   PST#   Rgn Call Lock  Func      State         Recovery Token           UOW-1 (Originating)      UOW-1 (Processing)
Waiter  I15G      APPL0028  APPL0028  DI21PART  00002  MPP DLET GBIDP 22400358  03-P   Victim I15G    00001F9300000000 I15G    DD8F749E984E6601
Holder  I15G      APPL0027  APPL0027            00004  MPP                      06-P          I15G    00001F9100000000 I15G    DD8F749E98501A81
-----------------------------------------------------------------------------------------------------
DMB name=DI21PART  Lock name=537A92C1800701D7
key is root key for lock
Key Dump:
00000000   C8F6F7D4 D4C4D2F1 E6D3D2E6 F7F90000  00                                    *H67MMDK1WLKW79...               *
Status  IMS       Tran-Job  PSB name  PCB-DBD   PST#   Rgn Call Lock  Func      State         Recovery Token           UOW-1 (Originating)      UOW-1 (Processing)
Waiter  I15G      APPL0027  APPL0027  DI21PART  00004  MPP ISRT GRIDX 30400358  06-P          I15G    00001F9100000000 I15G    DD8F749E98501A81
Holder  I15G      APPL0028  APPL0028            00002  MPP                      04-P          I15G    00001F9300000000 I15G    DD8F749E984E6601


2025-076                                           BMC AMI Log Analyzer for IMS V1.7.00.14                                 Page 2                                                                                                      
                                                 Deadlock report           (DEADLOCK) R=15                                                                                                                                             
LOG time span: FROM 2023-188 10:08:09.15 TO 2023-188 10:12:32.67 DURATION 00:04:23                                                                                                                                                     
Deadlock # 00002   (# participants=004  Source=IRLM)
timestamp=2023-188 10:08:44.2

DMB name=DI21PART  Lock name=537A92C1800701D7
key is root key for lock
Key Dump:
00000000   C8F6F7D4 D4C4D2F1 E6D3D2E6 F7F90000  00                                    *H67MMDK1WLKW79...               *
Status  IMS       Tran-Job  PSB name  PCB-DBD   PST#   Rgn Call Lock  Func      State         Recovery Token           UOW-1 (Originating)      UOW-1 (Processing)
Waiter  I15G      APPL0027  APPL0027  DI21PART  00004  MPP GET  GRIDX 30400358  06-P   Victim I15G    00001F9100000000 I15G    DD8F749F08CEF541
Holder  I15G      APPL0027  APPL0027            00008  MPP                      06-P          I15G    00001F9400000000 I15G    DD8F749E984D8441
-----------------------------------------------------------------------------------------------------
DMB name=DI21PART  Lock name=00028001800701D7
key is root key for lock
Key Dump:
00000000   C8F6F7D4 D4C4D2F1 E6D3D2E6 F7F90000  00                                    *H67MMDK1WLKW79...               *
Status  IMS       Tran-Job  PSB name  PCB-DBD   PST#   Rgn Call Lock  Func      State         Recovery Token           UOW-1 (Originating)      UOW-1 (Processing)
Waiter  I15G      APPL0027  APPL0027  DI21PART  00008  MPP ISRT GBIDP 22400218  06-P          I15G    00001F9400000000 I15G    DD8F749E984D8441
Holder  I15G      APPL0007  APPL0007            00001  MPP                      06-P          I15G    00001F9700000000 I15G    DD8F749EABF32680
-----------------------------------------------------------------------------------------------------
DMB name=DI21PART  Lock name=00028001800701D7
key is root key for lock
Key Dump:
00000000   C6C7F7F8 E8D1D5F4 F5F6C5E6 F1F20000  00                                    *FG78YJN456EW12...               *
Status  IMS       Tran-Job  PSB name  PCB-DBD   PST#   Rgn Call Lock  Func      State         Recovery Token           UOW-1 (Originating)      UOW-1 (Processing)
Waiter  I15G      APPL0007  APPL0007  DI21PART  00001  MPP ISRT GBIDP 22400218  06-P          I15G    00001F9700000000 I15G    DD8F749EABF32680
Holder  I15G      APPL0017  APPL0017            00009  MPP                      06-P          I15G    00001FA500000000 I15G    DD8F749EFC716141
-----------------------------------------------------------------------------------------------------
DMB name=DI21PART  Lock name=00028001800701D7
key is root key for lock
Key Dump:
00000000   C6C7F7F8 E8D1D5E3 C8C9C5E6 F1F20000  00                                    *FG78YJNTHIEW12...               *
Status  IMS       Tran-Job  PSB name  PCB-DBD   PST#   Rgn Call Lock  Func      State         Recovery Token           UOW-1 (Originating)      UOW-1 (Processing)
Waiter  I15G      APPL0017  APPL0017  DI21PART  00009  MPP ISRT GBIDP 22400218  06-P          I15G    00001FA500000000 I15G    DD8F749EFC716141
Holder  I15G      APPL0027  APPL0027            00004  MPP                      06-P          I15G    00001F9100000000 I15G    DD8F749F08CEF541

 

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