| |
- Causa
- UNSUCCESSFUL EXECUTION CAUSED BY DEADLOCK OR TIMEOUT. REASON CODE reason-code, TYPE OF RESOURCE resource-type, AND RESOURCE
NAME resource-name.
The application was the victim in a deadlock or experienced a timeout.
The reason code indicates whether a deadlock or timeout occurred.
- Ação do sistema
- The SQL statement cannot be executed. If the SQL statement being executed was a cursor FETCH, DB2 closes the cursor.
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
- Resposta ao Desenvolvedor
- 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.
For more information about how CICS and TSO handle deadlocks, see Part 4 of DB2 Application Programming and SQL Guide.
SQLSTATE: 57033
© Copyright IBM Corp.
|
| |
