Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

-904 Problem

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
mohanrkrishna

New User


Joined: 18 Sep 2005
Posts: 1
Location: New jersey

PostPosted: Mon Feb 20, 2006 3:04 am    Post subject: -904 Problem
Reply with quote

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
Back to top
View user's profile Send private message

guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Mon Feb 20, 2006 10:56 am    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
ragshere

New User


Joined: 20 Dec 2004
Posts: 70

PostPosted: Mon Feb 20, 2006 11:14 am    Post subject: Re: -904 Problem
Reply with quote

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
Back to top
View user's profile Send private message
DARAPRADEEP

New User


Joined: 13 Apr 2005
Posts: 7

PostPosted: Mon Feb 20, 2006 3:03 pm    Post subject: Re: -904 Problem
Reply with quote

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.
Back to top
View user's profile Send private message
radhakrishnan82

Active User


Joined: 31 Mar 2005
Posts: 436
Location: chennai, India

PostPosted: Mon Feb 20, 2006 6:40 pm    Post subject:
Reply with quote

Check for the tablespace whether it is in RW mode.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SYMNAMES problem jacobdng DFSORT/ICETOOL 7 Thu Dec 22, 2016 7:47 am
No new posts Problem in writing Output file vickey_dw COBOL Programming 5 Mon Nov 14, 2016 11:14 pm
No new posts Problem in Running Query via JCL vickey_dw DB2 3 Tue Oct 18, 2016 11:11 pm
No new posts DB2 Streaming Batch Processing Problem Manshadi DB2 4 Sat Sep 24, 2016 12:14 pm
No new posts Problem with GETMAIN command amitc23 CICS 6 Thu Sep 01, 2016 1:01 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us