View previous topic :: View next topic |
Author |
Message |
Fin Beginner
Joined: 19 Jan 2004 Posts: 27 Topics: 8
|
Posted: Thu Dec 16, 2004 1:07 pm Post subject: Syncort / temp dataset / space problem |
|
|
I have an input file with approx 8 million records and I need to sort it using SYNCSORT and create a temporary output file. However I dont have enough space in DASD for the temporary dataset - do I need to chop my input file into smaller files or is there any way round the space problem? |
|
Back to top |
|
 |
kolusu Site Admin

Joined: 26 Nov 2002 Posts: 12377 Topics: 75 Location: San Jose
|
Posted: Thu Dec 16, 2004 1:09 pm Post subject: |
|
|
Fin,
What exactly are you trying to do ? Are you sorting the file and feeding it into another program ?
You can increase the space allocation on a temporary just like any regular dataset.
Kolusu _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
 |
Fin Beginner
Joined: 19 Jan 2004 Posts: 27 Topics: 8
|
Posted: Thu Dec 16, 2004 1:23 pm Post subject: |
|
|
I am afraid the job will abend due to system space limitations in DASD....I do not have facility to test with such a large input data set in my area so I have to let it go to a production system to find out..anyway I will give it a try and see how it goes.
Thanks for the advice. |
|
Back to top |
|
 |
Phantom Data Mgmt Moderator

Joined: 07 Jan 2003 Posts: 1056 Topics: 91 Location: The Blue Planet
|
Posted: Fri Dec 17, 2004 12:19 am Post subject: |
|
|
Fin,
Did u try to store the dataset in COMPRESSED volume ? If u have problem allocating huge space as a bulk, you can probably try to split the output file in chunks of 3-5 files using OUTFIL option of SORT. Say 1.2 million records in each file (first 1.2 million in file 1, 2nd 1.2 million in file 2 and so on).
Thanks,
Phantom |
|
Back to top |
|
 |
|
|