What is the cause of sort error messages PFL4020E and PFL0008E executing a CA Fast Load load replace?

book

Article ID: 35687

calendar_today

Updated On:

Products

CA Database Analyzer for DB2 for z/OS CA Fast Unload for DB2 for z/OS CA Fast Check for DB2 for z/OS CA Fast Index for DB2 for z/OS CA Fast Load for DB2 for z/OS CA Rapid Reorg for DB2 for z/OS

Issue/Introduction

 Problem: 

Running a CA Fast Load for DB2 for z/OS (PFL) load replace may result in the following errors:

PFL4020E - SORT abended - Abend Code: X'010'                             
PFL0008E - SORT Processing cancelled - Check SORTMSGS for problem        
EMSPACE = 32768  RSRVTI  = 524288                                        
WER039A  INSUFFICIENT VIRTUAL STORAGE

Increasing REGION to 0M does not resolve the problem.     

 

Cause: 

Increasing the Syncsort parameter RSRVTI value from the default value of 44K to something higher such as 524288.   

 

 

Resolution:

These options instruct sort to reserve 32K below-the-line (EMSPACE) plus 512K below-the-line (RSRVTI). However the MAINSIZE value passed by the user program limits the sort to only 420K.  To correct the problem in PFL increase the SORT-APPLSIZE.

An example calculation to adjust the SORT-APPLSIZE is as follows: 
512-44 + 420 = 888K

Set SORT-APPLSIZE to 888K in UTIL member of highlvl.CDBAPARM.          

 

Environment

Release:
Component: PFL