Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
DFSORT Abending with message - SORT CAPACITY EXCEEDED

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
ganeshprasanna

New User


Joined: 21 Feb 2009
Posts: 36
Location: South Portland, Maine

PostPosted: Thu Nov 17, 2011 12:37 am    Post subject: DFSORT Abending with message - SORT CAPACITY EXCEEDED
Reply with quote

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

Frank Yaeger

DFSORT Moderator


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

PostPosted: Thu Nov 17, 2011 2:23 am    Post subject:
Reply with quote

PARM values on the EXEC statement only apply to the main task, not the subtasks.

If you want to override the number of dynamically allocated work data sets in the F1 subtask, you can use:

Code:

//JNF1CNTL DD *
   OPTION DYNALLOC=(,100)
Back to top
View user's profile Send private message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Thu Nov 17, 2011 11:23 am    Post subject:
Reply with quote

Hi Frank...

Just for the information... Are these parameters like DYNALLOC really required? will the system not able to dynamically allocate the work files?

If no, then how could we decide how much value for DYNALLOC we have to give?

Some time back i wrote a job to generate the sort card dynamically... there i found that the number of lines in the sort card generated by the job came around 25K. Then My sort job failed with the sort capacity exceeded. is there a limit to the SYSIN we can give to a SORT program?
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


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

PostPosted: Fri Nov 18, 2011 3:35 am    Post subject:
Reply with quote

The site sets an installation default for the maximum number of work data sets that will be used; generally that's enough so you don't need to override it. But if the installation default is not big enough for a particular job, you can supply more work data sets using DYNALLOC. You can specify up to 255 work data sets, but if you don't know how many you need, you would usually start at 8, 16 or 32 and go up from there.

SORT CAPACITY EXCEEDED has nothing to do with the number of SYSIN statements. It's means you don't have enough work data sets. If you specified too many control statements, you would get a different error. The limit is pretty high.
Back to top
View user's profile Send private message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Fri Nov 18, 2011 11:04 am    Post subject:
Reply with quote

Thanks Frank...
Back to top
View user's profile Send private message
ganeshprasanna

New User


Joined: 21 Feb 2009
Posts: 36
Location: South Portland, Maine

PostPosted: Fri Nov 18, 2011 8:20 pm    Post subject:
Reply with quote

Thanks Frank.

This specific issue was because of a third party package installed on our site - Space Recovery System (SRS) which dynamically recovers disk space allocation failures.

The SRS product (stopx37 replacement) was performing an addvol operation on the jnf1 sortworks which caused it fail.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts OC4 in SORT Mohan Kothakota DFSORT/ICETOOL 2 Tue Sep 12, 2017 6:30 pm
No new posts SORT Trailer Count - LRECL Output co... amorante DFSORT/ICETOOL 5 Tue Aug 29, 2017 8:57 pm
No new posts Join records from 2 files with No Dup... Poha Eater DFSORT/ICETOOL 21 Sun Aug 27, 2017 10:35 pm
No new posts Changing sort Card Dynamically vickey_dw DFSORT/ICETOOL 5 Sat Aug 19, 2017 2:33 pm
No new posts Default Message in Rexx cvnlynn CLIST & REXX 9 Wed Aug 02, 2017 12:38 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us