PFL Load fails in sort WER153A INSUFFICIENT VIRTUAL STORAGE, PFL4020E

book

Article ID: 141573

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 CA Database Management for DB2 for z/OS - Utilities Suite

Issue/Introduction

Loading over one billion rows Fast Load 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 Parm VSCORET=100M too small.

Environment

Release : 20.0

Component : CA Fast Load for DB2 for z/OS

Resolution

Increase the $ORT Parm to

$ORTPARM : ELAP,GMSG,BMSG,VSCORET=250M