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 Strings with double quotes having pro... raja Arumugam All Other Mainframe Topics 11 Thu Mar 30, 2017 10:34 am
No new posts Problem reading GTF trace output danik56 ABENDS & Debugging 7 Thu Mar 16, 2017 1:02 pm
No new posts ROUNDED Problem with COMPUTE statement shalem COBOL Programming 11 Thu Feb 09, 2017 8:16 pm
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


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