On Thu, Aug 20, 2020 at 7:00 AM Billy Ashton <bill00ash...@gmail.com> wrote:
> John, is it possible that some of the duplicate records have a different > value in 187/191 - sometimes it has 'M', and sometimes something else? > Ah! A great idea. I had not thought of that. > > Can you compare the two different output files to see what is different > (other than the 231 additional records)? Do you know which output set is > correct? > OMIT is correct. > > Billy > ------ Original Message ------ > From: "John McKown" <john.archie.mck...@gmail.com> > To: IBM-MAIN@listserv.ua.edu > Sent: 8/20/2020 7:26:45 AM > Subject: DFSORT confusion. > > >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 lists...@listserv.ua.edu with the message: INFO IBM-MAIN > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN