Fast Load fails with ICE046A 5 SORT CAPACITY EXCEEDED PFL4019E - SORT failed

Products

• Fast Load for DB2 for z/OS

Issue/Introduction

Running Fast Load with 200 million rows 12 indexes and RECLUSTER NO SORT-CLINDX. The job fails with: 
ICE046A 5 SORT CAPACITY EXCEEDED - RECORD COUNT 1078341108           
ICE253I 0 RECORDS SORTED - PROCESSED: 1078341108, EXPECTED: 999999999
FILSZ=E999999999,NOMOWRK,NOEQUALS
PFL4019E - SORT failed - Return Code: 016                           
           See sort messages / PTIMSG for details on error          
           causing early termination of sort processing.            
                                                                    
PFL0008E - SORT Processing cancelled - Check SORTMSGS for problem   
PFL0207E - Index_SP Task ECB: X'00000010'   Return Code: X'00000004'
                                                                    
PFL0212E - Data sets did not load successfully                      

Environment

Release : 20.0

Component : CA Fast Load for DB2 for z/OS

Resolution

Due to the number of indexes (12) with MAXTASKS 2 each sort task will sort approximately 1078341108 records and FILSZ=E999999999 is being passed to each sort due to the UTIL member SORT-FILSZMAX (009) value. 

One recommendation would be to increase the UTIL member SORT-FILSZMAX value
which would benefit all Fast Load jobs executing in the environment:
Change SORT-FILSZMAX (009) to SORT-FILSZMAX (010) (in essence adding a digit to FILSZ) 

For this specific load of table DBA1.TVAS_ACCT_RNG, modifying MAXTASKS 2
to MAXTASKS 4 would start additional sort tasks to distribute the indexes
across additional sort tasks to avoid the FILSZ=E999999999 limit.