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
 
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 Regarding time parameter shanthi gude JCL & VSAM 7 Mon Sep 04, 2017 2:31 pm
No new posts Paasing symbolic parameter to instrea... Robert Sample JCL & VSAM 2 Thu Jul 27, 2017 1:22 pm
No new posts JTS parameter Shashank Chaubey JCL & VSAM 2 Thu Jul 13, 2017 4:15 pm
No new posts Include/omit with "ALL" pa... mgl DFSORT/ICETOOL 6 Wed Jun 14, 2017 2:31 pm
No new posts Can DFSPARM override SORTKEYS paramet... ashek15 DB2 2 Tue Jan 31, 2017 11:36 pm

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