IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

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


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
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
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
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: 419
Location: Inside the SPEW (Southwest Ohio, USA)

PostPosted: Tue May 17, 2005 6:40 pm
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 Developer


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

PostPosted: Tue May 17, 2005 8:43 pm
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:

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: 22
Location: Pune, India

PostPosted: Tue Jan 23, 2007 3:19 pm
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 Developer


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

PostPosted: Tue Jan 23, 2007 10:21 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts isfline didnt work in rexx at z/OS ve... CLIST & REXX 7
No new posts Write line by line from two files DFSORT/ICETOOL 7
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Pulling a fixed number of records fro... DB2 2
Search our Forums:

Back to Top