|
View previous topic :: View next topic
|
| Author |
Message |
vijikesavan
Active User
Joined: 04 Oct 2006
Posts: 118
Location: NJ, USA
|
|
|
|
Hi,
I've used a TSO/ISPF command to calculate sort work space needed while sorting a dataset. But I don't remember now.
Can anyone pls provide me some pointers?
Thanks
Viji |
|
| Back to top |
|
 |
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
| If you are using DFSORT I find it best to let DFSORT do it all for you. Only in a few exceptional circumstances have I bothered to specify SORTWKnn DD statements. |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
Hi,
If this thread could be in DFSORT/JCL forum, might be Frank, DFSORT moderator/ Alissa, SyncSort Support could suggest better.
From DFSORT manuals, as expat said
| Quote: |
| //SORTWKdd DD: Defines a work data set for a sort. Typically not needed, because DFSORT can allocate work data sets for a sort dynamically. |
And 'that' TSO command should be site-specific. |
|
| Back to top |
|
|
Ajay Baghel
Active User
.jpg)
Joined: 25 Apr 2007
Posts: 206
Location: Bangalore
|
|
|
|
Hi,
I used to follow the below process. Just try in your case:
1. Type on the command line:
SORTSPC followed by record format followed by logical record length followed by No of records in input dataset.
2. move the cursor at the line where where you want SORTWK dd statement to appear
3. Press enter
eg if there are 30000 recs and rec length=80 and recformat=FB
You can give following on command line:
SORTSPC FB 80 30000
Thanks
Ajay |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
Hi,
From SyncSort Manual:
| Quote: |
SORTWKnn DD: From 1 to 32 sort work files can be allocated using the SORTWKnn DD statement. Each has to be on 1 unit & 1 volume. You should allocate work space in cylinders for optimum performance. Do not code CONTIG, and only code RLSE & a secondary allocation amount if these are not set as sort defaults at your installation. SORTWKnn DD's are not used for a MERGE or a copy operation, or if the DYNALLOC parm is used. |
Further, this
should be site specific, would not work on many other sites. |
|
| Back to top |
|
|
|
|
