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 rebind in db2?
when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations
What is auditing?
What is the purpose of the WHENEVER statement?
How do I start db2 in windows?
What is a clustered index?
What is load utility in db2?
What is the difference between cursor and select statement?
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)
Is it possible using max on a char column?
What do you mean by storage group (stogroup)?