search cancel

PRF0515E Spill file access error. Exhausted all memory and Spill file allocs.

book

Article ID: 201673

calendar_today

Updated On:

Products

Report Facility Compile/PRF for CICS Compile/PRF for TSO Compile/PRF Plus Report Facility for CICS Report Facility for IMS Report Facility for TSO

Issue/Introduction

Batch jobs failing with "PRF0515E  Spill file access error. Exhausted all memory and Spill file allocs."

                                                                                                                
PRF0521E  Cluster for Spill file could not be defined.      

Is there a way to stop Spill files being created?                                                   
                                                  
                                                                           
            

 

 

 

Environment

Release : 20.0

Component : CA Report Facility for DB2 for z/OS

Resolution

There is no way to stop the creation of a Spill file when
the main memory is exhausted, and the report is too
large for the main memory alone.


There are some options for customizing the product settings to avoid the creation of a spill file. 


Resource Control
Using user profiles, it is possible to define various resource controls by user, group, and environment.

Control:
Maximum number of rows returned by a query
Maximum amount of memory that can be used
Maximum size of the spill file that can be used when CA Report Facility
uses all the specified report memory