|
View previous topic :: View next topic
|
| Author |
Message |
Benjamin.L
New User
Joined: 11 Apr 2006
Posts: 17
Location: DL.PRC
|
|
|
|
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 |
|
 |
William Thompson
Global Moderator
Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ
|
|
|
|
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.... 
Have you attempted to perform the recomended "User Response"?
Bill |
|
| Back to top |
|
|
Benjamin.L
New User
Joined: 11 Apr 2006
Posts: 17
Location: DL.PRC
|
|
|
|
| thank you very much, I will try now |
|
| Back to top |
|
|
harry
New User
Joined: 27 Mar 2006
Posts: 31
|
|
|
|
Hi,
Please take the imgcopy for the part 230 of your database.Then it won't show -904. |
|
| Back to top |
|
|
mqqn
New User
Joined: 17 Jan 2007
Posts: 1
Location: East Peoria Illinois
|
|
|
|
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 |
|
|
megha7
New User
Joined: 09 Oct 2006
Posts: 2
Location: India
|
|
|
|
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 |
|
|
|
|
