Using the Deadlock Report - Documentation for Bmc Ami Log Analyzer for Ims 1.7

The Deadlock report provides information about record lockout situations, also known as a deadly embrace between two or more transactions.

In this situation, 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.

 2009-040                                         Log Analyzer for IMS V1.2.00.03                               Page 1   
                                                 Deadlock report      (DEADLOCK) R=A                                         
LOG time span: FROM 2009-015 14:18:51.71 TO 2009-016 10:09:03.41 DURATION 19:50:11                                      
Deadlock # 00001   (# participants=003)                                                                                 

DMB name=DI21PART  Lock name=814D67DD800301D7                                                                           
key is root key for lock                                                                                                
Key Dump:                                                                                                               
00000000   C1F1F0F0 F0C6E3E8 E4C9F1F1 F1F1F1F2                                        *A1000FTYUI111112                *
Status  IMS       Tran-Job  PSB name  PCB-DBD   PST#   LUOW#    Rgn Call Lock  Func      State                          
Waiter  PRAI      IRLM2001  IRLM2001  DI21PART  00002  unknown  MPP GET  GRIDX 30400358  06-P   Victim                  
Holder  PRAI      IRLM2002  IRLM2002            00001  unknown  MPP                      06-P                           
-----------------------------------------------------------------------------------------------------                   
DMB name=IVPDB1    Lock name=00001D4A800401D7                                                                           
key is root key for lock                                                                                                
Key Dump:                                                                                                               
00000000   5B5BF1F0 F0F1F0F0 F0                                                       *$$1001000                       *
Status  IMS       Tran-Job  PSB name  PCB-DBD   PST#   LUOW#    Rgn Call Lock  Func      State                          
Waiter  PRAI      IRLM2002  IRLM2002  IVPDB1    00001  unknown  MPP GET  GRIDX 30400358  06-P                           
Holder  PRAM      IRLM2003  IRLM2003            00002  unknown  MPP                      06-P                           
-----------------------------------------------------------------------------------------------------                   
... data omitted ...
2009-047                                         Log Analyzer for IMS V1.2.00.03                               Page 3    
                                                 Deadlock report      (DEADLOCK) R=A                                          
LOG time span: FROM 2009-015 14:18:51.71 TO 2009-016 10:09:03.41 DURATION 19:50:11                                       
Deadlock # 00003   (# participants=004) **entries not sorted**                                                           

DMB name=IVPDB1    Lock name=00001D4A800401D7                                                                            
key is root key for lock                                                                                                 
Key Dump:                                                                                                                
00000000   5B5BF1F0 F0F1F0F0 F0                                                       *$$1001000                       * 
Status  IMS       Tran-Job  PSB name  PCB-DBD   PST#   LUOW#    Rgn Call Lock  Func      State                           
Waiter  PRAI      IRLM2002  IRLM2002  IVPDB1    00001  0000112  MPP GET  GRIDX 30400358  06-P                            
Holder  PRAM      IRLM2003  IRLM2003            00002  0000123  MPP                      00                              
-----------------------------------------------------------------------------------------------------                    
DMB name=IVPDB1    Lock name=0000297E800401D7                                                                            
key is root key for lock                                                                                                 
Key Dump:                                                                                                                
00000000   F9F9F9F8 F8F060F9 F0                                                       *999880-90                       * 
Status  IMS       Tran-Job  PSB name  PCB-DBD   PST#   LUOW#    Rgn Call Lock  Func      State                           
Waiter  PRAM      IRLM2003  IRLM2003  IVPDB1    00002  0000123  MPP GET  GRIDX 30400358  06-P   Victim                   
Holder  NOTAVAIL                                                                                                         
-----------------------------------------------------------------------------------------------------                    
DMB name=DI21PART  Lock name=AD8B18FD800301D7                                                                           
key is root key for lock                                                                                                
Key Dump:                                                                                                               
00000000   F6F7F8D8 E6D9F8C9 E2C5E4F8 E2C6D2F1                                        *678QWR8ISEU8SFK1                *
Status  IMS       Tran-Job  PSB name  PCB-DBD   PST#   LUOW#    Rgn Call Lock  Func      State                          
Waiter  PRAM      IRLM2004  IRLM2004  DI21PART  00003  0000123  MPP GET  GRIDX 30400358  06-P                           
Holder  PRAI      IRLM2001  IRLM2001            00002  0000123  MPP                      06-P                           
-----------------------------------------------------------------------------------------------------                   
DMB name=DI21PART  Lock name=814D67DD800301D7                                                                           
key is root key for lock                                                                                                
Key Dump:                                                                                                               
00000000   C1F1F0F0 F0C6E3E8 E4C9F1F1 F1F1F1F2                                        *A1000FTYUI111112                *
Status  IMS       Tran-Job  PSB name  PCB-DBD   PST#   LUOW#    Rgn Call Lock  Func      State                          
Waiter  PRAI      IRLM2001  IRLM2001  DI21PART  00002  0000123  MPP GET  GRIDX 30400358  06-P                           
Holder  PRAI      IRLM2002  IRLM2002            00001  0000112  MPP                      06-P

This section contains the following topics:

Related topic

James H. Sterling

James H. Sterling

Environmental Science & Climate Journalist

James Sterling reports on renewable energy developments, climate policy, ecological conservation, and green tech innovations around the globe.

Share this article
Twitter Facebook Pinterest