I have the below requirement which requires experts help.
1. I have 15 GDG bases (each base contains 1 generation). Each generation contains 1 or 2 millions of records in it. And the parameters used for each generation is as below:
2. Now I need to concatenate all the 25 generations and need to sort concatenated file.
3. Later the sorted output file will be given as input to another program which will produce the desired output.
1. For SORTOUT file, can I use the UNIT parameter as CTAPE itself? Will it hold the entire 15 generations data in it?
2. How many work files I need to use while sorting. And what could be the SPACE parameter I need to use for the work files?
Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
Are the individual files already in the same sequence as the combined file will be? "Merge" may be a better choice than "Sort". . .
As far as the output UNIT, suggest you talk with your storage management people. If you specify some kind of "tape" unit and the amount of output is more than a single "tape" volume will hold, additional volumes will be automatically written up to the volume limit on your system (again, your storage management people will know this).
Joined: 17 Aug 2007 Posts: 562 Location: Iowa, USA
Determining the SPACE needed for your 15 (or 25?) files is very basic.
The SPACE for workfiles will be the number of records * LRECL (bytes)and then reduced to CYLs. If these are tapes, you might be able to get the BLOCK count of each volume from the TMS and divide by two (2 blks per trk) for number of tracks.
Add some extra or allow secondary allocations.
Divide this across the number of SORTWKxx files to get size of each.