Z/OS DFSORT V1R5 - sort capacity exceeded error



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Z/OS DFSORT V1R5 - sort capacity exceeded error

Postby hazel.alzaga » Fri Nov 19, 2010 10:37 am

Hi,

We received a sort capacity exceeded error on one our of batch job. Input file is compressed and is only 30trks in size. Our operator had tried increasing the region size from 8m to 256M but still received the same error. We,on the other hand,had tried the 'option dynalloc and option dynalloc=(sysda,n)' but still encountered the same error. But when we define the SORTWK01 DD statement(regardless if its trk(1,1) or trk(10,10) or cyl(100,50) ,we successfully had rc=0. Would like to know the reason why such incident happened. please refer to below attachements for details.
IBMForum_sort capacity exceeded.doc
You do not have the required permissions to view the files attached to this post.
hazel.alzaga
 
Posts: 4
Joined: Fri Nov 19, 2010 7:25 am
Has thanked: 0 time
Been thanked: 0 time

Re: Z/OS DFSORT V1R5 - sort capacity exceeded error

Postby dick scherrer » Fri Nov 19, 2010 10:46 am

Hello and welcome to the forum,

It is best not to post attachments. Not everyone is permitted to download them. . .

You need to look at the actual error message and read about that message in the documentation.

It will help if you post the jcl and control statements for one of the problem runs and one that works correctly.

Show the difference in the diagnostic info generated by these.

To post code, jcl, etc, use copy/paste and the "Code" tag. Use Preview to see your post as it will appear to the forum (rahter than how it appears n the Reply Editor). Coded info will look like this:
a code tag
example
Using the code tag will preserve alignment.

I do not understand what type of compression is used for the data :?
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: Z/OS DFSORT V1R5 - sort capacity exceeded error

Postby steve-myers » Fri Nov 19, 2010 11:06 am

The SORT control statement has an option to give sort an estimate of the number of records in the sort input. Use it! If you give sort a reasonably accurate estimate it can allocate enough sort work space to run the sort without getting sort capacity exceeded.
steve-myers
Global moderator
 
Posts: 2105
Joined: Thu Jun 03, 2010 6:21 pm
Has thanked: 4 times
Been thanked: 243 times

Re: Z/OS DFSORT V1R5 - sort capacity exceeded error

Postby hazel.alzaga » Fri Nov 19, 2010 11:24 am

Thanks! :D

Below is the jcl and control statements which encountered sort capacity exceeded problem:
//SORTTEST  JOB   (PRET),'VHINO',CLASS=A,MSGLEVEL=(1,1),     
//         MSGCLASS=H,NOTIFY=DM71082,REGION=8M               
//* $ACFJ219 ACF2 ACTIVE JES2ADCP                             
//*                                                           
//STEP000  EXEC PGM=IEFBR14                                   
//*                                                           
//*                                                           
//SRTDL010 EXEC PGM=SORT,COND=(4,LT)                       
//SYSOUT   DD SYSOUT=*                                     
//SORTIN   DD DSN=DEP.DMT.TESTDCLS.SAMPLE.APPRP.TS,DISP=SHR
//SORTOUT  DD DSN=&&TEMPCRMS,                               
//            DISP=(NEW,PASS),                             
//            UNIT=SYSDA,                                   
//            DCB=(RECFM=FB,LRECL=250,BLKSIZE=0),           
//            SPACE=(TRK,(50,50),RLSE)                     
//*SORTWK01 DD UNIT=SYSDA,SPACE=(CYL,(100,50),RLSE)         
//SYSIN    DD DSN=DEP.DMT.HAZEL.SORT(ACJSRTDL),DISP=SHR     
//SORTDIAG DD DUMMY   
******
ICE143I 0 BLOCKSET     SORT  TECHNIQUE SELECTED                                 
ICE250I 0 VISIT http://www.ibm.com/storage/dfsort FOR DFSORT PAPERS, EXAMPLES AND MORE                     
ICE000I 1 - CONTROL STATEMENTS FOR 5694-A01, Z/OS DFSORT V1R5 - 11:01 ON FRI NOV 19, 2010 -     
            SORT FIELDS=(11,12,CH,A,1,10,CH,A)                                 
            OMIT COND=(1,10,CH,EQ,C'          ')                               
ICE201I 0 RECORD TYPE IS F - DATA STARTS IN POSITION 1                         
ICE751I 0 C5-K05352 C6-Q95214 C7-K90000 C8-K05352 EE-BASE   E4-K06751 C9-BASE   E5-K90000 E7-K90000   
ICE193I 0 ICEAM1 ENVIRONMENT IN EFFECT - ICEAM1 INSTALLATION MODULE SELECTED   
ICE088I 1 SORTTEST.SRTDL010.        , INPUT LRECL = 250, BLKSIZE = 4096, TYPE = F     
ICE093I 0 MAIN STORAGE = (MAX,6291456,6291456)                                 
ICE156I 0 MAIN STORAGE ABOVE 16MB = (6234096,6234096)                           
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=6291456,MAXLIM=1048576,MINLIM=450560,EQUALS=N,LIST=Y,ERET=RC16 ,MSGDDN=SYSOUT       
ICE129I 0 OPTIONS: VIO=N,RESDNT=ALL ,SMF=NO   ,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,STIMER=Y,COBEXIT=COB2           
ICE131I 0 OPTIONS: TMAXLIM=6291456,ARESALL=0,ARESINV=0,OVERRGN=65536,CINV=Y,CFW=Y,DSA=0       
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 EXCP ACCESS METHOD USED FOR SORTOUT                             
ICE084I 1 VSAM ACCESS METHOD USED FOR SORTIN                             
ICE750I 0 DC 388000 TC 0 CS DSVVV KSZ 22 VSZ 22                           
ICE752I 0 FSZ=1552 RC  IGN=0 E  AVG=252 0  WSP=508 C  DYN=0 0             
ICE915I 0 MOFSZ=0,MOSZ=0,MOSYS=0(2),MOSTG=2051,MEML=0(1)                       
ICE916I 0 MOFR=0603,MOVR=77                                                   
ICE996I 0 ESM=1537536,ESO=1537536,ESR=0,ESP=4096,ESS=16384,CES=1537536,HSZ=524288
ICE997I 0 HWSP=0,HMAX=525177,HES=0,ASV=525177,EQ=N0,HN=0                       
ICE898I 0 OMAX=268813,NMAX=525177,TMAX=525177,CMAX=0,HU=0,BUN=0,MD=N3,DU=0,DR=0,HN=0 
ICE889I 0 CT=MAX     , SB=8, L=0, D=0000                                       
ICE902I 0 O HY00  I PP10                                                       
ICE046A 1 SORT CAPACITY EXCEEDED - RECORD COUNT 2421                           
ICE751I 1 DE-K90000 D5-K05352 E8-K90000                                       
ICE052I 0 END OF DFSORT                                                                                         


We also tried adjusting the region size from 1028K, 2M, 8M to 256M but still had sort capacity exceeded error. We had read that we can use option dynalloc or option dynalloc=(sysda,n) but still same error occured. Finally,we define sortwk01 dd statement and the job successfully issued rc=0.
//SRTDL010 EXEC PGM=SORT,COND=(4,LT)                             
//SYSOUT   DD SYSOUT=*                                           
//SORTIN   DD DSN=DEP.DMT.TESTDCLS.SAMPLE.APPRP.TS,DISP=SHR     
//SORTOUT  DD DSN=&&TEMPCRMS,                                   
//            DISP=(NEW,PASS),                                   
//            UNIT=SYSDA,                                       
//            DCB=(RECFM=FB,LRECL=250,BLKSIZE=0),               
//            SPACE=(TRK,(50,50),RLSE)                           
//SORTWK01 DD UNIT=SYSDA,SPACE=(TRK,(1,1),RLSE)                 
//SYSIN    DD DSN=DEP.DMT.HAZEL.SORT(ACJSRTDL),DISP=SHR         


ICE143I 0 BLOCKSET     SORT  TECHNIQUE SELECTED                                 
ICE250I 0 VISIT http://www.ibm.com/storage/dfsort FOR DFSORT PAPERS, EXAMPLES AND MORE       
ICE000I 1 - CONTROL STATEMENTS FOR 5694-A01, Z/OS DFSORT V1R5 - 11:03 ON FRI NOV 19, 2010 -   
            SORT FIELDS=(11,12,CH,A,1,10,CH,A)                                 
            OMIT COND=(1,10,CH,EQ,C'          ')                               
ICE136I 0 SPACE FOR SORTWK01 WAS READJUSTED TO CYLINDERS                       
ICE201I 0 RECORD TYPE IS F - DATA STARTS IN POSITION 1                         
ICE751I 0 C5-K05352 C6-Q95214 C7-K90000 C8-K05352 EE-BASE   E4-K06751 C9-BASE  E5-K90000 E7-K90000 
ICE193I 0 ICEAM1 ENVIRONMENT IN EFFECT - ICEAM1 INSTALLATION MODULE SELECTED   
ICE088I 1 SORTTEST.SRTDL010.        , INPUT LRECL = 250, BLKSIZE = 4096, TYPE = F
ICE093I 0 MAIN STORAGE = (MAX,6291456,6291456)                                 
ICE156I 0 MAIN STORAGE ABOVE 16MB = (6231288,6231288)                           
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=6291456,MAXLIM=1048576,MINLIM=450560,EQUALS=N,LIST=Y,ERET=RC16 ,MSGDDN=SYSOUT 
ICE129I 0 OPTIONS: VIO=N,RESDNT=ALL ,SMF=NO   ,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,STIMER=Y,COBEXIT=COB2     
ICE131I 0 OPTIONS: TMAXLIM=6291456,ARESALL=0,ARESINV=0,OVERRGN=65536,CINV=Y,CFW=Y,DSA=0       
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 EXCP ACCESS METHOD USED FOR SORTOUT                                   
ICE084I 1 VSAM ACCESS METHOD USED FOR SORTIN                                   
ICE750I 0 DC 388000 TC 0 CS DSVVV KSZ 22 VSZ 22                                 
ICE752I 0 FSZ=1552 RC  IGN=0 E  AVG=252 0  WSP=508 C  DYN=0 0                   
ICE751I 1 DE-K90000 D5-K05352 D9-K90000 E8-K90000                               
ICE090I 0 OUTPUT LRECL = 250, BLKSIZE = 27750, TYPE = FB                       
ICE080I 0 IN MAIN STORAGE SORT                                                 
ICE055I 0 INSERT 0, DELETE 1                                                   
ICE054I 0 RECORDS - IN: 3172, OUT: 3171                                         
ICE134I 0 NUMBER OF BYTES SORTED: 792750                                       
ICE165I 0 TOTAL WORK DATA SET TRACKS ALLOCATED: 1 , TRACKS USED: 0             
ICE199I 0 MEMORY OBJECT STORAGE USED = 0M BYTES                                 
ICE180I 0 HIPERSPACE STORAGE USED = 0K BYTES                                   
ICE188I 0 DATA SPACE STORAGE USED = 0K BYTES                                   
ICE052I 0 END OF DFSORT                 
hazel.alzaga
 
Posts: 4
Joined: Fri Nov 19, 2010 7:25 am
Has thanked: 0 time
Been thanked: 0 time

Re: Z/OS DFSORT V1R5 - sort capacity exceeded error

Postby hazel.alzaga » Fri Nov 19, 2010 2:45 pm

hazel.alzaga wrote:Thanks! :D

Below is the jcl and control statements which encountered sort capacity exceeded problem:
//SORTTEST  JOB   (PRET),'VHINO',CLASS=A,MSGLEVEL=(1,1),     
//         MSGCLASS=H,NOTIFY=DM71082,REGION=8M               
//* $ACFJ219 ACF2 ACTIVE JES2ADCP                             
//*                                                           
//STEP000  EXEC PGM=IEFBR14                                   
//*                                                           
//*                                                           
//SRTDL010 EXEC PGM=SORT,COND=(4,LT)                       
//SYSOUT   DD SYSOUT=*                                     
//SORTIN   DD DSN=DEP.DMT.TESTDCLS.SAMPLE.APPRP.TS,DISP=SHR
//SORTOUT  DD DSN=&&TEMPCRMS,                               
//            DISP=(NEW,PASS),                             
//            UNIT=SYSDA,                                   
//            DCB=(RECFM=FB,LRECL=250,BLKSIZE=0),           
//            SPACE=(TRK,(50,50),RLSE)                     
//*SORTWK01 DD UNIT=SYSDA,SPACE=(CYL,(100,50),RLSE)         
//SYSIN    DD DSN=DEP.DMT.HAZEL.SORT(ACJSRTDL),DISP=SHR     
//SORTDIAG DD DUMMY   
******
ICE143I 0 BLOCKSET     SORT  TECHNIQUE SELECTED                                 
ICE250I 0 VISIT http://www.ibm.com/storage/dfsort FOR DFSORT PAPERS, EXAMPLES AND MORE                     
ICE000I 1 - CONTROL STATEMENTS FOR 5694-A01, Z/OS DFSORT V1R5 - 11:01 ON FRI NOV 19, 2010 -     
            SORT FIELDS=(11,12,CH,A,1,10,CH,A)                                 
            OMIT COND=(1,10,CH,EQ,C'          ')                               
ICE201I 0 RECORD TYPE IS F - DATA STARTS IN POSITION 1                         
ICE751I 0 C5-K05352 C6-Q95214 C7-K90000 C8-K05352 EE-BASE   E4-K06751 C9-BASE   E5-K90000 E7-K90000   
ICE193I 0 ICEAM1 ENVIRONMENT IN EFFECT - ICEAM1 INSTALLATION MODULE SELECTED   
ICE088I 1 SORTTEST.SRTDL010.        , INPUT LRECL = 250, BLKSIZE = 4096, TYPE = F     
ICE093I 0 MAIN STORAGE = (MAX,6291456,6291456)                                 
ICE156I 0 MAIN STORAGE ABOVE 16MB = (6234096,6234096)                           
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=6291456,MAXLIM=1048576,MINLIM=450560,EQUALS=N,LIST=Y,ERET=RC16 ,MSGDDN=SYSOUT       
ICE129I 0 OPTIONS: VIO=N,RESDNT=ALL ,SMF=NO   ,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,STIMER=Y,COBEXIT=COB2           
ICE131I 0 OPTIONS: TMAXLIM=6291456,ARESALL=0,ARESINV=0,OVERRGN=65536,CINV=Y,CFW=Y,DSA=0       
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 EXCP ACCESS METHOD USED FOR SORTOUT                             
ICE084I 1 VSAM ACCESS METHOD USED FOR SORTIN                             
ICE750I 0 DC 388000 TC 0 CS DSVVV KSZ 22 VSZ 22                           
ICE752I 0 FSZ=1552 RC  IGN=0 E  AVG=252 0  WSP=508 C  DYN=0 0             
ICE915I 0 MOFSZ=0,MOSZ=0,MOSYS=0(2),MOSTG=2051,MEML=0(1)                       
ICE916I 0 MOFR=0603,MOVR=77                                                   
ICE996I 0 ESM=1537536,ESO=1537536,ESR=0,ESP=4096,ESS=16384,CES=1537536,HSZ=524288
ICE997I 0 HWSP=0,HMAX=525177,HES=0,ASV=525177,EQ=N0,HN=0                       
ICE898I 0 OMAX=268813,NMAX=525177,TMAX=525177,CMAX=0,HU=0,BUN=0,MD=N3,DU=0,DR=0,HN=0 
ICE889I 0 CT=MAX     , SB=8, L=0, D=0000                                       
ICE902I 0 O HY00  I PP10                                                       
ICE046A 1 SORT CAPACITY EXCEEDED - RECORD COUNT 2421                           
ICE751I 1 DE-K90000 D5-K05352 E8-K90000                                       
ICE052I 0 END OF DFSORT                                                                                         


We also tried adjusting the region size from 1028K, 2M, 8M to 256M but still had sort capacity exceeded error. We had read that we can use option dynalloc or option dynalloc=(sysda,n) but still same error occured. Finally,we define sortwk01 dd statement and the job successfully issued rc=0.
//SRTDL010 EXEC PGM=SORT,COND=(4,LT)                             
//SYSOUT   DD SYSOUT=*                                           
//SORTIN   DD DSN=DEP.DMT.TESTDCLS.SAMPLE.APPRP.TS,DISP=SHR     
//SORTOUT  DD DSN=&&TEMPCRMS,                                   
//            DISP=(NEW,PASS),                                   
//            UNIT=SYSDA,                                       
//            DCB=(RECFM=FB,LRECL=250,BLKSIZE=0),               
//            SPACE=(TRK,(50,50),RLSE)                           
//SORTWK01 DD UNIT=SYSDA,SPACE=(TRK,(1,1),RLSE)                 
//SYSIN    DD DSN=DEP.DMT.HAZEL.SORT(ACJSRTDL),DISP=SHR         


ICE143I 0 BLOCKSET     SORT  TECHNIQUE SELECTED                                 
ICE250I 0 VISIT http://www.ibm.com/storage/dfsort FOR DFSORT PAPERS, EXAMPLES AND MORE       
ICE000I 1 - CONTROL STATEMENTS FOR 5694-A01, Z/OS DFSORT V1R5 - 11:03 ON FRI NOV 19, 2010 -   
            SORT FIELDS=(11,12,CH,A,1,10,CH,A)                                 
            OMIT COND=(1,10,CH,EQ,C'          ')                               
ICE136I 0 SPACE FOR SORTWK01 WAS READJUSTED TO CYLINDERS                       
ICE201I 0 RECORD TYPE IS F - DATA STARTS IN POSITION 1                         
ICE751I 0 C5-K05352 C6-Q95214 C7-K90000 C8-K05352 EE-BASE   E4-K06751 C9-BASE  E5-K90000 E7-K90000 
ICE193I 0 ICEAM1 ENVIRONMENT IN EFFECT - ICEAM1 INSTALLATION MODULE SELECTED   
ICE088I 1 SORTTEST.SRTDL010.        , INPUT LRECL = 250, BLKSIZE = 4096, TYPE = F
ICE093I 0 MAIN STORAGE = (MAX,6291456,6291456)                                 
ICE156I 0 MAIN STORAGE ABOVE 16MB = (6231288,6231288)                           
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=6291456,MAXLIM=1048576,MINLIM=450560,EQUALS=N,LIST=Y,ERET=RC16 ,MSGDDN=SYSOUT 
ICE129I 0 OPTIONS: VIO=N,RESDNT=ALL ,SMF=NO   ,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,STIMER=Y,COBEXIT=COB2     
ICE131I 0 OPTIONS: TMAXLIM=6291456,ARESALL=0,ARESINV=0,OVERRGN=65536,CINV=Y,CFW=Y,DSA=0       
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 EXCP ACCESS METHOD USED FOR SORTOUT                                   
ICE084I 1 VSAM ACCESS METHOD USED FOR SORTIN                                   
ICE750I 0 DC 388000 TC 0 CS DSVVV KSZ 22 VSZ 22                                 
ICE752I 0 FSZ=1552 RC  IGN=0 E  AVG=252 0  WSP=508 C  DYN=0 0                   
ICE751I 1 DE-K90000 D5-K05352 D9-K90000 E8-K90000                               
ICE090I 0 OUTPUT LRECL = 250, BLKSIZE = 27750, TYPE = FB                       
ICE080I 0 IN MAIN STORAGE SORT                                                 
ICE055I 0 INSERT 0, DELETE 1                                                   
ICE054I 0 RECORDS - IN: 3172, OUT: 3171                                         
ICE134I 0 NUMBER OF BYTES SORTED: 792750                                       
ICE165I 0 TOTAL WORK DATA SET TRACKS ALLOCATED: 1 , TRACKS USED: 0             
ICE199I 0 MEMORY OBJECT STORAGE USED = 0M BYTES                                 
ICE180I 0 HIPERSPACE STORAGE USED = 0K BYTES                                   
ICE188I 0 DATA SPACE STORAGE USED = 0K BYTES                                   
ICE052I 0 END OF DFSORT                 


But we're still wondering why defining the sortwk01 resolves the sort capacity exceeded. And we're still looking for other possible solution w/o the need to define sortwork dd stmts.
hazel.alzaga
 
Posts: 4
Joined: Fri Nov 19, 2010 7:25 am
Has thanked: 0 time
Been thanked: 0 time

Re: Z/OS DFSORT V1R5 - sort capacity exceeded error

Postby Frank Yaeger » Sat Nov 20, 2010 2:26 am

Hazel,

The filesize DFSORT determined for the VSAM input data set was less than the actual filesize. I suspect based on the filesize, DFSORT didn't think it needed any work space, so it didn't dynamicallty allocate any (either that or your installation is not allowing dynamically allocated work data sets). It may be that the VSAM catalog has incorrect information for the filesize.

Adding one SORTWKnn DD overrode dynamic allocation of work data sets, so one work data set was available.

You could try adding FILSZ=Un where n is a good estimate of the number of records in the input file. Or you could keep the SORTWKnn DD. Or you could try to figure out why the catalog information for the VSAM input data set is incorrect.

If you want somebody to analyze this further, you'll need to open a problem (PMR) with IBM service. The helpboard is not the appropriate place for that kind of analysis.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times

Re: Z/OS DFSORT V1R5 - sort capacity exceeded error

Postby hazel.alzaga » Tue Nov 23, 2010 8:10 am

Thanks Frank! We'll keep the sortwknn for now.
hazel.alzaga
 
Posts: 4
Joined: Fri Nov 19, 2010 7:25 am
Has thanked: 0 time
Been thanked: 0 time


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post