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
 

 

The number of work files to be given for a SORT JCL

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

New User


Joined: 07 Mar 2005
Posts: 43

PostPosted: Tue May 17, 2005 1:12 pm    Post subject: The number of work files to be given for a SORT JCL
Reply with quote

while writting jcl for sorting we will give the work files along with the input and output files

in some case we give one workfile and in some case 3 or 4.

which constraint detrmines the number of work files to be given.
Back to top
View user's profile Send private message

ankyhunk

Moderator


Joined: 05 May 2005
Posts: 98
Location: Navi Mumbai, India

PostPosted: Tue May 17, 2005 2:30 pm    Post subject:
Reply with quote

I think the no. of work files depends on the number of fields on which the input file has to be sorted. i.e if the i/p file is to be sorted on 2 fields, 2 work files are required.
Back to top
View user's profile Send private message
dneufarth

Active User


Joined: 27 Apr 2005
Posts: 242
Location: Cincinnati OH USA

PostPosted: Tue May 17, 2005 6:40 pm    Post subject:
Reply with quote

The number of fields involved in the sort does not indicate quantity of work files. Input volume was the usual guide in the past along with sequence randomness of input. Spreading the work files across multiple volumes and devices expedited the sorting. With caching and physical dasd architecture shielded by logical architecture, I'm not sure there's any benefit other than handling the sheer volume of records.

Dave
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 May 17, 2005 8:43 pm    Post subject:
Reply with quote

For DFSORT, the number of work files required depends on the input filesize, the available memory, and the extent to which memory object sorting, hipersorting and data space sorting can be used.

For more information, see "Appendix A. Using Work Space" in "z/OS DFSORT Application Programming Guide" which you can access online at:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA10/A.0?DT=20050222160456
Back to top
View user's profile Send private message
jinal_mca

New User


Joined: 05 Jan 2007
Posts: 23
Location: Pune, India

PostPosted: Tue Jan 23, 2007 3:19 pm    Post subject: Re: The number of work files to be given for a SORT JCL
Reply with quote

See when ever temporary storage is needed we need to take working file so in case of sorting even in merging working file is needed..

That is for our system use so that it can store any temporary data in it.

correct m if i m wrong but i m sure so dont wory.

cya
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 Jan 23, 2007 10:21 pm    Post subject:
Reply with quote

Quote:
See when ever temporary storage is needed we need to take working file so in case of sorting even in merging working file is needed..

That is for our system use so that it can store any temporary data in it.

correct m if i m wrong but i m sure so dont wory.


I would correct you more specifically if I understood what you were saying here, but I don't.

Work data sets (SORTWKdd) are only needed for a SORT application. They are not needed and are ignored if specified for a MERGE or COPY application. Work data sets for a SORT application can be dynamically allocated by DFSORT (recommended) or specified via DD statements.
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 Reduce CPU Times for Join Sort santoshn SYNCSORT 12 Sat Jun 10, 2017 1:40 pm
No new posts getting three output files out of JOI... migusd SYNCSORT 4 Mon Jun 05, 2017 11:30 pm
No new posts Db2 load job abending in SORT mistah kurtz DB2 4 Mon Jun 05, 2017 3:58 pm
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


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