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

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