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 |
how to resolve -811 error. give clear explination
My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??
For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?
What is host variable?
How to get the ddl of a table in db2?
What is copy book?
What does CURRENTDATA option in bind indicate
What is performance tuning db2?
What is the difference between plan and package in db2?
What is an intent lock?
What do you need to do before you do EXPLAIN ?
I use CS and update a page. Will the lock be released after I am done with that page?