IBM Mainframe Forum

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.

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?

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.

why not look at the manual Yourself,
no reason for anybody to rewrite what is clearly explained there

It's an old joke, but the answer is seven.

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