SPILLOPT (Transfer Data to RXX Using MAX/MIN)

The SPILLOPT SPILL= function allows you to specify MAX or MIN when requesting a spill.
datacom
The SPILLOPT SPILL= function allows you to specify MAX or MIN when requesting a spill.
Dual Recovery File (RXX) support is available for sites that use inactive recovery. See Recovery File (RXX) Report.
Update SPILL History Table
The DBUTLTY SPILLOPT function can be used to update the SPILL history table by specifying the keyword HISTORY=.
How to Use SPILLOPT
The MUF must be active when you execute this command. Use the following command format:
►►─ SPILLOPT ─ SPILL= ─┬─ MAX ─┬─┬───────────────────┬─┬─────────────────────┬──►◄ └─ MIN ─┘ └─ ,HISTORY=
choice
─┘ └─ ,OPTION2=FORCERXX ─┘
 
Command
 
  •  
    SPILLOPT
    Invokes the function to transfer data from the Log Area (LXX) to the Recovery File (RXX).
 
Required Keywords
 
  •  
    SPILL=
    The SPILLOPT SPILL= function allows you to specify MAX or MIN when requesting a spill.
    Specifying SPILLOPT SPILL=MIN indicates that you want the spill to contain all that is spillable, 
    not including
     the blocks controlling the pipelined index/data blocks. If performing a spill 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, use SPILL=MAX in case the job recently finished.
    •  
      Valid Entries:
      MAX or MIN
    •  
      Default Value:
      (No default)
 
Optional Keyword
 
  •  
    ,HISTORY=
    choice
     
    Specify any of the following choices:
    • NO or allow it to default to NO to indicate that you do not want to select a SPILL history table with SPILLOPT. Or, that you do not want the history information in a SPILL history table to be updated.
    • YES-FAIL, YES-RC0, or YES-RC4 for HISTORY= indicates what action you want taken if a problem is encountered in handling the history.
    • HISTORY=YES-FAIL indicates that you are requesting the history record. Additionally, you want the spill and the DBUTLTY function in error to be terminated immediately if any of the commands fail.
    If you specify HISTORY=YES-RC0, it indicates that you are requesting the history record but, if it cannot be done, to issue a message and complete the spill without ending the DBUTLTY function in error. You would then have to correct the problem for future executions and execute RXXFIX to build or update the appropriate history spill record.
    •  
      Valid Entries:
      NO, YES-FAIL, YES-RC0, YES-RC4
      Default Value:
      NO
  •  
    ,OPTION2=FORCERXX 
    This keyword indicates that you want an empty RXX data set written even if there are no records in the LXX that are subject to a SPILL. The RXX data set is built as an empty data set and if SPILL history is enabled, there is no SPILL history record created. The DBUTLTY RECOVERY functions can read the new empty RXX data set without error. The following console message is received:
    DB13083I - LOG AREA EMPTY, SPILL IS NOT NECESSARY
    •  
      Valid Entries:
      ,OPTION2=FORCERXX  
       
       
    •  
      Default Value:  
       
      Not specified. No empty RXX data set is created.
Example JCL (SPILLOPT)
The following shows the command to transfer data from the Log Area to the Recovery File using SPILLOPT SPILL=MIN.
 Use the following as a guide to prepare your JCL. The JCL statements are for example only. Lowercase letters in a statement indicate a value you must supply. Code all statements to your site and installation standards.
//jobname
See the previous note
.
// EXEC PGM=DBUTLTY,REGION=2M //STEPLIB
See the previous note
.
//RXX DD DSN=rxx.data.set,DISP=SHR, Recovery data set // UNIT=tape (output) //SYSIN DD * Command Input SPILLOPT SPILL=MIN /*
Sample Report
Following is a sample report page. For an example report header, see Sample Report Headers.
CONTROL CARD(S) .........1.........2.........3.........4.........5.........6.........7.........8 SPILLOPT SPILL=MIN FUNCTION=SPILLOPT SPILL=MIN
This page of the report shows the following:
  • The command exactly as entered.
  • An analysis of keywords encountered and expected. Any errors found are flagged with a note in the left margin.
  • Any messages related to syntax processing.
DB13085I - LOG AREA SPILL IS COMPLETE DB00310I - LOG SPILL 399-1, BLOCKS 31-61, TIMES ccyy/mm/dd hh.mm.ss-ccyy/mm/dd hh.mm.ss DB00404I - RXX LAST RECORD DATE/TIME - ccyy/mm/dd/ hh.mm.ss
This page of the report displays messages about the success of the spill. For more information, see Messages.