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
 

 

Understanding DFSORT dynamic allocation better.

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

Global Moderator


Joined: 28 Aug 2007
Posts: 1458
Location: Azeroth

PostPosted: Thu Sep 20, 2007 1:00 pm    Post subject: Understanding DFSORT dynamic allocation better.
Reply with quote

Hi,

Wonder if you could help me with this. icon_rolleyes.gif

A large dataset say 10,000 Cyls needs to be sorted.
with the option,
OPTIONS='DYNALLOC,SORTWKNO=1',SORT=100,


As you can see, the SORTWKNO is very less,
Is there any rule to choose the optimal SORTWKNO specification
and the BUFNO specification.

Also could you please let me know the effect, if large SORTWKNO is mentioned, say SORTWKNO=10 , and BUFNO=60.


Thanks in advance. icon_biggrin.gif
Back to top
View user's profile Send private message

murmohk1

Senior Member


Joined: 29 Jun 2006
Posts: 1439
Location: Bangalore,India

PostPosted: Thu Sep 20, 2007 1:09 pm    Post subject:
Reply with quote

Vasanth,

Your Sep 18 2007 post -

http://www.ibmmainframes.com/viewtopic.php?t=24563&sid=e87c2d6feef910a54fff2f88403d7ef7

I belive Frank had replied this.
Back to top
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1458
Location: Azeroth

PostPosted: Thu Sep 20, 2007 1:14 pm    Post subject:
Reply with quote

Hi murmohk,

I wanted to know if there is any rule for the same.
In a generalised scenario.
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: Thu Sep 20, 2007 9:06 pm    Post subject:
Reply with quote

Quote:
OPTIONS='DYNALLOC,SORTWKNO=1',SORT=100,


These seem to be options for a program that's calling DFSORT. It's not clear if SORTWKNO=1 causes one JCL SORTWKdd data set to be used or sets DYNALLOC=(,1) or does something else.

Quote:
Is there any rule to choose the optimal ... BUFNO specification.


DFSORT does not pay any attention to BUFNO for work data sets. It does it's own buffer optimization.

Quote:
Is there any rule to choose the optimal SORTWKNO specification


As I said before, the best approach is to let DFSORT allocate the work data sets dynamically. DFSORT's shipped default for the number of dynamically allocated work data sets is 4. The site can change that default. I would suggest using the site default unless there's some reason to override it.
Back to top
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1458
Location: Azeroth

PostPosted: Fri Sep 21, 2007 1:26 pm    Post subject:
Reply with quote

Thanks for the responce Frank. icon_biggrin.gif
I was having a misconception that increasing BUFNO will increase the performance. icon_eek.gif


Also this link might be useful for further readers.
The author of this link has thanked Frank for his support. icon_wink.gif

http://66.102.9.104/search?q=cache:JGKVGeuZDEYJ:www-03.ibm.com/servers/storage/support/software/sort/mvs/tuning/pdf/srtmltun.pdf+dfsort+tuning+parameters&hl=en&ct=clnk&cd=1&gl=in
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 Sep 21, 2007 9:01 pm    Post subject:
Reply with quote

Yes, that paper is available on the DFSORT website:

www.ibm.com/servers/storage/support/software/sort/mvs/tuning/
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 REXX DB2: Dynamic allocation of DB2.D... BHAS CLIST & REXX 3 Mon Dec 19, 2016 8:26 pm
No new posts How to get the remainder and quotient... vnktrrd DFSORT/ICETOOL 2 Mon Oct 31, 2016 10:59 am
No new posts Need Help in understanding what is th... mainakdalal PL/I & Assembler 9 Mon Oct 03, 2016 8:03 pm
No new posts Change date (DD/MM/YY) in 2nd record ... uday kiran DFSORT/ICETOOL 12 Wed Sep 07, 2016 10:57 pm
No new posts DFSORT sorting only specific records akodakka DFSORT/ICETOOL 4 Thu Aug 04, 2016 11:24 am


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