search cancel

S878 abend in sort executing Fast Unload with ORDER BY syntax.

book

Article ID: 214838

calendar_today

Updated On:

Products

Fast Unload for DB2 for z/OS

Issue/Introduction

Executing CA Fast Unload for Db2 for z/OS (PFU) and encountering the following messages
where the SELECT statement included ORDER BY syntax which invoked sort:

SYSTEM COMPLETION CODE=878  REASON CODE=00000010                  
    NO ACTIVE MODULE FOUND                                  
    NAME=UNKNOWN 

SYSTEM COMPLETION CODE=0C1  REASON CODE=00000001                  
   NO ACTIVE MODULE FOUND                                                                                                                  
   NAME=UNKNOWN    

PFU0271I - DFSORT               DETECTED AS THE SORT PROGRAM    

PFU0261I - TASK #01 -- MESSAGE DDNAME: PTIMSG01 -- MAX RC: S0C1  INCLUDES:  
                                              REASON CODE: 00000001         

ICE185A 0 AN S878  ABEND WAS ISSUED BY DFSORT, ANOTHER PROGRAM OR AN EXIT   

 

The S878-10 abend indicates:
There is not enough virtual private area storage available to satisfy    
the request. This is due to one of the following:                        
                                                                         
o A program is requesting virtual storage, but not subsequently freeing  
  the storage.                                                           
                                                                         
o The region size specified is too small.                                
                                                                         
o An installation exit is requesting virtual storage from a V=R region   
  before initialization of the region has completed.                     

Environment

Release : 20.0
Component : CA Fast Unload for DB2 for z/OS

Resolution

Per the following PFU messages it appears that Above-the-line storage is limited to 32Mb.

PUT0916I - Private storage information:                    
                            Maximum  Allocated  Free       
           Below-the-line:  8256 KB    1116 KB  7140 KB    
           Above-the-line:    32 MB    5960 KB    26 MB    
           Above-the-bar :    20 GB      12 MB    19 GB  

 

There was no REGION= specification on either the JOBCARD or STEP.  A REGION= 
was specified with an allowed allocation for the environment which corrected the S878 abend.