OPTIONS--Specify Global Processing Options

The OPTIONS control statement specifies processing options for multiple statements in your job.
The OPTIONS control statement specifies processing options for multiple statements in your job. You can specify the options once, before your RECOVER and REBUILD statements, instead of having to specify them in every statement.
  • To override the OPTIONS values for a given RECOVER or REBUILD statement, specify the options again within that statement.
  • OPTIONS is an IBM control statement. For information about the IBM syntax, see the IBM Db2 utilities documentation. This topic shows the
    Fast Recover
    syntax that can be used with the OPTIONS statement.
This control statement has the following format:
OPTIONS [PREVIEW [YES|NO|SIMULATE]][KEEP-SIMULATION-SHADOWS {YES|NO}] [LISTDEFDD {
ddname
}][TEMPLATEDD {
ddname
}][OFF]
  • PREVIEW
    Specifies whether to preview or simulate the recovery job. If you specify this keyword without a value, YES is used. For more information about this keyword, see PREVIEW.
  • KEEP-SIMULATION-SHADOWS
    Specifies whether to keep the VSAM shadow data sets that are created for PREVIEW SIMULATE processing. For more information about this keyword, see KEEP-SIMULATION-SHADOWS.
  • LISTDEFDD
    Specifies the ddname of the LISTDEF library to use. For more information about how
    Fast Recover
    uses LISTDEFs, see LIST.
  • TEMPLATEDD
    Specifies the ddname of the TEMPLATE library to use. For more information about how
    Fast Recover
    uses TEMPLATEs, see QUICKCOPY.
  • OFF
    Does not apply any processing options to the job statements.
Example: Use the OPTIONS Statement
A Database Administrator (DBA) wants to run the following recovery scenario in simulation mode:
//SYSIN DD* RECOVER TABLESPACE ALPHA.BETA RECOVER TABLESPACE GAMMA.DELTA REBUILD INDEX(ALL) TABLESPACE ALPHA.BETA REBUILD INDEX(ALL) TABLESPACE GAMMA.DELTA
The DBA wants to use the same PREVIEW and KEEP-SIMULATION-SHADOWS values for all four statements. Instead of inserting those keywords after each RECOVER and REBUILD statement, the DBA uses the OPTIONS statement to specify the keywords once, at the beginning of the job:
//SYSIN DD* OPTIONS PREVIEW SIMULATE KEEP-SIMULATION-SHADOWS YES RECOVER TABLESPACE ALPHA.BETA RECOVER TABLESPACE GAMMA.DELTA REBUILD INDEX(ALL) TABLESPACE ALPHA.BETA REBUILD INDEX(ALL) TABLESPACE GAMMA.DELTA
When the job is submitted, the OPTIONS settings are applied to all four statements.