-911 THE CURRENT UNIT OF WORK HAS BEEN ROLLED BACK DUE TO DEADLOCK OR TIMEOUT. REASON reason-code, TYPE OF RESOURCE resource-type, AND RESOURCE NAME resource-name
The current unit of work was the victim in a deadlock, or experienced a timeout, and had to be rolled back.
- 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.
- 00C90088 - deadlock
- 00C9008E - timeout
The statement cannot be processed. The application is rolled back to the previous COMMIT.
A long-running application, or an application that is likely to encounter a deadlock, should (if possible) issue frequent COMMIT commands. This can lessen the possibility of a deadlock occurring. See message DSNT376I for other possible ways to avoid future deadlocks or timeouts. On receipt of the SQLCODE -911, the application should, in general, terminate.