ICE093I 0 MAIN STORAGE = (MAX,43730446,43701774)
ICE156I 0 MAIN STORAGE ABOVE 16MB = (43644414,43644414)
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=43730446,MAXLIM=1048576,MINLIM=450560,EQUALS=Y,LIST=Y, ERET=ABEND,MSGDDN=SYSOUT
ICE129I 0 OPTIONS: VIO=N,RESDNT=ALL ,SMF=FULL ,WRKSEC=Y,OUTSEC=Y,VERIFY=N,CHALT=N,DYNALOC=N ,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=MAX
ICE235I 0 OPTIONS: NULLOUT=RC0
ICE084I 0 BSAM ACCESS METHOD USED FOR SORTOUT
ICE750I 0 DC 0 TC 0 CS DSVNN KSZ 79 VSZ 79
ICE752I 0 FSZ=24968169 RE IGN=0 C AVG=528 0 WSP=17122703 E DYN=0 0
ICE751I 1 DE-K61785 D5-K62201 D9-K61785 E8-K61438
ICE418A 4 JOINKEYS F2 SUBTASK FOR SORTJNF2 TERMINATED - SEE JNF2JMSG MESSAGES
ICE052I 0 END OF DFSORT
JNF2JMSG has following message..
Code:
ICE750I 0 DC 5823220392 TC 0 CS DSVVV KSZ 16 VSZ 16
ICE752I 0 FSZ=14272599 RC IGN=0 E AVG=412 0 WSP=7637514 C DYN=71124 53216
ICE751I 2 DE-K61785 DA-K69253
ICE185A 0 AN U1094 ABEND WAS ISSUED BY DFSORT, ANOTHER PROGRAM OR AN EXIT (PHASE S 1)
i couldn't understand any from above details..any suggestion what could be issue. FYI..The JOIN command working on small files.
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
You have to dig for information from the message you have shown. Google, manuals.
Why are you expanding the reformat record with INREC for large files. You are adding a lot of space which could just as conveniently be added with OUTREC, after the SORT/SUM is complete?
Joined: 07 Dec 2007 Posts: 2205 Location: San Jose
umanaga,
In addition to the region parameter you can actually reduce the size of the records using JNF1 and JNF2. You only need 22 bytes from file1 and 9 bytes from file 2 apart from the key. So use an INREC BUILD on JNF1 and JNF2 to pick only the fields you want.
Also as Bill mentioned you can expand the record in the last phase of sort. OUTREC or OUTFIL. Ideally I would prefer using reporting features to get the count and total. Here is an updated version of your job.
.jpg)
