On Thu, 14 Jan 2010 20:19:59 -0600, R Hey <[email protected]> wrote: >Hi Frank/List, > >My client has some very big SORT jobs. >When a few run at the the same time, the page DS USE% increases >(demanding paging). > >Q1- >How do I make sure BIG sort jobs don't use too many frames, >when they are hard to get? > >Q2- >Given the sort options we use, is it true that >SORT will use TMAXLIM size of storage, >then if data is too big, it will increase the storage use to max of DSA >size? >So it never goes over DSA size? > >Q3- >If I get >ICE199I 0 MEMORY OBJECT STORAGE USED = 3463M BYTES >it means 3.4GB of data was sorted in memory, right? > >Q4- >If YES to both Q2/Q3, then how is 3GB of data is sorted in 64M of memory >(our DSA) >If, not, how does it work? > >Q5- >We use SIZE=MAX, but the job has SIZE=32259547 (it can be different for >another run). >Is this because the size of data being sorted determines the actual SIZE >used? > > >TIA, >Rez > > >Our sort option are: > >MODULE ICEAM1 > - - - - - - - - - - - >ARESALL 0 >ARESINV NOT APPLICABLE > - - - - - - - - - - - >DSA 64 > - - - - - - - - - - - >DYNALOC (SYSALLDA,3) > * (SYSDA,4) > - - - - - - - - - - - >EXPMAX MAX >EXPOLD MAX >EXPRES 0 > - - - - - - - - - - - >HIPRMAX OPTIMAL > - - - - - - - - - - - >MAXLIM 1048576 >MINLIM 450560 >MOSIZE MAX > - - - - - - - - - - - >OVERRGN 65536 >RESALL 4096 >RESET YES >RESINV NOT APPLICABLE > - - - - - - - - - - >SIZE MAX > - - - - - - - - - - >TMAXLIM 6291456 > - - - - - - - - - - >VIO NO > > >joblog had: > >ICE193I 0 ICEAM1 ENVIRONMENT IN EFFECT - ICEAM1 INSTALLATION >MODULE >SELECTED >ICE088I 5 PAK328 .SORT305 . , INPUT LRECL = 650, BLKSIZE = 27950, TYPE = >FB >ICE093I 0 MAIN STORAGE = (MAX,32259547,32259547) >ICE156I 0 MAIN STORAGE ABOVE 16MB = (32122707,32122707) >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=32259547,MAXLIM=1048576,MINLIM=450560,EQUALS=N,LIST=Y,ERET=AB >END,MS >GDDN=SYSOUT >ICE129I 0 OPTIONS: VIO=N,RESDNT=ALL ,SMF=NO >,WRKSEC=Y,OUTSEC=Y,VERIFY=N,CHALT=N,DYNALOC= >(SCRATCH ,004),ABCODE=MSG >ICE130I 0 OPTIONS: RESALL=4096,RESINV=0,SVC=109 >,CHECK=N,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,DS >A=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 >ICE084I 0 EXCP ACCESS METHOD USED FOR SORTOUT >ICE084I 0 EXCP ACCESS METHOD USED FOR SORTIN >ICE750I 0 DC 3576062750 TC 0 CS DSVVV KSZ 36 VSZ 36 >ICE752I 0 FSZ=5501635 RC IGN=0 E AVG=652 0 WSP=4658983 C DYN=0 >0 >ICE751I 1 BA-K22788 BB-K24705 BC-K24705 E8-K90013 >ICE090I 0 OUTPUT LRECL = 650, BLKSIZE = 27950, TYPE = FB (SDB) >ICE080I 0 IN MAIN STORAGE SORT >ICE055I 0 INSERT 0, DELETE 0 >ICE054I 0 RECORDS - IN: 5501623, OUT: 5501623 >ICE134I 0 NUMBER OF BYTES SORTED: 3576054950 >ICE165I 0 TOTAL WORK DATA SET TRACKS ALLOCATED: 0 , TRACKS USED: >0 >ICE199I 0 MEMORY OBJECT STORAGE USED = 3463M BYTES >ICE180I 0 HIPERSPACE STORAGE USED = 0K BYTES >ICE188I 0 DATA SPACE STORAGE USED = 0K BYTES >ICE052I 0 END OF DFSORT >
Recommend you start at the IBM DFSORT home-page where there are several documentation and supplemental technical references on DFSORT and memory usage. Scott Barry SBBWorks, Inc. Suggested Google advanced search argument on this topic: dfsort memory usage site:ibm.com ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
