I was getting this error same error msg and it was because we were
running out of sort work space. We ended up reading a parameter in that
would make the cursor smaller so it could get enough sort space. Of
course, we had to make 3 or 4 runs to get all the data.
Regards, Mary
>>> "Diana Nagel "
<db2udbdba-ezmlmshield-x98060493.[Email address protected] 5/30/2007
2:04 PM >>>
It's the dsndb07 datasets it wants redefined.
Regards
diana
-----Original Message-----
From: Arild L*kke [mailto:db2udbdba-ezmlmshield-x50997921.[Email
address protected]
Sent: Wednesday, May 30, 2007 2:02 PM
To: LazyDBA Discussion
Subject: Sqlcode -904 - reason code 00C90084
Hello all !
We are running DB2 version 8 on z/OS. I've declareded a cursor and on
the OPEN statement I receive a -904 sqlcode with reason code 00C90084.
This message appears in the log:
20.37.49 STC05780 DSNT501I - DSNIWKFL RESOURCE UNAVAILABLE 227
227 CORRELATION-ID=TFHKUK06
227 CONNECTION-ID=DB2CALL
227 LUW-ID=DDVSNO.AP02DB2P.C0AC467F6C52=0
227 REASON 00C90084
227 TYPE 00000230
227 NAME 4K
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.
User Response: Delete and redefine the temporary data set(s) in
question, and then issue the -START DATABASE command to start the
temporary file.
My question is; Which temporary data set(s) needs to be expanded in
this case...?
Regards
Arild L*kke
ErgoGroup AS
Norway
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page