Fast Unload fails with WER046A Sort Capacity Exceeded error

Products

• Fast Unload for DB2 for z/OS

Issue/Introduction

Executing Fast Unload for Db2 for z/OS (PFU) with an ORDER BY clause and the job fails with:
WER046A  SORT CAPACITY EXCEEDED

How to solve this sort capacity failure?

Resolution

The best solution is to add ESTIMATED-ROWS nnnnnn to the Fast Unload Syntax in order to pass your sort program the necessary sort capacity: 

For details see section: ESTIMATED-ROWS—Estimate the Number of Rows to Unload in the PFU documentation.