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
 
TSO/ISPF command to calculate sort work space

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> TSO/ISPF
View previous topic :: :: View next topic  
Author Message
vijikesavan

Active User


Joined: 04 Oct 2006
Posts: 118
Location: NJ, USA

PostPosted: Thu Mar 13, 2008 9:42 pm    Post subject: TSO/ISPF command to calculate sort work space
Reply with quote

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
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Fri Mar 14, 2008 10:41 am    Post subject:
Reply with quote

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
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Fri Mar 14, 2008 2:10 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Ajay Baghel

Active User


Joined: 25 Apr 2007
Posts: 205
Location: Bangalore

PostPosted: Fri Mar 14, 2008 9:19 pm    Post subject: Reply to: TSO/ISPF command to calculate sort work space
Reply with quote

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
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Fri Mar 14, 2008 10:15 pm    Post subject:
Reply with quote

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
Quote:
SORTSPC
should be site specific, would not work on many other sites.
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 -> TSO/ISPF All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts sort records based on length exceeds ... maxsubrat DFSORT/ICETOOL 7 Wed Oct 04, 2017 4:48 pm
No new posts JOINKEYS Paired and Unpaired Sort MFwhiz DFSORT/ICETOOL 4 Fri Sep 29, 2017 1:48 am
No new posts MQ command in option 6 of ISPF! Vignesh Sid All Other Mainframe Topics 3 Tue Sep 26, 2017 6:01 pm
No new posts The TS7720 is out of cache space. Rex Montemayor All Other Mainframe Topics 2 Mon Sep 25, 2017 7:18 am
No new posts Difference in SORT & ICETOOL Mohan Kothakota DFSORT/ICETOOL 5 Fri Sep 22, 2017 4:56 pm

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