IDMSBCF OCF deadlock on LTXNLOCK Access Module Drop Create Alter

Products

• IDMS
• IDMS - Database

Issue/Introduction

Running IDMSBCF in batch or OCF online to DROP and CREATE multiple Access Modules causes deadlocks on record LOADHDR-156 in area DDLCATLOD:

IDMSBCF  P:IDMSBCF  C:DEAD WAITING ON R:LTXNLOCK 00020008 016FDF01   
IDMSBCF  P:IDMSBCF  C:DEAD DEADLOCKED ON R:LTXNLOCK 00020008 016FDF01

T7028 Program.....: RHDCRUAL     
T7028 Subschema...: IDMSCATL     
T7028 Error Status: 0329         
T7028 Last DBkey..: 01721D06     
T7028 Error Set...: CALC         
T7028 Error Record: LOADHDR-156  
T7028 Error Area..: DDLCATLOD    
T7028 Program.....: RHDCRUAL     
T7028 Subschema...: IDMSCATL     
T7028 Error Status: 0077         
T7028 Last DBkey..: 01721D06     
T7028 Error Set...: CALC         
T7028 Error Record: LOADHDR-156  
T7028 Error Area..: DDLCATLOD    

DC076020 V11 T7028 Error Record: LOADHDR-156          
DC076021 V11 T7028 Error Area..: DDLCATLOD            

 

 

Environment

Release : 19.0

Component : IDMS/DB

Cause

Using a combination of DROP, ALTER or CREATE ACCESS MODULE in the same IDMSBCF or OCF session can result in deadlocks.

Resolution

To avoid the deadlock either:

• Add a COMMIT statement after each ACCESS MODULE statement.
• Code a SET OPTIONS AUTOCOMMIT COMMAND as the first statement to automatically issue a COMMIT after each command.     

                 

 

Additional Information

See the IDMS documentation sections COMMIT and  Using SET OPTIONS to Select Options