SPILLOPT (Transfer Data to RXX Using MAX/MIN) › How to Use

How to Use

The MUF must be active when you execute this command. Use the following command format:

►►─ SPILLOPT ─ SPILL= ─┬─ MAX ─┬─┬───────────────────┬────────────────────────►◄
                       └─ MIN ─┘ └─ ,HISTORY=choice ─┘

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, you should use SPILL=MAX in case the job recently finished.

Valid Entries:

MAX or MIN

Default Value:

(No default)

Optional Keyword

,HISTORY=choice

Specify NO for the HISTORY= keyword (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.

In addition to requesting the history, specifying YES-FAIL, YES-RC0, or YES-RC4 for HISTORY= indicates what action you want taken if a problem is encountered in handling the history.

If you specify HISTORY=YES-FAIL, it indicates that you are requesting the history record and, if any of the commands fail, that you want the spill and the DBUTLTY function in error to be terminated immediately.

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

Indicates that you want an empty RXX dataset written even if there are no records in the LXX that are subject to a SPILL. The RXX dataset is built as an empty dataset and if SPILL history is enabled, there is no SPILL history record created. The DBUTLTY RECOVERY functions can read the new empty RXX dataset without error. The following console message is received:

DB 13083I - LOG AREA EMPTY, SPILL IS NOT NECESSARY.

Valid Entries:

,OPTION2=FORCERXX

Default Value:

Not specified. No empty RXX dataset is created.