SQLCODE -913

What SQLCODE -913 means

• -913 means your program was the victim of a deadlock or timeout.
• The SQLSTATE is 40502.
• The critical difference from -911: NO rollback has been done. Your program must issue the ROLLBACK.

-913 vs -911

• -911: DB2 rolled back automatically. You may retry.
• -913: DB2 did NOT roll back. You must EXEC SQL ROLLBACK before doing anything else.
• Continuing without a rollback leaves the unit of work in an unknown state.
• Never COMMIT after -913 without the rollback. You could commit partial work.

Handling -913 - rollback, then retry

• Issue EXEC SQL ROLLBACK immediately.
• Then retry the unit of work like -911: re-open cursors and re-establish position.
• Restart the unit of work from its beginning. Partial progress was rolled back.
• Example:
  
  EXEC SQL UPDATE EMP SET SALARY = :WS-NEW-SAL WHERE DEPTNO = :WS-DEPTNO END-EXEC EVALUATE SQLCODE WHEN 0 EXEC SQL COMMIT END-EXEC WHEN -913 DISPLAY 'Deadlock victim - rolling back' EXEC SQL ROLLBACK END-EXEC PERFORM RETRY-UNIT-OF-WORK WHEN OTHER DISPLAY 'Update failed. SQLCODE = ' SQLCODE EXEC SQL ROLLBACK END-EXEC STOP RUN END-EVALUATE.