PREVIEW—Preview Messages without Performing the Recovery

The PREVIEW keyword previews all messages from your job without actually performing the recovery.
The PREVIEW keyword previews all messages from your job without actually performing the recovery. You can learn the following information about the recovery:
  • What image copies are required (so you can locate the tapes to have ready for mounting, if necessary).
  • What log ranges are applied (so you can modify the RECOVER syntax, using FROMRBA or TORBA, if necessary).
  • How many sort work data sets are required.
  • The estimated sizes of the sort work data sets.
The PREVIEW keyword can also simulate the recovery process to validate that a recovery is possible.
If the RECOVER TABLESPACE statement and the REBUILD INDEX statement specify different PREVIEW values, the indexes are not rebuilt concurrently with the tablespaces. Each statement is processed independently.
If your simulation job contains multiple RECOVER and REBUILD statements with the same PREVIEW and KEEP-SIMULATION-SHADOWS values, you can specify these keywords once in an OPTIONS statement at the beginning of the job. For more information, see OPTIONS.
This keyword has the following format:
PREVIEW {YES|
NO
|SIMULATE}
  • YES
    Provides a preview of the messages that would result from the recovery. The tablespace is not stopped. No recovery is performed.
  • NO
    Performs the recovery without providing a preview. This value is the default.
  • SIMULATE
    Simulates the recovery process to validate that the recovery is possible. As part of the simulation, the objects are recovered to a shadow data set. This data set is deleted afterwards unless KEEP-SIMULATION-SHADOWS is specified. The database objects remain untouched. For more information about recovery simulation, see Simulate an Object Recovery.
    The following objects are incompatible with PREVIEW SIMULATE:
    • LOB tablespaces
    • XML tablespaces
    • Hash tablespaces
    • PBR2 table spaces
    • Temporary tablespaces and indexspaces
    • Indexes with key columns
    Certain keywords and parmlib options use only the default value, or they are mutually exclusive with PREVIEW SIMULATE. If a keyword is not in the following list, it operates normally:
    • Keywords that use default values:
      • EDITPROC
      • HISTORY
      • IDCAMS-CATALOG
      • INLINE-COPY
      • NO-SYSCOPY-ROW
      • QUICKCOPY
      • SORTDEVT
      • SORTFLAG
      • SORTNUM
      • SORTSIZE
      • SPACE-DEFN
      • STARTUP-ACCESS
      • STOP-LIMIT
    • Parmlib options that use default values:
      • BYPASS-REMOVE
    • Keywords that are mutually exclusive:
      • ALTERNATE
      • BACKOUT
      • ENDLOGPOINT
      • ENDRBA
      • FROMLOGLABEL
      • FROMLOGPOINT
      • FROMRBA
      • FULLDD
      • FULLDSN
      • LOGONLY
      • NO-NEW-COPY
      • OBIDXLAT
      • PQCPARM
      • (Db2 V12) RECOVER INDEX
      • SKIP-PENDING
      • STARTLOGPOINT
      • STARTRBA
      • RENAME-CONTROL
      • REPAIR-DBD
      • ROWFORMAT
      • STATS-OPTIONS
      • UPDATE-CATSTATS
    • Parmlib options that are mutually exclusive:
      • OBIDXLAT-COMP-EP
      • OBIDXLAT-EDITPROC
      • UPDIXQTY
      • UPDTSQTY