What is the difference between SPILL=MIN or SPILL=MAX for SPILLOPT

Products

• Datacom
• DATACOM - AD
• CIS
• COMMON SERVICES FOR Z/OS
• 90S SERVICES
• DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS
• COMMON PRODUCT SERVICES COMPONENT
• Common Services
• CA ECOMETER SERVER COMPONENT FOC
• Easytrieve Report Generator for Common Services
• INFOCAI MAINTENANCE
• IPC
• UNICENTER JCLCHECK COMMON COMPONENT
• Mainframe VM Product Manager
• CHORUS SOFTWARE MANAGER
• CA ON DEMAND PORTAL
• CA Service Desk Manager - Unified Self Service
• PAM CLIENT FOR LINUX ON MAINFRAME
• MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME
• GRAPHICAL MANAGEMENT INTERFACE
• WEB ADMINISTRATOR FOR TOP SECRET
• Xpertware

Issue/Introduction

Introduction:

I have seen that there are two options possible when using DBUTLTY function SPILLOPT. 

Question:

What is the difference between SPILL=MIN or SPILL=MAX for the DBUTLTY SPILLOPT function?

Environment:

Z/os, CA Datacom/AD 14.0 

Answer:

Specifying SPILLOPT SPILL=MIN indicates that you want all that is spillable, not including the blocks controlling the pipelined index/data blocks. If performing in the normal course of events, it is more efficient to use SPILL=MIN.  

Specifying SPILLOPT SPILL=MAX indicates that you want the spill to contain the maximum number of blocks including pipeline index/data blocks. If performing a spill specifically to recover a job executed improperly, you should use SPILL=MAXin case the job recently finished.

Additional Information: 

In other words:

If the goal of the SPILL is to get a recovery file (RXX) to use for backward recovery, then the 'MAX' is desired.

If the goal of the spill is just to reclaim space for the LXX typically done when the LXX is getting full, then the 'MIN' option would be desired. 

 

Note: The 'old' SPILL option works the same as the SPILLOPT=MAX. 

 

Environment

Release:
Component: AD