In this post, you’ll learn about the error message -913 unsuccessful execution caused by deadlock or timeout.� reason code 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
-913 unsuccessful execution caused by deadlock or timeout.� reason code reason code, type of resource resource type, and resource name resource name
Reason for the Error
Your program was the victim of a deadlock or timeout.
NO rollback has been done.
You should do a ROLLBACK.
The application was the victim in a deadlock or experienced a timeout.� The reason code indicates whether a deadlock or timeout occurred.
Solution
The application should either commit or roll back to the previous COMMIT.� Then, in general, the application should terminate. See message DSNT376I for possible ways to avoid future deadlocks or timeouts.