S878 abend in sort executing Fast Unload with ORDER BY syntax.
Article ID: 214838
Updated On:
Products
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.
Feedback
