IBM Mainframe Forum

Mainframe Technical Support Forums
https://www.ibmmainframeforum.com/

Sort Capacity exceeded in Reorg Step

https://www.ibmmainframeforum.com/dfsort-icetool-icegener/topic12319.html

Page 1 of 1

Sort Capacity exceeded in Reorg Step

PostPosted: Mon Dec 09, 2019 6:45 pm
by samb01
Hello,

we are try to reorg a Huge Tablespace but we have this message :

Select all

ICE046A 0 SORT CAPACITY EXCEEDED - RECORD COUNT 524271971              
ICE253I 0 RECORDS SORTED - PROCESSED: 524271971, EXPECTED: 526809018    
ICE751I 1 DE-BASE   D5-BASE   E8-I49502                                
ICE052I 0 END OF DFSORT                                                

 


The sysin is :

Select all

//S1       EXEC PGM=DSNUTILB,PARM='DB2,REORG.'              
//SYSPRINT DD SYSOUT=*                                          
//UTPRINT  DD SYSOUT=*                                          
//SYSUDUMP DD SYSOUT=W,HOLD=YES                                  
//SYSREC   DD DSN=DATASET.TRAV,DISP=OLD,              
//         RECFM=VB,LRECL=32700,BLKSIZE=32704                    
//SYSIN    DD DSN=DATASET.REO,DISP=SHR      
//SYSUT1   DD DSN=DATASET.SYSUT1,DISP=SHR            
//*                                                              
//SW01WK01 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW01WK01  
//SW01WK02 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW01WK02  
//SW01WK03 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW01WK03  
//SW01WK04 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW01WK04  
//SW01WK05 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW01WK05  
//SW01WK06 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW01WK06  
//SW01WK07 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW01WK07  
//SW01WK08 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW01WK08  
//SW01WK09 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW01WK09  
//SW01WK10 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW01WK10  
//SW01WK11 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW01WK11  
//SW01WK12 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW01WK12  
//SW01WK13 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW01WK13  
//SW01WK14 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW01WK14  
//SW01WK15 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW01WK15  
//SW01WK16 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW01WK16  
//SW01WK17 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW01WK17  
//SW01WK18 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW01WK18  
//SW01WK19 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW01WK19  
//SW01WK20 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW01WK20  
//SW01WK21 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW01WK21  
//SW01WK22 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW01WK22  
//SW01WK23 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW01WK23  
//SW01WK24 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW01WK24  
//SW01WK25 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW01WK25  
//SW02WK01 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW02WK01  
//SW02WK02 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW02WK02  
//SW02WK03 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW02WK03  
//SW02WK04 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),    
//         DISP=(,DELETE),DSN=DATASET.SW02WK04
//SW02WK05 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),    
//         DISP=(,DELETE),DSN=DATASET.SW02WK05
//SW02WK06 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),    
//         DISP=(,DELETE),DSN=DATASET.SW02WK06
//SW02WK07 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),    
//         DISP=(,DELETE),DSN=DATASET.SW02WK07
//SW02WK08 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),    
//         DISP=(,DELETE),DSN=DATASET.SW02WK08
//SW02WK09 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),    
//         DISP=(,DELETE),DSN=DATASET.SW02WK09
//SW02WK10 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),    
//         DISP=(,DELETE),DSN=DATASET.SW02WK10
//SW02WK11 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),    
//         DISP=(,DELETE),DSN=DATASET.SW02WK11
//SW02WK12 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),    
//         DISP=(,DELETE),DSN=DATASET.SW02WK12
//SW02WK13 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),    
//         DISP=(,DELETE),DSN=DATASET.SW02WK13  
//SW02WK14 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW02WK14  
//SW02WK15 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW02WK15  
//SW02WK16 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW02WK16  
//SW02WK17 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW02WK17  
//SW02WK18 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW02WK18  
//SW02WK19 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW02WK19  
//SW02WK20 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW02WK20  
//SW02WK21 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW02WK21  
//SW02WK22 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW02WK22  
//SW02WK23 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),    
//         DISP=(,DELETE),DSN=DATASET.SW02WK23
//SW02WK24 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),    
//         DISP=(,DELETE),DSN=DATASET.SW02WK24
//SW02WK25 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),    
//         DISP=(,DELETE),DSN=DATASET.SW02WK25
//SW03WK01 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),    
//         DISP=(,DELETE),DSN=DATASET.SW03WK01
//SW03WK02 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),    
//         DISP=(,DELETE),DSN=DATASET.SW03WK02
//SW03WK03 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),    
//         DISP=(,DELETE),DSN=DATASET.SW03WK03
//SW03WK04 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),    
//         DISP=(,DELETE),DSN=DATASET.SW03WK04
//SW03WK05 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),    
//         DISP=(,DELETE),DSN=DATASET.SW03WK05
//SW03WK06 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),    
//         DISP=(,DELETE),DSN=DATASET.SW03WK06
//SW03WK07 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),    
//         DISP=(,DELETE),DSN=DATASET.SW03WK07    
//SW03WK08 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),        
//         DISP=(,DELETE),DSN=DATASET.SW03WK08    
//SW03WK09 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),        
//         DISP=(,DELETE),DSN=DATASET.SW03WK09    
//SW03WK10 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),        
//         DISP=(,DELETE),DSN=DATASET.SW03WK10    
//SW03WK11 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),        
//         DISP=(,DELETE),DSN=DATASET.SW03WK11    
//SW03WK12 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),        
//         DISP=(,DELETE),DSN=DATASET.SW03WK12    
//SW03WK13 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),        
//         DISP=(,DELETE),DSN=DATASET.SW03WK13    
//SW03WK14 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),        
//         DISP=(,DELETE),DSN=DATASET.SW03WK14    
//SW03WK15 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),        
//         DISP=(,DELETE),DSN=DATASET.SW03WK15    
//SW03WK16 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),        
//         DISP=(,DELETE),DSN=DATASET.SW03WK16    
//SW03WK17 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW03WK17  
//SW03WK18 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW03WK18  
//SW03WK19 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW03WK19  
//SW03WK20 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW03WK20  
//SW03WK21 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW03WK21  
//SW03WK22 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW03WK22  
//SW03WK23 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW03WK23  
//SW03WK24 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW03WK24  
//SW03WK25 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      
//         DISP=(,DELETE),DSN=DATASET.SW03WK25  
//SW04WK01 DD STORCLAS=SCREOR,SPACE=(CYL,(500,1500)),      

 


Could you how much sortwork we need to perform the sort ?

Re: Sort Capacity exceeded in Reorg Step

PostPosted: Mon Dec 09, 2019 7:18 pm
by enrico-sorichetti
You were already told how to calculate the sortwk need here

dfsort-icetool-icegener/topic9173.html#p45086

Re: Sort Capacity exceeded in Reorg Step

PostPosted: Tue Dec 10, 2019 1:25 pm
by samb01
Thank you for the link.

Re: Sort Capacity exceeded in Reorg Step

PostPosted: Tue Dec 10, 2019 4:19 pm
by NicC
You have posted the JCL not the SYSIN. The SYSIN statements are contained in DATASET.REO
All times are UTC + 5:30 hours
Page 1 of 1
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/