IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

ICE077A 9 VSAM OUTPUT ERROR L(8) DATATSET


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
xpower

New User


Joined: 07 May 2006
Posts: 35

PostPosted: Mon Jul 05, 2010 4:32 pm
Reply with quote

I used the VSAM file as a output file, and its disp=mod, however,
the return code is ICE077A 9 VSAM OUTPUT ERROR L(8) DATASET

I checked the reference, it shows

A VSAM logical error, reason code 8, can occur for a non-empty KSDS, RRDS, or VRRDS output data set if NORESET is in effect, or if the data set is defined without the REUSE option.

but the VSAM file cannot be defined REUSE, so I think REUSE is not the key reason...what does the NORESET means?? how can we set it attribute??

Code:
//STEP010 EXEC PGM=ICETOOL                           
//TOOLMSG  DD   SYSOUT=*                             
//DFSMSG   DD   SYSOUT=*                             
//TOOLIN   DD   *                                   
    SORT FROM(CPBPLT) USING(SRT1)                   
//INFILE   DD   DSN=VSAM1,DISP=SHR
//OUTFILE DD   DSN=VSAM2,DISP=MOD   
//SRT1CNTL DD *                                     
   SORT FIELDS=(01,19,CH,A)     
   OUTFIL FNAMES=OUTFILE
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Mon Jul 05, 2010 4:43 pm
Reply with quote

What are you trying to do, add records to the file or to treat the file as new.

If it is the second option, use ALTER to put the cluster to REUSE, then load the data and use ALTER to go back to NOREUSE.
Back to top
View user's profile Send private message
xpower

New User


Joined: 07 May 2006
Posts: 35

PostPosted: Mon Jul 05, 2010 4:47 pm
Reply with quote

Hi expat,

i wanna put the records to the existing vsam file(not treate the fils as new)

Best Regards,
Shaw
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Mon Jul 05, 2010 4:57 pm
Reply with quote

Not sure on how ICETOOL treats the VSAM file when it opens it, but DISP=MOD has no effect for VSAM files. Might be one for Frank / Kolusu to comment on.

A few options that spring to mind ............

1) Sort the new records into key sequence and then use REPRO to insert them to the VSAM file.
2) Insert the records using a program.
3) Use ICETOOL to sort the new records and the existing VSAM file to new VSAM file and then rename the original and new file.
Back to top
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2146
Location: At my coffee table

PostPosted: Mon Jul 05, 2010 6:58 pm
Reply with quote

xpower wrote:
i wanna put the records to the existing vsam file(not treate the fils as new)
For a sequential VSAM dataset, I think that is possible, but I can't see how Sort would be able to insert keyed records into an existing KSDS dataset since Sort does not know what the key is and I can find no Sort parameter to specify it.

An output data set defined without REUSE is processed as MOD.
If RESET is in effect, an output data set defined with REUSE is processed as NEW. If NORESET is in effect, an output data set defined with REUSE is processed as MOD.


RESET
specifies that DFSORT processes a VSAM output data set defined with REUSE as a NEW data set. The high-used RBA is reset to zero and the output data set is effectively treated as an initially empty cluster.
NORESET
specifies that DFSORT processes a VSAM output data set defined with REUSE as a MOD data set. The high-used RBA is not reset and the output data set is effectively treated as an initially non-empty cluster.
Back to top
View user's profile Send private message
Pete Wilson

Active Member


Joined: 31 Dec 2009
Posts: 582
Location: London

PostPosted: Wed Jul 14, 2010 5:16 pm
Reply with quote

When a VSAM cluster is defined with REUSE and is not empty, and you write to it in Batch with a REPRO with the REUSE parameter then VSAM does a RESET (resets the HI-USE-RBA to 0) which in effect empties the file and is like writing to a QSAM file with DISP=OLD, writing from the start of the file.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts TRIM everything from input, output co... DFSORT/ICETOOL 1
No new posts Error to read log with rexx CLIST & REXX 11
No new posts Error when install DB2 DB2 2
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts Sortjoin and Search for a String and ... DFSORT/ICETOOL 1
Search our Forums:

Back to Top