-913   UNSUCCESSFUL EXECUTION CAUSED BY DEADLOCK OR TIMEOUT. REASON CODE reason-code, TYPE OF RESOURCE resource-type, AND RESOURCE NAME resource-name

Explanation

The application was the victim in a deadlock or experienced a timeout. The reason code indicates whether a deadlock or timeout occurred.

reason-code
The DB2® reason code value that indicates the reason for the failure. For explanations of reason codes, see DB2 reason codes.
resource-type and resource-name
The type and name of the resource that the message identifies. For an explanation of resource-type and resource-name values, see Resource types.

System action

The statement cannot be processed. If the SQL statement being executed was a cursor FETCH, DB2 closes the cursor.

SQLERRD(3) also contains the reason-code value which indicates whether a deadlock or timeout occurred. The most common reason codes are:
  • 00C90088 - deadlock
  • 00C9008E - timeout

Programmer response

The application should either commit or roll back to the previous COMMIT. Then, generally, the application should terminate. See message DSNT376I for possible ways to avoid future deadlocks or timeouts.

SQLSTATE

57033