what is the soft code for deadlock ?
Answers were Sorted based on User's Feedback
Answer / deepthy
-911 and -913 are the sqlcodes for deadlock. But DB2 attempts
to roll back the SQL for one of the application
processes. If the
ROLLBACK is successful, that application receives
SQLCODE -911. If the
ROLLBACK fails, and the application does not abend,
the application
receives SQLCODE -913.
| Is This Answer Correct ? | 4 Yes | 0 No |
What is bind in db2?
How to restart a DB2 program?
could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..
What is reorg in DB2
How does DB2 determine what lock-size to use?
what is the name of the default db2 catalog database?
What is the difference between base table and view?
What is bind plan?
Can we install 2 different versions of Db2 on same mainframe?
What is lock escalation in db2?
How can deadlocks be resolved?
How are write I/Os from the buffer pool executed?