Fast Unload fails with WER046A Sort Capacity Exceeded

Products

• CA Fast Unload for DB2 for z/OS

Issue/Introduction

Running Fast Unload with an Order By, the job fails with: WER046A  SORT CAPACITY EXCEEDED
How to solve this Sort Failure?

 

 

Environment

Release : 20.0

Component : CA Fast Unload for DB2 for z/OS

Resolution

The best solution is to add Estimated-Rows xxx to your Fast unload Syntax in order to pass your Sort PGM the necessary sort capacity: 

For details see section: 'ESTIMATED-ROWS—Estimate the Number of Rows to Unload' in the CA FAST UNLOAD® FOR DB2 FOR Z/OS 20 documentation.