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