SQLCODE -904/ -911 ??

IBM's flagship relational database management system

SQLCODE -904/ -911 ??

Postby heshmahesh » Wed Nov 19, 2014 3:43 pm

-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.

Posts: 7
Joined: Mon Nov 10, 2014 5:49 pm
Has thanked: 0 time
Been thanked: 0 time

Re: SQLCODE -904/ -911 ??

Postby enrico-sorichetti » Wed Nov 19, 2014 4:36 pm

what happened when You looked at the manuals ...
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
Global moderator
Posts: 2999
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: SQLCODE -904/ -911 ??

Postby NicC » Wed Nov 19, 2014 7:56 pm

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.)
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Global moderator
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Return to DB2


  • Related topics
    Last post