ganeshprasanna
New User
Joined: 21 Feb 2009
Posts: 36
Location: South Portland, Maine
|
|
|
|
I am trying to use DFSORT for JOINKEYS and the step is abending with error message SORT CAPACITY EXCEEDED. Below are some details of the error messages. Kindly help me with a solution.
Things i tried -
1. If SORTJNF1 contains all unique records and there are duplicates in SORTJNF2, try swapping the SORTJNFn DD statements in proc. Be sure to reflect this change in your JOINKEYS and REFORMAT statements as well in the parm card.
2. SORT EXEC PGM=SORT,PARM='DYNALLOC=(,100)'
It seems like DYNALOC=(SYSUT ,100) in SYSOUT changes with PARM parameter but DYNALOC=(3390 ,010) in JNF1JMSG. Can someone tell me why is this?
SORTCARD:
| Code: |
OPTION DYNALLOC=(,255),
FILSZ=E550000000
JOINKEYS FILES=F1,FIELDS=(23,2,A,7,8,A,15,8,A)
JOINKEYS FILES=F2,FIELDS=(1,2,A,3,8,A,11,8,A)
REFORMAT FIELDS=(F2:1,28,F1:39,4),FILL=X'40'
SORT FIELDS=(03,08,PD,A)
INCLUDE COND=(29,4,PD,GT,0)
OUTREC FIELDS=(1:1,28,29:52X)
|
SYSOUT :
| Code: |
ICE416I 0 JOINKEYS IS USING THE F1 SUBTASK FOR SORTJNF1 - SEE JNF1JMSG MESSAGES
ICE411I 0 THIS IS THE JOINKEYS MAIN TASK FOR JOINING F1 AND F2
ICE416I 1 JOINKEYS IS USING THE F2 SUBTASK FOR SORTJNF2 - SEE JNF2JMSG MESSAGES
ICE419I 0 JOINED RECORDS: TYPE=F, LENGTH=32
ICE201I H RECORD TYPE IS F - DATA STARTS IN POSITION 1
ICE751I 0 C5-K62149 C6-K90026 C7-K58148 C8-K90026 E9-K60824 C9-BASE E5-K62149
ICE193I 0 ICEAM1 INVOCATION ENVIRONMENT IN EFFECT - ICEAM1 ENVIRONMENT SELECTED
ICE089I 1 SAAAA .SAAAA .SORT02 , INPUT LRECL = 32, TYPE = F E6-K58148 C4-K58148 E7-K90026
ICE093I 0 MAIN STORAGE = (MAX,50527747,50527747)
ICE156I 0 MAIN STORAGE ABOVE 16MB = (50470387,50470387)
ICE127I 0 OPTIONS: OVFLO=RC0 ,PAD=RC0 ,TRUNC=RC0 ,SPANINC=RC16,VLSCMP=N,SZERO=Y
ICE128I 0 OPTIONS: SIZE=50527747,MAXLIM=1048576,MINLIM=450560,EQUALS=N,LIST=Y,E
ICE129I 0 OPTIONS: VIO=N,RESDNT=ALL ,SMF=NO ,WRKSEC=Y,OUTSEC=Y,VERIFY=N,CHALT,RESET=Y,VSAMEMT=Y,DYNSPC=256
ICE130I 0 OPTIONS: RESALL=4096,RESINV=0,SVC=109 ,CHECK=Y,WRKREL=Y,OUTREL=Y,CKPTRET=RC16 ,MSGDDN=SYSOUT
ICE131I 0 OPTIONS: TMAXLIM=6291456,ARESALL=0,ARESINV=0,OVERRGN=65536,CINV=Y,CFW=N,DYNALOC=(SYSDA ,100),ABCODE=MSG
ICE132I 0 OPTIONS: VLSHRT=N,ZDPRINT=Y,IEXIT=N,TEXIT=N,LISTX=N,EFS=NONE ,EXIT=N,COBEXIT=COB2
ICE133I 0 OPTIONS: HIPRMAX=OPTIMAL,DSPSIZE=MAX ,ODMAXBF=0,SOLRF=Y,VLLONG=N,VSAM=Y,DSA=64
ICE235I 0 OPTIONS: NULLOUT=RC0 CK=S,PARMDDN=DFSPARM ,FSZEST=N
ICE236I 0 OPTIONS: DYNAPCT=10 ,MOWRK=Y IO=N,MOSIZE=MAX
ICE084I 0 EXCP ACCESS METHOD USED FOR SORTOUT
ICE752I 0 FSZ=550000000 RE IGN=0 C AVG=32 0 WSP=22859375 E DYN=396768 56648
ICE750I 0 DC 0 TC 0 CS DSVOO KSZ 9 VSZ 9
ICE751I 1 DE-K61787 D5-K58148 D9-K61787 E8-K61439
ICE805I 1 JOBNAME: SAAAAA , STEPNAME: SAAAAA
ICE802I 0 BLOCKSET TECHNIQUE IN CONTROL
ICE992I 0 RA 4 WR 0 TR 14
ICE887I 0 CSES 0,0,0 ES 0,0,0
ICE886I 0 SYS 0 TSTG 0 FS 0 INIT 0 MAX 0 LEN 0
ICE915I 0 MOFSZ=20981,MOSZ=0,MOSYS=40(5),MOSTG=72,MEML=17592186039816(3)
ICE916I 0 MOFR=0104,MOVR=VV
ICE996I 0 ESM=1020672,ESO=1020672,ESR=0,ESP=4096,ESS=16384,CES=1020672,HSZ=1048
ICE997I 0 HWSP=10742187,HMAX=10400,HES=0,ASV=18592,EQ=N1,HN=0
ICE898I 0 OMAX=0,NMAX=18592,ENQT=10400,CMAX=0,HU=0,BUN=0,MD=NK,N6,DU=0,DR=0,HN= 576
ICE889I 0 CT=MAX , SB=8, L=0, D=0000, CCW=1MAM
ICE901I 0 W 07PP17 15PP17 1DPP17 20PP17 53PP17 5CPP17 6DPP17 4DPP17 0
ICE901I 0 W 51PP17 4BPP17 2FPP17 38PP17 37PP17 28PP17 06PP17 6APP17
ICE901I 0 W 6EPP17 5DPP17 5EPP17 5FPP17 5APP17 49PP17 4APP17 4EPP17
ICE901I 0 W 54PP17 10PP17 22PP17 1FPP17 19PP17 13PP17 09PP17 58PP17
ICE901I 0 W 62PP13 65PP13 66PP13 5BPP13 52PP13 05PP13 1BPP13 23PP13
ICE901I 0 W 3APP13 3DPP13 2CPP13 2EPP13 31PP13 42PP13 21PP13 1EPP13
ICE901I 0 W 16PP13 03PP13 11PP13 46PP13 63PP13 68PP13 45PP13 4CPP13
ICE901I 0 W 4FPP13 50PP13 0APP13 33PP13 29PP13 2APP13 34PP13 01PP13
ICE901I 0 W 02PP13 1CPP13 60PP13 59PP13 61PP13 69PP13 55PP13 57PP13
ICE901I 0 W 47PP13 17PP13 08PP13 32PP13 27PP13 25PP13 41PP13 3EPP13
ICE901I 0 W 40PP13 43PP13 39PP13 35PP13 0BPP13 0CPP13 0FPP13 14PP13
ICE901I 0 W 24PP13 67PP13 6BPP13 6CPP13 64PP13 48PP13 56PP13 12PP13
ICE901I 0 W 0DPP13 2DPP13 04PP13 18PP13 3BPP13 0EPP13 26PP13 36PP13
ICE901I 0 W 3FPP13 1APP13 44PP13 30PP13 2BPP13 3CPP13
ICE902I 0 O PP10 I
ICE418A 3 JOINKEYS F1 SUBTASK FOR SORTJNF1 TERMINATED - SEE JNF1JMSG MESSAGES
ICE052I 0 END OF DFSORT |
JNF1JMSG
| Code: |
ICE201I H RECORD TYPE IS F - DATA STARTS IN POSITION 1
ICE751I 0 C5-K62149 C6-K90026 C7-K58148 C8-K90026 E4-K58148 C9-BASE E5-K62149 E6-K58148 C4-K58148 E7-K90026
ICE417I 0 THIS IS THE JOINKEYS F1 SUBTASK FOR SORTJNF1
ICE143I 0 BLOCKSET SORT TECHNIQUE SELECTED
ICE250I 0 VISIT http://www.ibm.com/storage/dfsort FOR DFSORT PAPERS, EXAMPLES ANND MORE
ICE000I 0 - CONTROL STATEMENTS FOR 5694-A01, Z/OS DFSORT V1R12 - 10:56 ON WED NOOV 16, 2011 -
SORT FORMAT=BI,FIELDS=(23,2,A,7,8,A,15,8,A)
RECORD TYPE=F
DEBUG NOABEND,ESTAE
OPTION EQUALS,MSGPRT=ALL,LIST,NOCHECK,RESINV=0,DYNALLOC,SORTDD=JNF1,MSSG*
DDN=JNF1JMSG,SORTIN=SORTJNF1
ICE201I H RECORD TYPE IS F - DATA STARTS IN POSITION 1
ICE751I 0 C5-K62149 C6-K90026 C7-K58148 C8-K90026 E4-K58148 C9-BASE E5-K62149 E6-K58148 C4-K58148 E7-K90026
ICE193I 0 ICEAM2 INVOCATION ENVIRONMENT IN EFFECT - ICEAM2 ENVIRONMENT SELECTED
ICE088I 1 SCZJ112 .SCZP112 .SORT02 , INPUT LRECL = 223, BLKSIZE = 27875, TYPE == FB
ICE093I 0 MAIN STORAGE = (MAX,67108864,67108864)
ICE156I 0 MAIN STORAGE ABOVE 16MB = (67051504,67051504)
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=67108864,MAXLIM=1048576,MINLIM=450560,EQUALS=Y,LIST=Y,ERRET=RC16 ,MSGDDN=JNF1JMSG
ICE129I 0 OPTIONS: VIO=N,RESDNT=ALL ,SMF=NO ,WRKSEC=Y,OUTSEC=Y,VERIFY=N,CHALT=N,DYNALOC=(3390 ,010),ABCODE=MSG
ICE130I 0 OPTIONS: RESALL=4096,RESINV=0,SVC=109 ,CHECK=N,WRKREL=Y,OUTREL=Y,CKPT=N,COBEXIT=COB2
ICE131I 0 OPTIONS: TMAXLIM=6291456,ARESALL=0,ARESINV=0,OVERRGN=16384,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
ICE236I 0 OPTIONS: DYNAPCT=10 ,MOWRK=Y
ICE084I 0 EXCP ACCESS METHOD USED FOR SORTJNF1
ICE750I 0 DC 59946079500 TC 0 CS DSVVV KSZ 22 VSZ 22
ICE752I 0 FSZ=268816500 RC IGN=0 E AVG=228 0 WSP=79605386 C DYN=1441440 56552
ICE805I 0 JOBNAME: SAAAAA , STEPNAME: SAAAAAA
ICE802I 0 BLOCKSET TECHNIQUE IN CONTROL
ICE992I 0 RA 0 WR 0 TR 1
ICE887I 0 CSES 0,0,0 ES 0,0,0
ICE886I 0 SYS 0 TSTG 0 FS 0 INIT 0 MAX 0 LEN 0
ICE915I 0 MOFSZ=62553,MOSZ=0,MOSYS=59(5),MOSTG=59,MEML=17592186039816(3)
ICE916I 0 MOFR=0104,MOVR=VV
ICE996I 0 ESM=1020672,ESO=1020672,ESR=0,ESP=4096,ESS=16384,CES=1020672,HSZ=1048576
ICE997I 0 HWSP=37408546,HMAX=15152,HES=0,ASV=15152,EQ=N1,HN=0
ICE898I 0 OMAX=0,NMAX=15152,ENQT=15152,CMAX=0,HU=0,BUN=0,MD=NK,N6,DU=0,DR=0,HN=0
ICE889I 0 CT=MAX , SB=3, L=0, D=0000, CCW=1MAM
ICE901I 0 W 0APP17 0BPP17 07PP17 05PP17 09PP17 06PP17 08PP17 02PP17
ICE901I 0 W 04PP17 03PP17 01PP13
ICE902I 0 O I PP10
ICE046A 0 SORT CAPACITY EXCEEDED - RECORD COUNT 265892017
ICE253I 0 RECORDS SORTED - PROCESSED: 265892017, EXPECTED: 268816500
ICE753I 1 FWK=(10,1441440) SWK=(0,0) TWK=(0,0) RWK=(1,106724) TOTAL=(11,1548164 ) BLK=56552
ICE278I 1 10 WORK DATA SETS WERE INSUFFICIENT TO COMPLETE THIS SORT SO 1 ADDITIONAL WERE USED
ICE751I 1 DE-K61787 D5-K58148 C4-K58148 C4-K58148 E8-K61439
ICE052I 0 END OF DFSORT
|
|
|
.jpg)
