Fast Load load fails in sort WER153A INSUFFICIENT VIRTUAL STORAGE along with PFL4020E
search cancel

Fast Load load fails in sort WER153A INSUFFICIENT VIRTUAL STORAGE along with PFL4020E

book

Article ID: 141573

calendar_today

Updated On:

Products

Fast Load for DB2 for z/OS

Issue/Introduction

Loading over one billion rows Fast Load for Db2 for z/OS (PFL) may fail with:

PFL4020E - SORT abended - Abend Code: X'010'                         
           See sort messages for more details.                       
                                                                     
PFL0008E - SORT Processing cancelled - Check SORTMSGS for problem    
PFL0207E - Index_SP Task ECB: X'00000010'   Return Code: X'00000004' 

WER153A  INSUFFICIENT VIRTUAL STORAGE IN FINAL MERGE PHASE

Cause

$ORTPARM parameter VSCORET=100M too small.

Resolution

Increase the $ORTPARM VSCORET value to:
ELAP,GMSG,BMSG,VSCORET=250M