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
List out the buffer pools in db2
Why cursor is used in db2?
Explain about mirror activator disk mirroring?
What is the function of logging in the db2 database?
What is nvl in db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is runstats db2?
When reorg is used?
Where can you declare a cursor in a cobol-db2 program?
How to create db2 table in mainframe?
what is db2 restart?
What is sqlca’s maximum length?
How to resolve deadlock issue
Which component is responsible for db2 startup and shutdown?
How to access db2 tables in mainframe?
