The MUF must be active when you execute this command. Use the following command format:
►►─ SPILLOPT ─ SPILL= ─┬─ MAX ─┬─┬───────────────────┬────────────────────────►◄ └─ MIN ─┘ └─ ,HISTORY=choice ─┘
Command
Invokes the function to transfer data from the Log Area (LXX) to the Recovery File (RXX).
Required Keywords
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.
MAX or MIN
(No default)
Optional Keyword
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.
NO, YES-FAIL, YES-RC0, YES-RC4
NO
|
Copyright © 2014 CA.
All rights reserved.
|
|