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

Showing Answers 1 - 6 of 6 Answers

Sam

  • Sep 8th, 2006
 

The unit of work has been rolled back due to dead lock or commit-----SQL code 911

  Was this answer useful?  Yes

jayakumar

  • Sep 10th, 2006
 

ABEND -911:A deadlock has occured and the rollback is done sucessfullyABEND -913A deadlock has occured ,but the rollback was unsucessfulcheers,jai

bnirmalraj

  • Sep 26th, 2006
 

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                              

  Was this answer useful?  Yes

sangramkc

  • Nov 27th, 2006
 

for both -911 or -913 , you can check further

SQLERRD(3) also contains the reason-code which indicates whether a 
deadlock or timeout occurred. The most common reason codes are:    
                                                                   
o   00C90088 - deadlock                                            
                                                                   
o   00C9008E - timeout                                             

Thanks,

Sangram

Om jai sai ram

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions