Fast Unload for Db2 for z/OS (PFU) execution fails with a SDC2 abend and error message PFU0186E:
SYSTEM COMPLETION CODE=DC2 REASON CODE=4A003820
PFU0186E - ERRORS UNLOADING. ORDER CLAUSE USED.
CHECK ST01MSG/PTIMSG FOR CAUSES. RC: SDC2
ICE185A 0 AN SDC2 ABEND WAS ISSUED BY DFSORT, ANOTHER PROGRAM OR AN EXIT
This failure occurs when the following conditions are true:
- Native access is used (SQL-ACCESS NONE or EXTENSION).
- ORDER BY is used.
- DFSORT's MOWRK option is used (either through the installation default
or the parameters DD).
Note the ORDER BY condition also includes the ORDER CLUSTERED clause.
Specify DFSORT parameter NOMOWRK to circumvent the problem.
//DFSPARM DD *
OPTION NOMOWRK
Apply PTF LU02470 as a permanent solution.