Joined: 30 Aug 2005 Posts: 88 Topics: 3 Location: Syracuse,New york
Posted: Tue Nov 29, 2005 5:19 am Post subject:
i found the below text in a DFSORT PDF.
Code:
ICETOOL automatically calls DFSORT with the particular DFSORT control
statements and options required for each operation (such as DYNALLOC for
sorting).
refering of DYNALLOC option should give more insight. _________________ Anil Sarathy
Joined: 07 Jan 2003 Posts: 1056 Topics: 91 Location: The Blue Planet
Posted: Tue Nov 29, 2005 5:28 am Post subject:
Jacky_ying,
I don't think that there is a separate DD name for ICETOOL work files.
Per IBM DFSORT Application Programming Guide Manual
Code:
In general, xxxxWKdd ddnames should not be used as ddnames in ICETOOL
operators nor supplied as DD statements. However, if you want to override
dynamic allocation of work data sets for ICETOOL operators OCCUR and
UNIQUE, you can use SORTWKdd DD statements for that purpose. If you want
to override dynamic allocation of work data sets for ICETOOL operators
SELECT, SORT, and SPLICE, you can use xxxxWKdd DD statements for that
purpose in conjunction with the USING operand.
I would suggest using OPTION DYNALLOC - to allocate the work files dynamically instead of providing the size yourself.
Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
Posted: Tue Nov 29, 2005 11:39 am Post subject:
DFSORT's ICETOOL automatically uses the DYNALLOC parameter for any operator that involves sorting (e.g. SORT, SELECT, etc). You don't have to specify DYNALLOC or any JCL SORTWKdd DD statements.
If you need to override the DYNALLOC parameter, you can do that in the ccccCNTL data set if you have USING(cccc) or in //DFSPARM if you don't have USING(cccc). For example:
Note that CTL1CNTL only applies to operators with USING(CTL1) whereas DFSPARM applies to all operators.
If you want to provide JCL SORTWKdd DD statements for an ICETOOL operator that involves sorting, you need to use a ddname of the form ccccWKdd where cccc is from the USING(cccc) operand, e.g. for:
Code:
SELECT FROM(IN) TO(OUT) ON(1,5,CH) FIRST USING(CTL1)
you could use:
Code:
//CTL1WK01 DD ...
//CTL1WK02 DD ...
...
If you don't have USING(cccc) for the operator, then ddnames of the form SORTWKdd could be used.
But unless you have a specific reason to use JCL SORTWKdds, you shouldn't.
Note that CTL1WKdd only applies to operators with USING(CTL1) whereas SORTWKdd applies to any operators without USING(cccc). _________________ Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
