In this post, you’ll learn about the error message -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 in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-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
Reason for the Error
Deadlock or timeout. Rollback has been done.
The current unit of work was the victim in a deadlock, or experienced a timeout, and had to be rolled back. The reason code indicated whether a deadlock or timeout occurred.�SQLERRD(3) also contains the reason-code which indicates whether a deadlock or timeout occurred. The most common reason codes are:
00C90088 – deadlock
00C9008E – timeout
Solution
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. : Review DB2 Master Log to find process holding DB2 locks. Consider adding additional COMMITs to program holding the DB2 resource.
