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 load utility in db2?
What is netezza database?
Can a array declared with an index be displayed(readable format) in spool?
How do you do the EXPLAIN of a dynamic SQL statement?
What's the maximum number of volumes that can be added to a STOGROUP?
Can SQL statements/queries be included in a copybook?
Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?
What are db2 tables?
how to check the table is empty or not?
Which component is used to execute the sql statements?
How many buffer pools are available in db2?
What is runstats utility in db2?