ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Fast Unload fails with WER046A Sort Capacity Exceeded


Article ID: 208005


Updated On:


Fast Unload for DB2 for z/OS


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.