IBM Mainframe Forum

Hi ,

Below is the joblog of abend JCL.

When i was doing partitioning work in DB2 ,I got SORT CAPACITY EXCEED message and got abended.

Later on ,I added REGION = 0M and ran the JCL it went well.

I also using SORTWORK Volumes.

I want to know real memory was the issue if so how to fix the value for the region.

Please check the below JOB log and give me a solution.



1ICE200I 0 IDENTIFIER FROM CALLING PROGRAM IS 0001
ICE143I 0 BLOCKSET SORT TECHNIQUE SELECTED
ICE250I 0 VISIT http://www.ibm.com/storage/dfsort FOR DFSORT PAPERS, EXAMPLES AND MORE
ICE000I 0 - CONTROL STATEMENTS FOR 5694-A01, Z/OS DFSORT V1R5 - 13:44 ON SUN MAY 05, 2013 -
0 SORT FIELDS=(00012.0,00031.0,A,00001.0,00005.0,A),FORMAT=BI,FILSZ=E0000*
00663889328
RECORD TYPE=F,LENGTH=(0042,0042,0042)
OPTION MSGPRT=ALL,SORTDD=SW01,MSGDDN=UTPRIN01,MAINSIZE=MAX,USEWKDD
ICE201I F RECORD TYPE IS F - DATA STARTS IN POSITION 1
ICE751I 0 C5-K90013 C6-K90013 C7-K90000 C8-K42135 E4-K90007 C9-BASE E5-K24705 E7-K24705
ICE193I 0 ICEAM2 ENVIRONMENT IN EFFECT - ICEAM2 INSTALLATION MODULE SELECTED
ICE089I 1 #CSS004A.STEP010 . , INPUT LRECL = 42, TYPE = F
ICE093I 0 MAIN STORAGE = (MAX,42991616,42991616)
ICE156I 0 MAIN STORAGE ABOVE 16MB = (42887254,42887254)
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=42991616,MAXLIM=1048576,MINLIM=450560,EQUALS=N,LIST=Y,ERET=RC16 ,MSGDDN=UTPRIN01
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=16384,CINV=Y,CFW=Y,DSA=41
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=1459 ,DSPSIZE=100 ,ODMAXBF=0,SOLRF=Y,VLLONG=N,VSAMIO=N,MOSIZE=MAX
ICE235I 0 OPTIONS: NULLOUT=RC0
ICE750I 0 DC 0 TC 0 CS DSVVV KSZ 36 VSZ 36
ICE752I 0 FSZ=663889328 RE IGN=0 C AVG=44 0 WSP=37940238 E DYN=0 0
ICE046A 0 SORT CAPACITY EXCEEDED - RECORD COUNT 631813858
ICE751I 1 DE-K24705 D5-K24705 E8-K90013
ICE052I 0 END OF DFSORT
1ICE200I 0 IDENTIFIER FROM CALLING PROGRAM IS 0002
ICE143I 0 BLOCKSET SORT TECHNIQUE SELECTED
ICE250I 0 VISIT http://www.ibm.com/storage/dfsort FOR DFSORT PAPERS, EXAMPLES AND MORE
ICE000I 0 - CONTROL STATEMENTS FOR 5694-A01, Z/OS DFSORT V1R5 - 13:44 ON SUN MAY 05, 2013 -
0 SORT FIELDS=(00012.0,00029.0,A,00001.0,00005.0,A),FORMAT=BI,FILSZ=E0000*
00663889328
RECORD TYPE=F,LENGTH=(0040,0040,0040)
OPTION MSGPRT=ALL,SORTDD=SW02,MSGDDN=UTPRIN02,MAINSIZE=MAX,USEWKDD
ICE201I F RECORD TYPE IS F - DATA STARTS IN POSITION 1
ICE751I 0 C5-K90013 C6-K90013 C7-K90000 C8-K42135 E4-K90007 C9-BASE E5-K24705 E7-K24705
ICE193I 0 ICEAM2 ENVIRONMENT IN EFFECT - ICEAM2 INSTALLATION MODULE SELECTED
ICE089I 1 #CSS004A.STEP010 . UPRC, INPUT LRECL = 40, TYPE = F
ICE093I 0 MAIN STORAGE = (MAX,42991616,42991616)
ICE156I 0 MAIN STORAGE ABOVE 16MB = (42887256,42887256)
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=42991616,MAXLIM=1048576,MINLIM=450560,EQUALS=N,LIST=Y,ERET=RC16 ,MSGDDN=UTPRIN02
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=16384,CINV=Y,CFW=Y,DSA=41
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=1459 ,DSPSIZE=100 ,ODMAXBF=0,SOLRF=Y,VLLONG=N,VSAMIO=N,MOSIZE=MAX
ICE235I 0 OPTIONS: NULLOUT=RC0
ICE750I 0 DC 0 TC 0 CS DSVVV KSZ 34 VSZ 34
ICE752I 0 FSZ=663889328 RE IGN=0 C AVG=40 0 WSP=34491125 E DYN=0 0
ICE751I 2 DE-K24705 D5-K24705 DA-K28804
ICE185A 0 AN S13E ABEND WAS ISSUED BY DFSORT, ANOTHER PROGRAM OR AN EXIT (PHASE S 1)

Hello,

It will help if you post the JCL and control statements submitted.

Hi Dick Scherrer,

Thanks for the reply , Here it is ..

Control statement :

LOAD DATA INDDN SYSREC LOG NO REPLACE SORTDEVT SYSDA COPYDDN SYSCOPY ASCII
CCSID(819, 0, 0)
INTO TABLE XXXXXX.XXXXX ( ... )


JCL :

//STEP010 EXEC xxxx1UPRC,WSPC=100
8 XXxxxx1UPRC PROC WSPC=1,UID='',UTPROC=''
9 XXxxxx1UPRC EXEC PGM=DSNUTILB,REGION=100M,PARM='xxxx1,&UID,&UTPROC'
IEFC653I SUBSTITUTION JCL - PGM=DSNUTILB,REGION=100M,PARM='xxxx1,,'
10 XXSTEPLIB DD DSN=DB2.SDSNLOAD,DISP=SHR
11 XXSORTLIB DD DSN=SYS1.SORTLIB,DISP=SHR
12 //SYSPRINT DD SYSOUT=*
X/SYSPRINT DD SYSOUT=*
13 XXUTPRINT DD SYSOUT=*
14 XXDSNTRACE DD SYSOUT=*
15 XXSYSUDUMP DD SYSOUT=*
16 //SYSUT1 DD DSN=PARTIT.SORT.xxxxFI1.LOAD.SYSUT1,
// DISP=(NEW,DELETE,DELETE),DSNTYPE=LARGE,
// SPACE=(CYL,(4369,4369)),UNIT=SYSDA
X/SYSUT1 DD UNIT=DISK,SPACE=(CYL,(&WSPC,&WSPC))
IEFC653I SUBSTITUTION JCL - UNIT=DISK,SPACE=(CYL,(100,100))
17 //SORTOUT DD DSN=PARTIT.SORT.xxxxFI1.LOAD.SORTOUT,
// DISP=(NEW,DELETE,DELETE),DSNTYPE=LARGE,
// SPACE=(CYL,(4369,4369)),UNIT=SYSDA
X/SORTOUT DD UNIT=DISK,SPACE=(CYL,(&WSPC,&WSPC))
IEFC653I SUBSTITUTION JCL - UNIT=DISK,SPACE=(CYL,(100,100))
18 XXSORTWK01 DD UNIT=DISK,SPACE=(CYL,(&WSPC,&WSPC))
IEFC653I SUBSTITUTION JCL - UNIT=DISK,SPACE=(CYL,(100,100))
19 XXSORTWK02 DD UNIT=DISK,SPACE=(CYL,(&WSPC,&WSPC))
IEFC653I SUBSTITUTION JCL - UNIT=DISK,SPACE=(CYL,(100,100))
20 XXSORTWK03 DD UNIT=DISK,SPACE=(CYL,(&WSPC,&WSPC))
IEFC653I SUBSTITUTION JCL - UNIT=DISK,SPACE=(CYL,(100,100))
21 XXSORTWK04 DD UNIT=DISK,SPACE=(CYL,(&WSPC,&WSPC))
IEFC653I SUBSTITUTION JCL - UNIT=DISK,SPACE=(CYL,(100,100))
22 XXSYSDISC DD UNIT=DISK,SPACE=(TRK,(15,15))
23 XXSYSERR DD UNIT=DISK,SPACE=(TRK,(15,15))
24 //SYSMAP DD DSN=PARTIT.SORT.xxxxFI1.LOAD.SYSMAP,
// DISP=(NEW,DELETE,DELETE),DSNTYPE=LARGE,
// SPACE=(CYL,(4369,4369)),UNIT=SYSDA
X/SYSMAP DD UNIT=DISK,SPACE=(CYL,(&WSPC,&WSPC))
IEFC653I SUBSTITUTION JCL - UNIT=DISK,SPACE=(CYL,(100,100))
25 //SYSREC DD DSN=xxxxxxxxx.xxxxFI1,DISP=SHR
26 //SYSCOPY DD DSN=PARTIT.xxxxFI1.LOAD.D130505.SYSCOPY,
// DISP=(NEW,CATLG,CATLG),DSNTYPE=LARGE,
// SPACE=(CYL,(4369,4369)),UNIT=SYSDA
27 //SYSIN DD *

Any updates, would help me to sort out the issue !!!!

Any updates, would help me to sort out the issue !!!!

soliciting for answers is a pretty inconsiderate forum behavior,

remember ...
we reply on our time and free of charge,

there is NO COMMITMENT to reply
there should no NO EXPECTATION for an answer.

for time critical problems a forum is not the best place to seek for help.

I will move this to the DFSort section as the IBM DFSort team may be the better qualified to reply.

Thanks Nic

Wasn't sure if this might be a DB2 question (as DB2 quietly invokes DFSORT when data needs to be sorted).

Moving to the DFSort section sounds good.

Later,

d

parthiban,

Read chapter 6.7 Debugging DFSORT problems in this redbook

http://www.redbooks.ibm.com/abstracts/sg246289.html

Here is the section in brief for you. Pay attention to the items in bold.

When you see:

this means that this error was a consequence of another error in another sort subtask. Typical error messages that will appear in an abending sort subtask are:

ICE039A INSUFFICIENT MAIN STORAGE
ICE046A SORT CAPACITY EXCEEDED
ICE083A RESOURCES WERE UNAVAILABLE FOR DYNAMIC ALLOCATION OF WORK DATA SETS

Typical actions to do when you encounter DFSORT problems are:

Make sure VIO=NO (the DFSORT's installation default).
Increase the region size of the job to avoid insufficient virtual storage problems.
Ensure that there is enough free space available in the sort pool. Eventually, add one or more DASD volumes to it. Ensure that the work data sets are not allocated as multivolume data sets. DFSORT can only use the part of the sort work data set that resides on the first volume.

Use the SORTNUM elimination feature and let DB2 dynamically preallocate sort work data sets by:

– Deleting all the sort related DD cards (SORTWKnn, SW01WKnn, DATAWKnn,DA01WKnn, STATWKnn, and ST01WKnn,UTPRINnn,DTPRINnn) from the JCL.,except UTPRINT and SORTDIAG
– Setting the DB2 subsystem parameter UTSORTAL=YES
– Removing the SORTNUM parameter from the utility control statement

Compare the FILSZ value and average record length passed by DB2 with the actual number of records to be sorted and the actual average record length. See Example 6-15.Large discrepancies between the actual values and the information provided by DB2 can cause problems.