Page 1 of 1

SQLCODE -904/ -911 ??

PostPosted: Wed Nov 19, 2014 3:43 pm
by heshmahesh
Hi,
-904 - refers resource unavilable

-911 - roll back due to dead lock or timeout.

My doubt is,
for -911 - if the table is processed by an user it will be in a hold and waiting for queue occurs for timeout.

But what specially mean,

i heared that for -904 occurs also for some lock reason

can u explain -904 ? what are the difference between -904 and -911.


thanks,
Mahesh

Re: SQLCODE -904/ -911 ??

PostPosted: Wed Nov 19, 2014 4:36 pm
by enrico-sorichetti
what happened when You looked at the manuals ...

Re: SQLCODE -904/ -911 ??

PostPosted: Wed Nov 19, 2014 7:56 pm
by NicC
I am not going to look up the manual for you - there are links at the top and bottom of every page in the forum.

But, if the descriptions given by you are reasonably accurate then you can surmise that with a -904 the transaction never got started but for a -911 the transaction started but got rolled back to the last commit point. But you will have to verify this for yourself.

However, I seem to recall that this question was asked a few months ago so you should have reached that topic when you did a search. (Of course, it may have been on another forum that I came across it.)