Running Fast Unload with an Order By, the job fails with: WER046A SORT CAPACITY EXCEEDED
How to solve this Sort Failure?
Release : 20.0
Component : CA Fast Unload for DB2 for z/OS
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.