This is on z/OS 1.12 (sorry). A programmer has run two DFSORT jobs with
slightly different control statements which both of us think should result
in the same output. But it does not. One uses the OMIT statement. The other
uses an OUTFIL with a COND. Both use SUM FIELDS=NONE and EQUALS=YES to
remove all duplicate keys, keeping the first record. But the output is
different. The OMIT run has more records. A quick look seems to indicate
that OMIT is what he really wants. Here are the DFSOFT messages. I just
can't see why the OMIT has more output. Most likely due to my own lack of
understanding.
=== OMIT ===
1ICE201I H RECORD TYPE IS V - DATA STARTS IN POSITION 5
ICE751I 0 C5-K62149 C6-K90026 C7-K58148 C8-K67572 E9-K60824 C9-BASE
E5-K70685 E6-K58148 C4-K58148 E7-K70685
ICE143I 0 BLOCKSET SORT TECHNIQUE SELECTED
ICE250I 0 VISIT http://www.ibm.com/storage/dfsort FOR DFSORT PAPERS,
EXAMPLES AND MORE
ICE000I 1 - CONTROL STATEMENTS FOR 5694-A01, Z/OS DFSORT V1R12 - 13:41 ON
WED AUG 19, 2020 -
0 SORT FIELDS=(13,16,CH,A),EQUALS
00190001
SUM FIELDS=NONE
00200001
OMIT COND=(191,1,CH,EQ,C'M') DROP M* POLICIES
00210001
ICE201I H RECORD TYPE IS V - DATA STARTS IN POSITION 5
ICE751I 0 C5-K62149 C6-K90026 C7-K58148 C8-K67572 E9-K60824 C9-BASE
E5-K70685 E6-K58148 C4-K58148 E7-K70685
ICE193I 0 ICEAM1 INVOCATION ENVIRONMENT IN EFFECT - ICEAM1 ENVIRONMENT
SELECTED
ICE088I 0 APH893GI.PS050 . , INPUT LRECL = 12285, BLKSIZE =
27998, TYPE = VB
ICE093I 0 MAIN STORAGE = (MAX,38877188,38877188)
ICE156I 0 MAIN STORAGE ABOVE 16MB = (38819828,38819828)
ICE127I 0 OPTIONS: OVFLO=RC0 ,PAD=RC0 ,TRUNC=RC0
,SPANINC=RC16,VLSCMP=N,SZERO=Y,RESET=Y,VSAMEMT=Y,DYNSPC=256
ICE128I 0 OPTIONS:
SIZE=38877188,MAXLIM=1048576,MINLIM=450560,EQUALS=Y,LIST=Y,ERET=RC16
,MSGDDN=SYSOUT
ICE129I 0 OPTIONS: VIO=N,RESDNT=ALL ,SMF=NO
,WRKSEC=Y,OUTSEC=Y,VERIFY=N,CHALT=N,DYNALOC=(SYSDA ,031),ABCODE=MSG
ICE130I 0 OPTIONS: RESALL=4096,RESINV=0,SVC=109
,CHECK=Y,WRKREL=Y,OUTREL=Y,CKPT=N,COBEXIT=COB2
ICE131I 0 OPTIONS:
TMAXLIM=6291456,ARESALL=0,ARESINV=0,OVERRGN=65536,CINV=Y,CFW=Y,DSA=64
ICE132I 0 OPTIONS: VLSHRT=N,ZDPRINT=Y,IEXIT=N,TEXIT=N,LISTX=N,EFS=NONE
,EXITCK=S,PARMDDN=DFSPARM ,FSZEST=N
ICE133I 0 OPTIONS: HIPRMAX=OPTIMAL,DSPSIZE=MAX
,ODMAXBF=0,SOLRF=Y,VLLONG=N,VSAMIO=N,MOSIZE=0
ICE235I 0 OPTIONS: NULLOUT=RC0
ICE236I 0 OPTIONS: DYNAPCT=10 ,MOWRK=Y
ICE084I 0 EXCP ACCESS METHOD USED FOR SORTOUT
ICE084I 0 EXCP ACCESS METHOD USED FOR SORTIN
ICE750I 0 DC 10419394794 TC 0 CS DSVUU KSZ 20 VSZ 20
ICE752I 0 FSZ=10419394794 BC IGN=0 E AVG=6143 0 WSP=13535205 C
DYN=244621 56664
ICE751I 1 D8-K58148 D4-K59452 EA-K59517 F1-K58148 E8-K70685
ICE090I 0 OUTPUT LRECL = 12285, BLKSIZE = 27998, TYPE = VB
ICE055I 0 INSERT 0, DELETE 1068329
ICE054I 0 RECORDS - IN: 6258994, OUT: 5190665
ICE134I 0 NUMBER OF BYTES SORTED: 7993209593
ICE253I 0 RECORDS SORTED - PROCESSED: 5215434, EXPECTED: 1696417
ICE098I 0 AVERAGE RECORD LENGTH - PROCESSED: 1532, EXPECTED: 6142
ICE165I 0 TOTAL WORK DATA SET TRACKS ALLOCATED: 245055 , TRACKS USED:
145365
ICE199I 0 MEMORY OBJECT USED AS MAIN STORAGE = 0M BYTES
ICE299I 0 MEMORY OBJECT USED AS WORK STORAGE = 0M BYTES
ICE180I 0 HIPERSPACE STORAGE USED = 0K BYTES
ICE188I 0 DATA SPACE STORAGE USED = 0K BYTES
ICE052I 0 END OF DFSORT
=== INCL ===
1ICE201I H RECORD TYPE IS V - DATA STARTS IN POSITION 5
ICE751I 0 C5-K62149 C6-K90026 C7-K58148 C8-K67572 E9-K60824 C9-BASE
E5-K70685 E6-K58148 C4-K58148 E7-K70685
ICE143I 0 BLOCKSET SORT TECHNIQUE SELECTED
ICE250I 0 VISIT http://www.ibm.com/storage/dfsort FOR DFSORT PAPERS,
EXAMPLES AND MORE
ICE000I 1 - CONTROL STATEMENTS FOR 5694-A01, Z/OS DFSORT V1R12 - 13:54 ON
WED AUG 19, 2020 -
0 SORT FIELDS=(13,16,CH,A),EQUALS
00190001
SUM FIELDS=NONE
00200001
OUTFIL INCLUDE=(191,1,CH,NE,C'M') DROP M* POLICIES
00210001
ICE201I H RECORD TYPE IS V - DATA STARTS IN POSITION 5
ICE751I 0 C5-K62149 C6-K90026 C7-K58148 C8-K67572 E9-K60824 C9-BASE
E5-K70685 E6-K58148 C4-K58148 E7-K70685
ICE193I 0 ICEAM1 INVOCATION ENVIRONMENT IN EFFECT - ICEAM1 ENVIRONMENT
SELECTED
ICE088I 0 APH893GI.PS050 . , INPUT LRECL = 12285, BLKSIZE =
27998, TYPE = VB
ICE093I 0 MAIN STORAGE = (MAX,38877188,38877188)
ICE156I 0 MAIN STORAGE ABOVE 16MB = (38815751,38815751)
ICE127I 0 OPTIONS: OVFLO=RC0 ,PAD=RC0 ,TRUNC=RC0
,SPANINC=RC16,VLSCMP=N,SZERO=Y,RESET=Y,VSAMEMT=Y,DYNSPC=256
ICE128I 0 OPTIONS:
SIZE=38877188,MAXLIM=1048576,MINLIM=450560,EQUALS=Y,LIST=Y,ERET=RC16
,MSGDDN=SYSOUT
ICE129I 0 OPTIONS: VIO=N,RESDNT=ALL ,SMF=NO
,WRKSEC=Y,OUTSEC=Y,VERIFY=N,CHALT=N,DYNALOC=(SYSDA ,031),ABCODE=MSG
ICE130I 0 OPTIONS: RESALL=4096,RESINV=0,SVC=109
,CHECK=Y,WRKREL=Y,OUTREL=Y,CKPT=N,COBEXIT=COB2
ICE131I 0 OPTIONS:
TMAXLIM=6291456,ARESALL=0,ARESINV=0,OVERRGN=65536,CINV=Y,CFW=Y,DSA=64
ICE132I 0 OPTIONS: VLSHRT=N,ZDPRINT=Y,IEXIT=N,TEXIT=N,LISTX=N,EFS=NONE
,EXITCK=S,PARMDDN=DFSPARM ,FSZEST=N
ICE133I 0 OPTIONS: HIPRMAX=OPTIMAL,DSPSIZE=MAX
,ODMAXBF=2097152,SOLRF=Y,VLLONG=N,VSAMIO=N,MOSIZE=0
ICE235I 0 OPTIONS: NULLOUT=RC0
ICE236I 0 OPTIONS: DYNAPCT=10 ,MOWRK=Y
ICE084I 0 EXCP ACCESS METHOD USED FOR SORTIN
ICE750I 0 DC 10419394794 TC 0 CS DSVUU KSZ 20 VSZ 20
ICE752I 0 FSZ=10419394794 BC IGN=0 E AVG=6143 0 WSP=13535205 C
DYN=244621 56664
ICE231I 0 STORAGE USED FOR OUTFIL : BELOW 16M = 20480, ABOVE 16M = 2127872
ICE210I 0 SORTOUT : EXCP USED, LRECL = 12285, BLKSIZE = 27998, TYPE = VB
ICE751I 1 D8-K58148 D4-K59452 EA-K59517 CB-K64632 F1-K58148 E8-K70685
ICE055I 0 INSERT 0, DELETE 25000
ICE054I 0 RECORDS - IN: 6258994, OUT: 6233994
ICE227I 0 SORTOUT : DELETED = 1043560, REPORT = 0, DATA = 5190434
ICE228I 0 SORTOUT : TOTAL IN = 6233994, TOTAL OUT = 5190434
ICE134I 0 NUMBER OF BYTES SORTED: 9242949758
ICE253I 0 RECORDS SORTED - PROCESSED: 6258994, EXPECTED: 1696417
ICE098I 0 AVERAGE RECORD LENGTH - PROCESSED: 1476, EXPECTED: 6142
ICE165I 0 TOTAL WORK DATA SET TRACKS ALLOCATED: 245055 , TRACKS USED:
165420
ICE199I 0 MEMORY OBJECT USED AS MAIN STORAGE = 0M BYTES
ICE299I 0 MEMORY OBJECT USED AS WORK STORAGE = 0M BYTES
ICE180I 0 HIPERSPACE STORAGE USED = 0K BYTES
ICE188I 0 DATA SPACE STORAGE USED = 0K BYTES
ICE052I 0 END OF DFSORT
===========
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
