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
 

 

SQLCODE=-904: Unavailable resourse

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

New User


Joined: 11 Apr 2006
Posts: 17
Location: DL.PRC

PostPosted: Sat Jan 13, 2007 4:33 pm    Post subject: SQLCODE=-904: Unavailable resourse
Reply with quote

Hi ,

The job is to unload data from two joined tables.
The SQLCODE=-904, and the message is "ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON 00C90084, TYPE OF RESOURCE 00000230, AND RESOURCE NAME 4K ".
I checked the two tables are available.

Could you pls tell me what causes this problem and how to solve 904?
Thanks!
Back to top
View user's profile Send private message

William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Sat Jan 13, 2007 5:11 pm    Post subject:
Reply with quote

Hi Benjamin,

The fine manual says:
Quote:
00C90084
Explanation: The temporary file with the page size shown in NAME is not available. An error was detected either during the opening of the page set or during the formatting of the header and the space map pages of the page set.
This reason code is issued by the following CSECTs: DSNIWKFL, DSNITFFS

System Action: DB2 startup/restart continues if this reason code appears in a DSNT500I message issued during the startup process.

If the reason code appears in a DSNT500I message issued during the -START DATABASE command, the request fails. In either case, the temporary file function does not allocate any temporary file on the page set.

User Response: Delete and redefine the temporary data set(s) in question, and then issue the -START DATABASE command to start the temporary file.

Problem Determination: The requested operation is not performed. An SQLCODE -904 is issued, and/or message DSNT500I is issued. For more information, refer to the SQL return code in "Section 2. SQL Return Codes" in topic 2.0, or to the description of the DSNT500I message in "DSNT... Messages" in topic 3.15.
But, of course, you already knew this.... icon_smile.gif
Have you attempted to perform the recomended "User Response"?

Bill
Back to top
View user's profile Send private message
Benjamin.L

New User


Joined: 11 Apr 2006
Posts: 17
Location: DL.PRC

PostPosted: Sat Jan 13, 2007 5:20 pm    Post subject:
Reply with quote

thank you very much, I will try now
Back to top
View user's profile Send private message
harry

New User


Joined: 27 Mar 2006
Posts: 31

PostPosted: Wed Jan 17, 2007 3:14 pm    Post subject:
Reply with quote

Hi,

Please take the imgcopy for the part 230 of your database.Then it won't show -904.
Back to top
View user's profile Send private message
mqqn

New User


Joined: 17 Jan 2007
Posts: 1
Location: East Peoria Illinois

PostPosted: Wed Jan 17, 2007 10:52 pm    Post subject:
Reply with quote

Hi Benjamin.L -

Sounds like not enough 4k temp file space -

Resource type 230 = temp file, not a database or partition number.

I have seen this when cartesian products are produced in a join - check your join for incomplete join predicates, and review the 4k buffer space allocations.

best regards -

mqqn
Back to top
View user's profile Send private message
megha7

New User


Joined: 09 Oct 2006
Posts: 2
Location: India

PostPosted: Thu Jan 18, 2007 6:31 pm    Post subject: Re: Error: SQLCODE=-904: Unavailable resourse
Reply with quote

hi,

I got the same -904 error for a pgm yday but with reason code: 00D70014. Mine was bcoz the table on which that pgm was supposed to perform insertions got full.. so we had to delete some rows and rerun .. and then it worked fine. Hope this helps! But, ofcourse I see you are dealing with unloading data from the tables!!

Thanks,
Megha
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 SQLCODE-000000080N priya91 DB2 1 Mon Feb 01, 2016 4:35 pm
No new posts Need to understand SQLCODE = 12 rohanthengal DB2 3 Thu Nov 05, 2015 11:22 am
No new posts SQLCODE -922 in Batch-Cics program tr... kishpra CICS 2 Thu Sep 10, 2015 12:36 pm
No new posts SQLCODE -450 for stored procedure spoorni DB2 3 Fri Jan 16, 2015 2:45 am
No new posts -81 SQLCODE returned when Remote Stor... kameswaramanoj.Akella DB2 1 Wed Dec 03, 2014 5:36 am


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