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
 

 

DFSORT to split tape files

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
Ricardo Moreira

New User


Joined: 20 Apr 2007
Posts: 15
Location: Brasil

PostPosted: Wed Dec 08, 2010 8:09 am    Post subject: DFSORT to split tape files
Reply with quote

I need a job that:
1 - Reads a file
2 - Split this read file in two or more files, using a few conditions
3 - With limit of records specified, for example 1000...

Actually, this file was created on tape because it has more than 40 million records... And I need to split it up by some kind of conditions.... By the way, this could be done in only one step ?

And another thing, when I try to copy this file to disk as its too big DASD gives an error, It shouldnt be alocating new volumes for the file ? Or do you think this was limited by the operator to avoid users creat files too big on DASD?

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

Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8086
Location: East Dubuque, Illinois, USA

PostPosted: Wed Dec 08, 2010 8:29 am    Post subject:
Reply with quote

Quote:
It shouldnt be alocating new volumes for the file ?
As many volumes as you told the system to use, but no more. What is the record length? How are you attempting to allocate the file on disk?

Most importantly, have you talked to your site support group since the storage management policies vary by site and only someone AT YOUR SITE will know the limits for your site?
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Dec 08, 2010 10:00 am    Post subject:
Reply with quote

Hello,

Keep in mind that if you split the tape file (which was too big for dasd) into multiple dasd datasets, the full amount of space (plus a small bit more) will still be needed.

If the original file required too much space, you should get permission to use the same amount even if allocated differently. . .

It may be possible to split the file in one step. You need to post the rules for splitting the file. You do not want to split the large file into sub-files of 1000 records. . . If you split this into files of 1 million records each, that will still be 40 files to manage. . .
Back to top
View user's profile Send private message
Ricardo Moreira

New User


Joined: 20 Apr 2007
Posts: 15
Location: Brasil

PostPosted: Wed Dec 08, 2010 6:05 pm    Post subject:
Reply with quote

Hi,

My conditions are:
Reads this file from the tape, chosing by pos (1:10 'C') = "0103561207", and for this for this condition ("0103561207") I just need a few rows, like 1000, and I would like to put the result rows in file1, and a second condition "0203561207" writing to file2.

I tried to reach Operation Suppport, but they cant help on that, they only say that when I make a copy from a file even if is too big, volumes should be alocated by it self.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Wed Dec 08, 2010 11:28 pm    Post subject:
Reply with quote

It's still not clear what you want to do. Your explanation of the "condition" for splitting the file is very confusing. You need to do a better job of explaining the "rules" for getting from input to output before anyone can help you. Do you only need output file1 and output file2, or do you need more output files?

DFSORT has lots of ways to split files (SPLIT1R, STARTREC, ENDREC, SAVE, etc) but which one you would use depends on what you're trying to do exactly.
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 -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts getting three output files out of JOI... migusd SYNCSORT 4 Mon Jun 05, 2017 11:30 pm
No new posts Unable to create multiple files using... mbattu COBOL Programming 3 Fri May 05, 2017 5:35 pm
This topic is locked: you cannot edit posts or make replies. Merge two files and update Trailer re... Yashashri JCL & VSAM 1 Thu May 04, 2017 12:54 pm
No new posts Length of Tape file Mohan Kothakota JCL & VSAM 9 Thu Apr 20, 2017 10:24 pm
No new posts Dynamic split of files under groups sril.krishy DFSORT/ICETOOL 4 Mon Apr 17, 2017 1:09 pm


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