-904 Problem

mohanrkrishna · New User Joined: 18 Sep 2005 Posts: 1 Location: New jersey

Hi,

I am getting -904 problem when i am browsing DB2 table in M.FD.Please find the error log.Can anyone help me how to get rid of this.

DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00C90082, TYPE OF RESOURCE 00000200,
AND RESOURCE NAME E0078SUL.SUL#JLIF
DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXRRC SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 102 13172746 0 13223106 -974970876 12714050 SQL
DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000066' X'00C9000A' X'00000000' X'00C9C4C2'
X'C5E32004' X'00C20042' SQL DIAGNOSTIC INFORMATION

guptae · Posted: Mon Feb 20, 2006 10:56 am

Hi ,

-904 because the SQL statement could not be executed because resource'resource name' of type 'resource type' was not available at the time for the reason indicated by 'reason code'.
For that check in schduler what all job that hold exclusive lock on that resource & than after running those job resubmit it again.

Hope it might be helpful

ragshere · New User Joined: 20 Dec 2004 Posts: 70

Hi ,
This error occurs in one of below 2 conditions

1. when the tablespace (mentioned in the error) is in UT mode.that means only utilities can access the tablespace.

In this case contact DBA to change the tablespace mode to RW.

2. when any utility takes exclusive lock on the tablespace.
In this case , find out who locked the tablespace and wait until that utility completed. Then try to run your query.

Feel free to mail me if you have still doubts.

Thanks
Rags

DARAPRADEEP · New User Joined: 13 Apr 2005 Posts: 7

hi,
This error may be due to CHECK PENDING. CHECK YOUR table space is in check pending, if so run the CHECK DATA utility.

regards,
pradeep.

radhakrishnan82 · Posted: Mon Feb 20, 2006 6:40 pm

Check for the tablespace whether it is in RW mode.