SRS025E -911 Deadlock issues related to BULK_CKPT setting

Products

• Smart Restart

Issue/Introduction

Each deadlock occurs in relation to one of the CKPT_SYNCH tables (IGWG.CKPT_SYNCH).

In all cases where the deadlock happens the following messages are seen:
SRS012W - Checkpoint file I/O error during random read
SRSI120I - Job ID I4GZ840D12170015 assigned for this jobstep
SRS025E - SQLCODE = -911 following RMI call referencing SRS synchronization data
SRSI217E - SQL error while attempting to delete auxilary DB2 rows

Resolution

Change the parm BULK_CKPT(DB2) to BULK_CKPT(VSAM) to prevent use of the tables and use VSAM Access:

BULK_CKPT

Additional Information