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
 

 

IDCAMS copy ** Source : flat file ** Destination:VSAM

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
Verma,Raman

New User


Joined: 13 Oct 2006
Posts: 15

PostPosted: Wed Feb 07, 2007 12:58 pm    Post subject: IDCAMS copy ** Source : flat file ** Destination:VSAM
Reply with quote

Hi,

My JCL needs to copy a flat file ( record count : 563670 ) into a VSAM file.
Out of the total count given above, 9100 records are not being copied as it gives me the following msg...

IDC3302I ACTION ERROR ON TU47.N@AR.INTERNAL.FORMAT.VSAM
IDC3314I **RECORD OUT OF SEQUENCE - KEY FOLLOWS:
000000 F6F9F8F1 F0F8F3F6 F9F1F0F0 F0F0F0

I ve looked into the msg and there ( in programmer's response ) was a mention of using "skip sequential processing".

Que 1. It asks me to rerun the step with the above "skip sequential processing". How to do that?

Que. 2.Does this "skip sequential processing" require Reuse option to be set for the VSAM file?

Que. 3. I ve read somewhere that during such a copy process, the system stops processing the command ( maybe abends ) if it encounters 4 cases of RECORD OUT OF SEQUENCE. Why hasnt it done so in my case?

Sequencing the input file is not a solution for me as the file size is huge...
Plz help

Raman
Back to top
View user's profile Send private message

William Thompson

Global Moderator


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

PostPosted: Wed Feb 07, 2007 2:27 pm    Post subject:
Reply with quote

You are attempting to load a KSDS file with data that is out of sequence. rather than "skip sequential" processing, sort the input instead of just copying it.
Back to top
View user's profile Send private message
Verma,Raman

New User


Joined: 13 Oct 2006
Posts: 15

PostPosted: Wed Feb 07, 2007 2:56 pm    Post subject:
Reply with quote

Hi William,

I am sorting the file in a previous step. But that sort is not being comprehensive and some records are being missed.

Meanwhile, I tried with some other sort criterias on the same file and got some success...now the problem records are reduced to 35 from 9100 but they are still there.
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: Wed Feb 07, 2007 3:07 pm    Post subject:
Reply with quote

No records are being missed, the sort is not sorting the complete KSDS key, fix that and all will be good.
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SORTJOIN - Copy Matched and Unmatched... Steve Ironmonger DFSORT/ICETOOL 5 Tue Jan 17, 2017 4:26 pm
No new posts how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 3 Wed Jan 11, 2017 6:18 pm
No new posts Underlying DB2 VSAM LDS - SMF recording vasanthz All Other Mainframe Topics 6 Thu Jan 05, 2017 4:20 am
No new posts HALDB data refresh/copy from producti... vineetanand2007 IMS DB/DC 0 Mon Jan 02, 2017 11:16 am
No new posts Copy RECFM =VB TO FB file with RECL =... sahil41352 DFSORT/ICETOOL 3 Wed Dec 28, 2016 11:29 pm


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