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                
   AR/GR 0: 00AACD90/07850000_84000000   1: 00000000/00000000_84B78000 
         2: 00000000/00000000_24F4C5A0   3: 00000000/00000000_04000072 
         4: 00000000/00000000_00163CD8   5: 00000000/00000000_24F5D00C 
         6: 00000000/00000000_89482328   7: 00000000/00000000_24F756D2 
         8: 00000000/00000000_24C3E000   9: 00000000/00000000_01F3E0C0 
         A: 00000000/00000000_01F3E0C0   B: 00000000/00000000_09481088 
         C: 00000000/00000000_8014E000   D: 00000000/00000000_24C3E018 
         E: 00000000/00000000_0014E126   F: 00000000/00000000_00004B28 
 END OF SYMPTOM DUMP                                                   

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

Environment

Release : 20.0
Component : Fast Unload for DB2 for z/OS
Sort: SYNCSORT FOR Z/OS  3.1.4.0RI

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.