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 How to change 'K' or 'M' use Sort vice_versa DFSORT/ICETOOL 5 Thu May 18, 2017 7:11 am
No new posts Fileaid 2 commands instream work. In ... descann Compuware & Other Tools 2 Tue May 16, 2017 3:31 pm
No new posts Adding big TEXT lines to each record ... bshkris SYNCSORT 4 Sat May 06, 2017 1:40 am
This topic is locked: you cannot edit posts or make replies. SORT trick needed bshkris SYNCSORT 6 Tue May 02, 2017 4:35 am
No new posts VSAM Space Allocation mrgnndhmk JCL & VSAM 7 Sat Apr 22, 2017 12:42 am


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