diff between -911 and -913

raviprasath_kp · New User Joined: 20 Feb 2005 Posts: 65 Location: chennai

any body can explanin me breifely what is the diff between
diff between -911 and -913

i know -911-dead lock-updates rolled back
-913-dead lock-updates not rolled back

anybody can give some real time situation for this

thanks in advance

rsm_deepak · Posted: Mon Sep 17, 2007 3:21 pm

-911 THE CURRENT UNIT OF WORK HAS BEEN ROLLED BACK DUE TO DEADLOCK OR TIMEOUT.

Explanation: The current unit of work was the victim in a deadlock, or experienced a timeout, and had to be rolled back.

-913 UNSUCCESSFUL EXECUTION CAUSED BY DEADLOCK OR TIMEOUT.

Explanation: The application was the victim in a deadlock or experienced a timeout. Here generally, the application should terminate.

raviprasath_kp · New User Joined: 20 Feb 2005 Posts: 65 Location: chennai

thanks for your info

already i know that one,but i want to know some real time example

what type of situation -911 happend and when -913 happen

dick scherrer · Posted: Mon Sep 17, 2007 7:39 pm

Hello,

Hopefully, you will not get many "real time" examples. . .

Most deadlocks are the result of poor process flow design.