Using the SIXSNAP option
The SIXSNAP option determines whether REORG PLUS uses the Instant Snapshot technology of
XBM
and
SUF
to create a copy of storage-group-defined nonpartitioned indexes.
To use Instant Snapshot, you must have a supported intelligent storage device. For a list of supported devices, see the EXTENDED BUFFER MANAGER for DB2 documentation.
The following table shows how the value of the SIXSNAP command or installation option determines the action that REORG PLUS takes if a copy failure occurs.
SIXSNAP value | Instant Snapshot fails for | REORG PLUS action |
|---|---|---|
AUTO | One or more nonpartitioned indexes | Makes a software-based copy of each index that failed |
One or more components of a multi-data-set object | Makes a software-based copy of every component of that multi-data-set index | |
YES | Any index | Terminates |
We recommend that you specify AUTO instead of YES, especially if your hardware vendor is STK. For more information, see Hardware vendor considerations.
For information about the XBM and SUF requirements, see XBM-and-SUF-considerations.
To use Instant Snapshot technology to copy nonpartitioned indexes
- Ensure that you have a currently supported version of XBM or SUF as described in System-requirements.
- Ensure that you have a supported intelligent storage device (as documented in the EXTENDED BUFFER MANAGER for DB2 documentation).
- Specify AUTO or YES on the SIXSNAP command or installation option.
- Specify YES on the REDEFINE command or installation option.If the value for REDEFINE is NO, REORG PLUS operates as follows:
- If SIXSNAP is AUTO, REORG PLUS changes SIXSNAP to NO and produces a software-based copy.
- If SIXSNAP is YES, REORG PLUS terminates.
- (optional) Use the XBMID installation or command option to specify the XBM subsystem that you want REORG PLUS to use for snapshot processing.
- Review the information in the rest of this section for any additional actions to take.
Related topic