IBM Mainframe Forum

Posted: **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

Posted: **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.

Posted: **Mon Sep 23, 2013 11:49 pm**

All in the fine manual.

Posted: **Tue Oct 08, 2013 7:44 pm**

thanks for your reply

IBM Mainframe Forum

-904 error

-904 error

Re: -904 error

Re: -904 error

Re: -904 error