Fast Unload SB78-14 abend PFU0186E UNSUCCESSFUL SORT B78 REASON=00004B28

Products

• Fast Unload for DB2 for z/OS

Issue/Introduction

Executing Fast Unload for Db2 for z/OS (PFU) and encountered the following SB78 abend:

SYSTEM COMPLETION CODE=B78  REASON CODE=00004B28                       
 PSW AT TIME OF ERROR  070C1000   8135522C  ILC 2  INTC 0D             
   NO ACTIVE MODULE FOUND                                              
   NAME=UNKNOWN                                                        
   DATA AT PSW  01355226 - 00181610  0A0DE3E0  D0080024                
                  

PFU0186E - ERRORS UNLOADING.  ORDER CLAUSE USED.        
           CHECK ST01MSG/PTIMSG FOR CAUSES.   RC: SB78

Resolution

The following PFU maintenance is recommended to correct this SB78 abend:

LU02005 - ZIIP FOR SQL-ACCESS, MULTIPLE SELECTS, LITERALS, DECFLOAT


LU02006 - ZIIP FOR SQL-ACCESS, MULTIPLE SELECTS, LITERALS, DECFLOAT 


LU02007 - ZIIP FOR SQL-ACCESS, MULTIPLE SELECTS, LITERALS, DECFLOAT

 

Specifying ZIIP NO within the PFU syntax will circumvent the problem.  In addition, a reorganization was completed
on the tablespace and following the reorganization the PFU execution with ZIIP YES processing was successful.