Page 1 of 1

-904 error

PostPosted: Thu Feb 21, 2013 1:17 pm
by surime72
Hi Guys,

Can you please help what are the ways to resolve -904 error in db2,i know it -904 is for un available resorce,but on which basis it will throuh these error...!

Re: -904 error

PostPosted: Thu Feb 21, 2013 2:18 pm
by enrico-sorichetti
the <general> look of the related message is
DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00C90096, TYPE OF RESOURCE 00000302, AND
RESOURCE NAME <resource name> .X'503D68'


unfortunately the answers You will get on ANY forum will be pretty generic

using the manual decode the REASON and the TYPE OF RESOURCE
after that have You support take the proper action to make the resource available
and to find why the resource was/is not available is the fun of the problem determination

the investigation on the why must be carried on at Your location
issuing the proper commands and looking at the events which happened before the message

/humor on
if a <short sighted> car engine complained about the unavailability/shortage of fuel
You would have to check for
1) the tank containing enough fuel
2) clogged pipes

DB2 is the same
some <engine> finds that what it needs is not available and tells using the -904 device
<You> will have to do a bit of homework to find the chain of events :D