Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 FTP Skip or ignore error and process ... AJAYREDDY All Other Mainframe Topics 3 Wed Sep 27, 2017 8:12 pm
No new posts Comparing 2 Files using Current time arunsoods SYNCSORT 9 Fri Sep 22, 2017 6:00 pm
No new posts Split 1 file into 10 output Files - S... Prasanth Kumar SYNCSORT 5 Sat Sep 16, 2017 12:02 am
No new posts Join records from 2 files with No Dup... Poha Eater DFSORT/ICETOOL 22 Sun Aug 27, 2017 10:35 pm
No new posts Sorting on text - but in non-alphabet... Roy Ware SYNCSORT 5 Wed Aug 23, 2017 9:15 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us