Skip to Content

RECOVER BUILDINDEX command

Related topics

Testing recovery with simulation

The RECOVER BUILDINDEX command specifies the rebuilding of one or more nonpartitioned indexes on a partitioned table space by using data sets that are created in earlier RECOVER UNLOADKEYS runs. You can include only one RECOVER BUILDINDEX command statement in the BMC AMI Recover execution; no other BMC AMI Recover command statements are allowed.

Warning

Important

If you request simulation mode with the SIMULATE YES option, which requires a valid Recovery Management for Db2 solution password, you must use SIMRCVR BUILDINDEX rather than RECOVER BUILDINDEX.

This section describes the syntax of the RECOVER BUILDINDEX command and its options.

Warning

Important

RECOVER BUILDINDEX ignores the MAXKSORT option and processes as if you specified MAXKSORT=1.

RECOVER BUILDINDEX syntax

The following figure shows the syntax of the RECOVER BUILDINDEX command.

GUID-081ED0C4-3BEC-4DC6-AD12-B8BBDF105C8C-low.png

RECOVER BUILDINDEX option descriptions

BMC AMI Recoverprovides the following options for use with the RECOVER BUILDINDEX command. The options are described in the order in which they are shown in the RECOVER BUILDINDEX syntax diagram.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Recover for Db2 13.1