Sort Capacity exceeded in Reorg Step



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

Sort Capacity exceeded in Reorg Step

Postby samb01 » Mon Dec 09, 2019 6:45 pm

Hello,

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


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 :


//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 ?
samb01
 
Posts: 427
Joined: Mon Nov 16, 2009 7:24 pm
Has thanked: 1 time
Been thanked: 0 time

Re: Sort Capacity exceeded in Reorg Step

Postby enrico-sorichetti » Mon Dec 09, 2019 7:18 pm

You were already told how to calculate the sortwk need here

dfsort-icetool-icegener/topic9173.html#p45086
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: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: Sort Capacity exceeded in Reorg Step

Postby samb01 » Tue Dec 10, 2019 1:25 pm

Thank you for the link.
samb01
 
Posts: 427
Joined: Mon Nov 16, 2009 7:24 pm
Has thanked: 1 time
Been thanked: 0 time

Re: Sort Capacity exceeded in Reorg Step

Postby NicC » Tue Dec 10, 2019 4:19 pm

You have posted the JCL not the SYSIN. The SYSIN statements are contained in DATASET.REO
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post