Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between nvl and coalesce?
Is it possible using max on a char column?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is null indicator in cobol db2?
What is check constraint. Explain with example.
How to compare data between two tables in db2?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is view db2?
Which components manage deadlocks in db2?
What is db2 bind?
Can you tell me how can you find out the # of rows updated after an update statement?
Mention the location where the output received from explain statement is stored.
what are bind concepts in db2 cobol?
How to test SQL -911 error while developing COB-DB2 program
Where can you declare a cursor in a cobol-db2 program?