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                                                 

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html

Reply via email to