Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 ISSUE IN copying Sequential file reco... thesumitk JCL & VSAM 2 Wed Dec 13, 2017 3:07 pm
No new posts File Tailoring -- Temporary dataset i... samzee71 CLIST & REXX 3 Fri Dec 01, 2017 3:12 am
No new posts Rexx - File tailoring samzee71 CLIST & REXX 10 Thu Nov 30, 2017 10:47 pm
No new posts Compare VSAM files using DFSORT pshongal DFSORT/ICETOOL 5 Thu Nov 23, 2017 10:24 am
No new posts Moving a PS file as body of a mail! Vignesh Sid JCL & VSAM 4 Tue Nov 21, 2017 9:23 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us