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
 

 

How many work files we need to use for Sorting

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
sambasivarao

New User


Joined: 10 Jul 2006
Posts: 47
Location: Bangalore

PostPosted: Fri Jul 21, 2006 10:54 am    Post subject: How many work files we need to use for Sorting
Reply with quote

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.
Back to top
View user's profile Send private message

parikshit123

Active User


Joined: 01 Jul 2005
Posts: 269
Location: India

PostPosted: Fri Jul 21, 2006 11:12 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
vicky10001
Warnings : 1

Active User


Joined: 13 Jul 2005
Posts: 136

PostPosted: Fri Jul 21, 2006 11:31 am    Post subject:
Reply with quote

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
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: Fri Jul 21, 2006 8:18 pm    Post subject:
Reply with quote

Quote:
I think need to use 12 work files


Huh? Where did you get that from? Do you think you need 12 work data sets for sorting 5 records and sorting 500,000 records and sorting 5,000,000 records? That makes absolutely no sense.

As Parikshit correctly stated, the amount of work space needed depends on the amount of data to be sorted. It also depends on the resources available for a particular run. For example, DFSORT can use memory objects, expanded storage or data space when appropriate along with virtual storage, which can reduce the amount of work space needed or even eliminate it entirely. That's why we recommend using DFSORT's dynamic allocation feature instead of specifying SORTWKdd DDs. Dynamic allocation allows DFSORT to adjust the work space it allocates automatically for each particular DFSORT run.
Back to top
View user's profile Send private message
sambasivarao

New User


Joined: 10 Jul 2006
Posts: 47
Location: Bangalore

PostPosted: Mon Jul 24, 2006 10:22 am    Post subject: How many work files we need to use for Sorting
Reply with quote

Hi Frank,

Thanks alot for sharing valuable info.

Thanks and Regards,
Rssrao.
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 -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Sorting of hex values Saurabh_mi DFSORT/ICETOOL 11 Thu May 25, 2017 3:49 pm
No new posts Fileaid 2 commands instream work. In ... descann Compuware & Other Tools 2 Tue May 16, 2017 3:31 pm
No new posts Unable to create multiple files using... mbattu COBOL Programming 3 Fri May 05, 2017 5:35 pm
This topic is locked: you cannot edit posts or make replies. Merge two files and update Trailer re... Yashashri JCL & VSAM 1 Thu May 04, 2017 12:54 pm
No new posts Dynamic split of files under groups sril.krishy DFSORT/ICETOOL 4 Mon Apr 17, 2017 1:09 pm


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