SORT CAPACITY EXCEED - REGION 0M



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

SORT CAPACITY EXCEED - REGION 0M

Postby parthiban » Mon May 13, 2013 7:29 pm

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)
Parthiban jayaraman
mainframe rexxer,
Banglore
parthiban
 
Posts: 66
Joined: Mon Oct 20, 2008 7:54 pm
Location: Bangalore-India
Has thanked: 0 time
Been thanked: 0 time

Re: SORT CAPACITY EXCEED - REGION 0M

 

Re: SORT CAPACITY EXCEED - REGION 0M

Postby dick scherrer » Mon May 13, 2013 7:34 pm

Hello,

It will help if you post the JCL and control statements submitted.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: SORT CAPACITY EXCEED - REGION 0M

Postby parthiban » Mon May 13, 2013 7:40 pm

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 *
Parthiban jayaraman
mainframe rexxer,
Banglore
parthiban
 
Posts: 66
Joined: Mon Oct 20, 2008 7:54 pm
Location: Bangalore-India
Has thanked: 0 time
Been thanked: 0 time

Re: SORT CAPACITY EXCEED - REGION 0M

Postby parthiban » Tue May 14, 2013 11:51 am

Any updates, would help me to sort out the issue !!!!
Parthiban jayaraman
mainframe rexxer,
Banglore
parthiban
 
Posts: 66
Joined: Mon Oct 20, 2008 7:54 pm
Location: Bangalore-India
Has thanked: 0 time
Been thanked: 0 time

Re: SORT CAPACITY EXCEED - REGION 0M

Postby enrico-sorichetti » Tue May 14, 2013 12:02 pm

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.
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2643
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 130 times

Re: SORT CAPACITY EXCEED - REGION 0M

Postby NicC » Tue May 14, 2013 5:35 pm

I will move this to the DFSort section as the IBM DFSort team may be the better qualified to reply.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2690
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times

Re: SORT CAPACITY EXCEED - REGION 0M

Postby dick scherrer » Tue May 14, 2013 7:17 pm

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
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: SORT CAPACITY EXCEED - REGION 0M

Postby skolusu » Tue May 14, 2013 9:54 pm

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:
ICE185A 0 AN S13E ABEND WAS ISSUED BY DFSORT, ANOTHER PROGRAM OR AN EXIT (PHASE S 1)


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.
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
skolusu
 
Posts: 586
Joined: Wed Apr 02, 2008 10:38 pm
Has thanked: 0 time
Been thanked: 39 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post