How many work files we need to use for Sorting

sambasivarao · New User Joined: 10 Jul 2006 Posts: 47 Location: Bangalore

Hi all,

Can you please let me know How many work files we need to use for Sorting. On what basis we will decide these many work files we need to use and what is the minimum fields or minimum length we need to use for sorting?

can you please clarify regarding this .

Thanks in advance for your help.

Thanks and Regards,
RSSRAO.

parikshit123 · Active User Joined: 01 Jul 2005 Posts: 269 Location: India

Hi,
The number of work files that you might need depends on the volume of data being sorted. This might be different from run to run. so, you need to take this into account.

However, if you don't spacify your work file in the JCL, then DFSORT takes care of this using a feature called "Dynamic allocation of work space".

Following link can help you understand this concept.

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/BOOKS/ICE1CA00/A.4?DT=20031124143823

Please let me know if you still have any questions.

vicky10001 · Active User Joined: 13 Jul 2005 Posts: 136

I think need to use 12 work files

//SORTWK01 DD SPACE=(CYL,(50,50),,,ROUND),UNIT=SYSDA
//SORTWK02 DD SPACE=(CYL,(50,50),,,ROUND),UNIT=SYSDA
--------------------

//SORTWK12 DD SPACE=(CYL,(50,50),,,ROUND),UNIT=SYSDA

Please find the space and unit

Frank Yaeger · Posted: Fri Jul 21, 2006 8:18 pm

sambasivarao · New User Joined: 10 Jul 2006 Posts: 47 Location: Bangalore

Hi Frank,

Thanks alot for sharing valuable info.

Thanks and Regards,
Rssrao.