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
 

 

SortWork Area in JCL

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
Pons

New User


Joined: 25 May 2007
Posts: 61
Location: Coimbatore

PostPosted: Mon Aug 08, 2011 8:51 pm    Post subject: SortWork Area in JCL
Reply with quote

Hi,

I need some clarification on Sort Work Area. As per my understanding, if the input file is huge, the explicit sort work area is required. For small files, system allocated default work area is enough.

Is this correct? If so, suppose, what is the disadvantage of providing explicit workarea for small files (Even that is not required).

Please advise. Thanks.
Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7308

PostPosted: Mon Aug 08, 2011 9:22 pm    Post subject:
Reply with quote

If Dynamic sort work areas can be specified, that will be best - let the product allocate what it needs.

Otherwise you end up with tiny sorts have excessive DASD allocation, but only using a fraction.

If you specify sortwork when it is not needed, I suspect it will not use the sortwork you supply.
Back to top
View user's profile Send private message
Pons

New User


Joined: 25 May 2007
Posts: 61
Location: Coimbatore

PostPosted: Tue Aug 09, 2011 4:18 am    Post subject: Reply to: SortWork Area in JCL
Reply with quote

Oh. Is it so. I thought sork work area will be allocatted before it execute the sort utility.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Tue Aug 09, 2011 4:25 am    Post subject: Re: Reply to: SortWork Area in JCL
Reply with quote

Pons wrote:
Oh. Is it so. I thought sork work area will be allocatted before it execute the sort utility.


Bill,

the above response is typical of someone who does not know,
but will argue with you about your answer.

Pons,

suggest you refer to the user guide for whichever sort product you have.

the kind of information you are looking for is always in the manuals,
and then you would know, without asking and arguing.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Tue Aug 09, 2011 4:43 am    Post subject:
Reply with quote

If you specify a SORTWKdd DD statement, the system allocates the primary work space for it before DFSORT is invoked. DFSORT may or may not use all of the primary and may or may not get secondaries. So you can end up allocating space that isn't used.

If you don't specify SORTWKdd DD statements (or your site's installation default is set to deallocate them), DFSORT will use dynamic allocation of work data sets. DFSORT will adjust the allocated work space to what it thinks is needed. So you can still end up allocating space that isn't used, but the allocation is more flexible.

We recommend the use of dynamic allocation of work space. You can specify up to 255 dynamically allocated work data sets, so very large files can be accommodated.

For more information on DFSORT work space, see:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA50/A.0?DT=20100630155256
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Subschema of area to be unloaded Awanti IDMS/ADSO 0 Wed Mar 16, 2016 3:29 pm
No new posts ALTER of an IDMS AREA with NEW/OLD pa... Awanti IDMS/ADSO 2 Mon Mar 14, 2016 10:01 pm
No new posts PF7 and PF8 not working in Dynamic area Appu TSO/ISPF 6 Sat Dec 26, 2015 10:15 pm
No new posts CPU Consumption in Common Area Virendra Shambharkar COBOL Programming 8 Tue Sep 08, 2015 12:23 pm
No new posts write is not using the area from the ... xsray COBOL Programming 9 Thu Jan 08, 2015 5:07 am


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