-904 error



IBM's flagship relational database management system

-904 error

Postby surime72 » Mon Sep 23, 2013 3:34 pm

Hi,

While I was updating the table it showing error message as -904 error

           UPDATE LPU@PDB.SNSPA02_PRICE
             SET PRC_EFFECTIVE_Y ='2013-09-01'
           WHERE COUNTRY_ISO3_C='AUS'
           AND PRC_EFFECTIVE_Y ='2013-09-14'
 SQL ERROR DURING EXECUTE IMMEDIATE
DSNT408I SQLCODE = -904, ERROR:  UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLRESOURCE. REASON 00C90096, TYPE OF
         RESOURCE 00000302, AND RESOURCE NAME SNSPA0RD.SNSPA02P.X'0A138D5B'
DSNT418I SQLSTATE   = 57011 SQLSTATE RETURN CODE
DSNT415I SQLERRP    = DSNXRRC  SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD    = 101  13172746  0  13817319  -470675450  0 SQL DIAGNOSTIC
DSNT416I SQLERRD    = X'00000065'  X'00C9000A'  X'00000000'  X'00D2D5E7'  X'E3F
         INFORMATION


Can you please advise how we can go ahead this kind of errors
surime72
 
Posts: 107
Joined: Sun Oct 23, 2011 1:45 pm
Has thanked: 0 time
Been thanked: 0 time

Re: -904 error

 

Re: -904 error

Postby NicC » Mon Sep 23, 2013 5:53 pm

First you have to identify which resource was unavailable then you have to work out what other process(es) use the resource and then you have to work out if all process are access ing the resource correctly and then decide if you need to change code or scheduling.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2690
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times

Re: -904 error

Postby Akatsukami » Mon Sep 23, 2013 11:49 pm

"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1053
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times

Re: -904 error

Postby surime72 » Tue Oct 08, 2013 7:44 pm

thanks for your reply
surime72
 
Posts: 107
Joined: Sun Oct 23, 2011 1:45 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post