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?
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"?
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!!