What is difference between 911 and 913 error cod

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is difference between 911 and 913 error code in DB2 ?

911 - THE CURRENT UNIT OF WORK HAS BEEN ROLLED BACK DUE TO DEADLOCK OR TIMEOUT. REASON reason-code, TYPE OF RESOURCE resource-type, AND RESOURCE NAME resource-name

913-UNSUCCESSFUL EXECUTION CAUSED BY DEADLOCK OR TIMEOUT. REASON reason-code, TYPE OF RESOURCE resource-type, AND RESOURCE NAME resource-name

(Continued on next question...)

Other Job Interview Questions

• Can you have more than one cursor open at any one time in a program ? –
• What is RUNSTATS?
• EXPLAIN has output with MATCHCOLS = 0. What does it mean? –
• How do you specify and use a cursor in a COBOL program? –
• Where do you specify them ?
• What is filter factor?
• Explain difference between sys.cat and sys.ibm?
• What is REORG? When is it used?
• How is a typical DB2 batch pgm executed ?
• EXPLAIN has output with MATCHCOLS = 0. What does it mean? –
• More...