-904 error



IBM's flagship relational database management system

-904 error

Postby surime72 » Thu Feb 21, 2013 1:17 pm

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...!
surime72
 
Posts: 107
Joined: Sun Oct 23, 2011 1:45 pm
Has thanked: 0 time
Been thanked: 0 time

Re: -904 error

Postby enrico-sorichetti » Thu Feb 21, 2013 2:18 pm

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


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post