Difference between 904 and 911



IBM's flagship relational database management system

Difference between 904 and 911

Postby fornanthakumar » Tue Jan 08, 2013 5:45 pm

Hi Everyone,

Complements of the new season.Happy Always.

Could anyone please tell me exactly when 904 and 911 happen ? because when resource is waiting for other resource it may abend in 904 (resource unavailable because other resource using it) and 911 (timeout because it has been waiting enough).

Please clarify.
Regards,
Nanthu.Y.
fornanthakumar
 
Posts: 69
Joined: Fri Oct 22, 2010 1:58 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Difference between 904 and 911

Postby tivrfoa » Tue Jan 08, 2013 5:58 pm

Just guessing ...
Maybe 904 can happen if the user doesn't has sufficient privilege or the resource was moved, deleted ...
904 gives you the reason code and type of resource that may be useful.

But are you asking only for curiosity? Did you get one error and think the other one is more appropriate?
tivrfoa
 
Posts: 84
Joined: Wed Aug 22, 2012 6:35 pm
Has thanked: 60 times
Been thanked: 0 time

Re: Difference between 904 and 911

Postby tivrfoa » Tue Jan 08, 2013 6:08 pm

fornanthakumar wrote:Could anyone please tell me exactly when 904 and 911 happen ? because when resource is waiting for other resource it may abend in 904 (resource unavailable because other resource using it) and 911 (timeout because it has been waiting enough).

where did you get these definitions?
-904 (resource unavailable because other resource using it)
-911 (timeout because it has been waiting enough)

Other guess: I think that 904 happens if it can't find the resource. And 911 the resource exists, but it's not available.
tivrfoa
 
Posts: 84
Joined: Wed Aug 22, 2012 6:35 pm
Has thanked: 60 times
Been thanked: 0 time

Re: Difference between 904 and 911

Postby enrico-sorichetti » Tue Jan 08, 2013 7:09 pm

why not look at the manual Yourself,
no reason for anybody to rewrite what is clearly explained there
cheers
enrico
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
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: Difference between 904 and 911

Postby BillyBoyo » Tue Jan 08, 2013 7:14 pm

It's an old joke, but the answer is seven.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: Difference between 904 and 911

Postby dick scherrer » Tue Jan 08, 2013 10:48 pm

Hello,

Could anyone please tell me exactly when 904 and 911 happen ?
Your posted "causes" for these codes is incorrect.
A -904 is because of an unavailable resource.
A -911 is due to a deadlock or a timeout (these are not the same).

Complete explanations are available via the "IBM Manuals" link at the top and bottom ofthe page. You need to look in the "DB2 ... Messages and Codes" for your release of DB2 (if your exact release is not in the list, use one slightly newer or older).
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post