|
View previous topic :: View next topic
|
| Author |
Message |
krisprems
Active Member
Joined: 27 Nov 2006
Posts: 649
Location: India
|
|
|
|
Hi, any clue as to How we can decide what value should be supplied for DYNALLOC parameter?
Thanks
Krishna |
|
| Back to top |
|
 |
sqlcode1
Active Member
Joined: 08 Apr 2010
Posts: 577
Location: USA
|
|
| Back to top |
|
|
krisprems
Active Member
Joined: 27 Nov 2006
Posts: 649
Location: India
|
|
|
|
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 |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
| 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 |
|
|
krisprems
Active Member
Joined: 27 Nov 2006
Posts: 649
Location: India
|
|
|
|
Hi Frank,
one another question , is it better to use the FILSZ or DYNALLOC parameter? |
|
| Back to top |
|
|
krisprems
Active Member
Joined: 27 Nov 2006
Posts: 649
Location: India
|
|
|
|
SORT statement used in my SYSIN is ...
| Code: |
| SORT FIELDS=(1,36,CH,A) |
|
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
| Back to top |
|
|
krisprems
Active Member
Joined: 27 Nov 2006
Posts: 649
Location: India
|
|
|
|
| Frank this helps , thank you! |
|
| Back to top |
|
|
|
|
