SDC2 abend in unload using Fast Unload

Products

• Fast Unload for DB2 for z/OS

Issue/Introduction

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

Cause

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.

Resolution

Specify DFSORT parameter NOMOWRK to circumvent the problem.

//DFSPARM  DD   *
OPTION NOMOWRK

Apply PTF LU02470 as a permanent solution.