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
 

 

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 Innovations in Your Mainframe Sort Arun Raj PC Guides & IT News 4 Wed Mar 15, 2017 10:38 pm
No new posts SORT VSAM file with each field one by... maxsubrat DFSORT/ICETOOL 6 Tue Mar 14, 2017 1:07 pm
No new posts SORT requirement sjiraga COBOL Programming 6 Thu Mar 09, 2017 9:11 pm
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am
No new posts SORT to append Month and YEAR in MMYY... tisamf DFSORT/ICETOOL 1 Wed Mar 08, 2017 4:46 pm


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