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
 

 

Value for DYNALLOC parameter

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

Active Member


Joined: 27 Nov 2006
Posts: 649
Location: India

PostPosted: Mon Oct 24, 2011 8:04 pm    Post subject: Value for DYNALLOC parameter
Reply with quote

Hi, any clue as to How we can decide what value should be supplied for DYNALLOC parameter?

Thanks
Krishna
Back to top
View user's profile Send private message

sqlcode1

Active Member


Joined: 08 Apr 2010
Posts: 578
Location: USA

PostPosted: Mon Oct 24, 2011 8:18 pm    Post subject:
Reply with quote

krisprems,
It depends on your size for sort fields.

Refer to DFSort Tunning Guide

Thanks,
Back to top
View user's profile Send private message
krisprems

Active Member


Joined: 27 Nov 2006
Posts: 649
Location: India

PostPosted: Mon Oct 24, 2011 8:23 pm    Post subject:
Reply with quote

I am looking for a sort of formula, based on which I can pass a value in this parameter, say for example DYNALLOC=(,16). How can i decide this value.

Sorry, if it was provided in the link mentioned by you. I didnt find it!

Thanks
Krishna
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: Mon Oct 24, 2011 11:59 pm    Post subject:
Reply with quote

Quote:
It depends on your size for sort fields.


It actually depends more on the number of records to be sorted, although the size of the sort fields can factor into it too.

Quote:
I am looking for a sort of formula, based on which I can pass a value in this parameter, say for example DYNALLOC=(,16). How can i decide this value.


There is no such formula (and none is needed). You just need to supply an approx. number for DYNALLOC that provides enough work space consistent with the number of records you are going to sort. I'd suggest you start with your site's default. If that doesn't work, bump it up to DYNALLOC=(,8). If that doesn't work, bump it up to DYNALLOC=(,16) and so on.
Back to top
View user's profile Send private message
krisprems

Active Member


Joined: 27 Nov 2006
Posts: 649
Location: India

PostPosted: Tue Oct 25, 2011 2:43 pm    Post subject:
Reply with quote

Hi Frank,
one another question , is it better to use the FILSZ or DYNALLOC parameter?
Back to top
View user's profile Send private message
krisprems

Active Member


Joined: 27 Nov 2006
Posts: 649
Location: India

PostPosted: Tue Oct 25, 2011 2:58 pm    Post subject: Reply to: DYNALLOC
Reply with quote

SORT statement used in my SYSIN is ...

Code:
SORT     FIELDS=(1,36,CH,A)
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: Tue Oct 25, 2011 11:12 pm    Post subject:
Reply with quote

In general, you DO NOT need to specify FILSZ because DFSORT can usually determine the number of records to sort automatically. One exception is when an E15 supplies all of the records. For more specific information, see:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA60/A.4.1.3?SHELF=&DT=20110608113434&CASE=
Back to top
View user's profile Send private message
krisprems

Active Member


Joined: 27 Nov 2006
Posts: 649
Location: India

PostPosted: Wed Oct 26, 2011 9:25 am    Post subject:
Reply with quote

Frank this helps , thank you!
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 Can DFSPARM override SORTKEYS paramet... ashek15 DB2 2 Tue Jan 31, 2017 11:36 pm
No new posts DDNAME parameter mistah kurtz JCL & VSAM 6 Mon Dec 19, 2016 4:41 pm
No new posts Execessive parameter issue Sumeendar JCL & VSAM 5 Mon Dec 19, 2016 4:35 pm
No new posts TOT & DATE parameter in ICEMAN hemanthj642 DFSORT/ICETOOL 4 Mon Nov 14, 2016 5:19 am
No new posts How to display value of an exit param... lind sh CICS 2 Sun Oct 09, 2016 12:28 pm


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