Maximum number of include/omit cond



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Maximum number of include/omit cond

Postby xcspg3 » Sat Nov 07, 2009 9:41 pm

Hi,
I have two little questions:
- the maximum number of include/omit cond in a single step of dfsort
- the maximum number of rows for the SYSIN of dfsort

Can you help me?

max
xcspg3
 
Posts: 29
Joined: Tue Sep 25, 2007 6:34 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Maximum number of include/omit cond

Postby Frank Yaeger » Mon Nov 09, 2009 10:33 pm

The maximum number of INCLUDE/OMIT conditions depends on the length and type of the field and constant. If you show me an example of your INCLUDE condition, I may be able to give you an estimate.

By "rows", do you mean lines or something else? Approx. how many lines do you need?
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times

Re: Maximum number of include/omit cond

Postby xcspg3 » Sun Nov 15, 2009 6:59 pm

Data set has LRECL=80, RECFM=FB and 1.000.000 or more lines.
The SYSIN is
INCLUDE COND=(3,16,CH,EQ,C'0000000000000001',OR,
3,16,CH,EQ,C'0000000000000002',OR,
...
3,16,CH,EQ,C'000000000000000N')
SORT FIELDS=COPY
where C'....' is a string of 16 chars.
The step before DFSORT creates the include cond with a variable mumber of 3,16,CH,EQ,C'...'.
My question is about the maximum number of 3,16,CH,EQ,C'...' that I can use.
The other question is about the maximum number of lines for a SYSIN.

Thanks
Max
xcspg3
 
Posts: 29
Joined: Tue Sep 25, 2007 6:34 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Maximum number of include/omit cond

Postby Frank Yaeger » Mon Nov 16, 2009 11:31 pm

For that type of condition, the maximum would be about 1240. The maximum number of lines depends on the storage available, but the number of conditions will be exceeded long before the number of lines is.

If you have more than 1240 conditions, you might want to consider using a matching solution instead of an INCLUDE solution. For more information, see the various techniques described in the "Create files with matching and non-matching records" Smart DFSORT Trick at:

http://www.ibm.com/support/docview.wss? ... g3T7000094
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times

Re: Maximum number of include/omit cond

Postby xcspg3 » Sat Nov 21, 2009 8:57 pm

Thanks

max
xcspg3
 
Posts: 29
Joined: Tue Sep 25, 2007 6:34 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post