IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

DYNALLOC optimal space option required


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Dev's

New User


Joined: 12 Mar 2007
Posts: 14
Location: Hyderabad

PostPosted: Wed Jul 23, 2008 7:52 pm
Reply with quote

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
View user's profile Send private message
karthikr44

Active User


Joined: 25 Aug 2007
Posts: 235
Location: Chennai

PostPosted: Wed Jul 23, 2008 8:03 pm
Reply with quote

Hi,

Can u post the entire JCL.

Regards
r karthik
Back to top
View user's profile Send private message
Dev's

New User


Joined: 12 Mar 2007
Posts: 14
Location: Hyderabad

PostPosted: Wed Jul 23, 2008 8:34 pm
Reply with quote

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
View user's profile Send private message
karthikr44

Active User


Joined: 25 Aug 2007
Posts: 235
Location: Chennai

PostPosted: Wed Jul 23, 2008 8:43 pm
Reply with quote

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
View user's profile Send private message
karthikr44

Active User


Joined: 25 Aug 2007
Posts: 235
Location: Chennai

PostPosted: Wed Jul 23, 2008 8:47 pm
Reply with quote

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
View user's profile Send private message
Dev's

New User


Joined: 12 Mar 2007
Posts: 14
Location: Hyderabad

PostPosted: Wed Jul 23, 2008 8:51 pm
Reply with quote

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.. icon_rolleyes.gif
Back to top
View user's profile Send private message
karthikr44

Active User


Joined: 25 Aug 2007
Posts: 235
Location: Chennai

PostPosted: Wed Jul 23, 2008 9:09 pm
Reply with quote

Hi,

Kindly check the below link

ibmmainframes.com//viewtopic.php?t=21315
Back to top
View user's profile Send private message
Dev's

New User


Joined: 12 Mar 2007
Posts: 14
Location: Hyderabad

PostPosted: Wed Jul 23, 2008 10:00 pm
Reply with quote

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
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Wed Jul 23, 2008 10:53 pm
Reply with quote

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
View user's profile Send private message
Dev's

New User


Joined: 12 Mar 2007
Posts: 14
Location: Hyderabad

PostPosted: Fri Jul 25, 2008 10:56 pm
Reply with quote

Hi Frank,

I have changed the DFSPARM parameter's as you mentioned but still the job fails with the same info as below.... icon_rolleyes.gif

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
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Fri Jul 25, 2008 11:25 pm
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts SCOPE PENDING option -check data DB2 2
No new posts OUTFIL with SAVE option DFSORT/ICETOOL 7
No new posts CICS vs LE: STORAGE option CICS 0
No new posts INSYNC option with same function as I... JCL & VSAM 0
No new posts Option DYNALLOC second parameter. DFSORT/ICETOOL 11
Search our Forums:

Back to Top