|
|
| Author |
Message |
Dev's
New User
Joined: 12 Mar 2007
Posts: 14
Location: Hyderabad
|
|
|
|
Job fialed with return code 16, due to sort capacity exceeded with following info. (ICE046A 0 SORT CAPACITY EXCEEDED - RECORD COUNT 15357243).
Find the step is as below,
//STEP0002 EXEC PGM=ICETOOL,REGION=0M,TIME=&UNLTM,
// PARM='DYNALLOC=(,255)'
//TOOLMSG DD SYSOUT=&SYSOUT
//DFSMSG DD SYSOUT=&SYSOUT
Could you please suggest me the optimal way |
|
| Back to top |
|
 |
References
|
 Posted: Wed Jul 23, 2008 7:52 pm Post subject: Re: DYNALLOC optimal space option required |
|
|
|
|
karthikr44
Active User
Joined: 25 Aug 2007
Posts: 135
Location: trichy
|
|
|
|
Hi,
Can u post the entire JCL.
Regards
r karthik |
|
| Back to top |
|
|
Dev's
New User
Joined: 12 Mar 2007
Posts: 14
Location: Hyderabad
|
|
|
|
Hi,
Find the below JCL (except job card and symbolic parameters), i have extracted all the required things in this JCL
| Code: |
//STEP0040 EXEC PGM=ICETOOL,REGION=0M,TIME=&UNLTM,COND=(4,LT),
// PARM='DYNALLOC=(,255)'
//TOOLMSG DD SYSOUT=&SYSOUT
//DFSMSG DD SYSOUT=&SYSOUT
//IN3 DD DSN=KBY831P.ALTEXT.LCNSM.PART16.FINAL,DISP=SHR
//IN4 DD DSN=KBY831P.ALTEXT.LCPRDT.PART16.SRT,DISP=SHR
//TEMP3 DD DSN=KBY831P.ALTEXT.LCNSM.PART16.TEMP2,
// MGMTCLAS=&MCLS1,
// DISP=(,CATLG,),UNIT=(TAPE90),LABEL=RETPD=07,VOL=(,RETAIN,,99),
// DCB=(RECFM=FB,BLKSIZE=0,TRTCH=COMP,BUFNO=50),SPACE='(CYL,(3000,3000),RLSE)',DATACLAS=DCCOMP
//TEMP4 DD DSN=&PRJ.&ENV..&TYP..&JNE2..&TABLE..&TYP4,
// MGMTCLAS=&MCLS1,
// DISP=(,CATLG,),UNIT=(TAPE90),LABEL=RETPD=07,VOL=(,RETAIN,,99),
// DCB=(RECFM=FB,BLKSIZE=0,TRTCH=COMP,BUFNO=50),SPACE='(CYL,(3000,3000),RLSE)',DATACLAS=DCCOMP
//OUT2 DD DSN=*.TEMP3,DISP=SHR,VOL=REF=*.TEMP3
// DD DSN=*.TEMP4,DISP=SHR,VOL=REF=*.TEMP4
//MATCH3 DD DSN=KBY831P.ALTEXT.COVCNS.PART16.FINAL,
// MGMTCLAS=&MCLS1,
// DISP=(,CATLG,),UNIT=(TAPE90),LABEL=RETPD=07,VOL=(,RETAIN,,99),
// DCB=(RECFM=FB,BLKSIZE=0,TRTCH=COMP,BUFNO=50),SPACE='(CYL,(3000,3000),RLSE)',DATACLAS=DCCOMP
//TOOLIN DD DSN=&LIB(&PAM6),DISP=SHR
SORT CARD-( COPY FROM(IN3) USING(CPY1)
COPY FROM(IN4) USING(CPY2)
SPLICE FROM(OUT2) TO(MATCH3) WITHALL ON(1,68,CH) -
WITH(187,35) WITH(321,1) USING(CPY3) )
//CPY1CNTL DD DSN=&LIB(&PAM7),DISP=SHR
SORT CARD-( OUTFIL FNAMES=TEMP3,OUTREC=(1:1,186,187:133X,320:C'11') )
//CPY2CNTL DD DSN=&LIB(&PAM8),DISP=SHR
SORT CARD-( OUTFIL FNAMES=TEMP4,OUTREC=(1:1,68,187:69,10,197:79,10,207:89,15,
222:98X,320:C'22') )
//CPY3CNTL DD DSN=&LIB(&PAM9),DISP=SHR
SORT CARD-( OUTFIL FNAMES=MATCH3,
INCLUDE=(320,2,CH,EQ,C'12'),
OUTREC=(1:1,321) ) |
|
|
| Back to top |
|
|
karthikr44
Active User
Joined: 25 Aug 2007
Posts: 135
Location: trichy
|
|
|
|
Hi,
While posting the code kindly use the code option.
Also one thing to verify..U are coding the control cards staring from
position 2 only...right?
If not means start from position 2 and try again.
Regards
R KARTHIK |
|
| Back to top |
|
|
karthikr44
Active User
Joined: 25 Aug 2007
Posts: 135
Location: trichy
|
|
|
|
Like below only u should code
| Code: |
//SYSIN DD *
MERGE FIELDS=(2,3,CH,A)
/*
|
U should not code like this
| Code: |
//SYSIN DD *
MERGE FIELDS=(2,3,CH,A)
/*
|
|
|
| Back to top |
|
|
Dev's
New User
Joined: 12 Mar 2007
Posts: 14
Location: Hyderabad
|
|
|
|
Hi,
Next time onwards i will use that code option for code ,
I am starting the control cards from the position 2 only, there is no issue with that control card.
Issue with the DYNALLOC work space..  |
|
| Back to top |
|
|
karthikr44
Active User
Joined: 25 Aug 2007
Posts: 135
Location: trichy
|
|
| Back to top |
|
|
Dev's
New User
Joined: 12 Mar 2007
Posts: 14
Location: Hyderabad
|
|
|
|
Hi,
With the prior link i got some knowledge about this issue, I have one more continuous question to this i.e,
The failed job spool have the below ICE046A error information " The ICE046A indicates there wasn't enough work space to complete the sort. DFSORT processed 1.4+ million records, but then ran out of work space."
you can find the record count also for failed job here,
| Code: |
ICE046A 0 SORT CAPACITY EXCEEDED - RECORD COUNT 15357243 |
|
|
| Back to top |
|
|
Frank Yaeger
DFSORT Moderator
Joined: 15 Feb 2005
Posts: 4190
Location: San Jose, CA
|
|
|
|
| Code: |
//STEP0002 EXEC PGM=ICETOOL,REGION=0M,TIME=&UNLTM,
// PARM='DYNALLOC=(,255)'
|
Deva,
PARM='DYNALLOC=(,255)' is ignored for an ICETOOL run. PARM values are only used for PGM=SORT, not for PGM=ICETOOL. To override the DYNALLOC value for ICETOOL, you can use:
| Code: |
//DFSPARM DD *
OPTION DYNALLOC=(,255)
/*
|
I would start with a lower value, like 32 rather than 255. If that doesn't work, you could increase it. |
|
| Back to top |
|
|
Dev's
New User
Joined: 12 Mar 2007
Posts: 14
Location: Hyderabad
|
|
|
|
Hi Frank,
I have changed the DFSPARM parameter's as you mentioned but still the job fails with the same info as below....
Could you please suggest me is there any there any more options to increase the space for ICETOOL
| Code: |
ICE046A 0 SORT CAPACITY EXCEEDED - RECORD COUNT 13243663
|
|
|
| Back to top |
|
|
Frank Yaeger
DFSORT Moderator
Joined: 15 Feb 2005
Posts: 4190
Location: San Jose, CA
|
|
|
|
Please add the following to your job so I can see the diagnostic messages:
//SORTDIAG DD DUMMY
Then rerun the job and send me the following offline (yaeger@us.ibm.com)
preferably as plain text files:
- the complete JCL you used
- the JES, TOOLMSG and DFSMSG messages you received
Put "DFSORT" somewhere in your Subject line to catch my attention. |
|
| Back to top |
|
|
|
|
|
