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:
Products
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.
Feedback
Yes
No
Powered by
