Multiple index specification

For option descriptions for the OUTCOPY specification, which is included in the Multiple index specification, see:

OUTCOPY-specification
The syntax diagram for the Multiple index specification is in RECOVER-TABLESPACE-RECOVER-INDEX-and-RECOVER-INDEXSPACE-syntax.

Important

If INDEXLOG=NO is specified as an installation option or on the OPTIONS command, multiple index specifications are not valid on the same RECOVER statement with TABLESPACE. Without TABLESPACE, the parser understands that REBUILD is implied.

Example-5-Recovering-to-a-specific-log-point

Example-17-Using-timestamp-recovery

Option

Description

INDEX creatorID.indexName

The INDEX option specifies the index to be recovered as follows:

creatorID is the qualifier creator ID for the index. The default is the user identifier for the utility.
indexName is the name of the index. Indexes for BMCUTIL, BMCSYNC, and BMXCCOPY (tables that are used by BMC utilities) cannot be used.

OBJECTSET specification	Use the OBJECTSET specification with INDEX to recover only the indexes that are in a defined group. For more information, see OBJECTSET-specification and Using-BMC-AMI-Recovery-Manager-object-sets.

INDEX (ALL) TABLESPACE databaseName.tableSpaceName

(ALL) TABLESPACE specifies that all indexes for the named table space are to be recovered. The parentheses around ALL are optional.

TABLESPACE specifies the table space from which all indexes are to be recovered as follows:

databaseName is the name of the database containing the table space. The default is DSNDB04. The name cannot be DSNDB01, DSNDB06, DSNDB07, or any database defined with TYPE='W' in SYSIBM.SYSDATABASE.
tableSpaceName is the name of the table space within the named database. BMCUTIL, BMCSYNC, and BMCXCOPY (tables that are used by BMC utilities) cannot be used.

AUX	The AUX option specifies if auxiliary objects will be included with the recovery of the base table spaces. For more information, see AUX.

INDEXSPACE databaseName.indexSpaceName

The INDEXSPACE option specifies indexes to be recovered as follows:

databaseName is the name of the database containing the index space. The default is DSNDB04. The name cannot be DSNDB01, DSNDB06, DSNDB07, or any database defined with TYPE= 'W' in SYSIBM.SYSDATABASE.
indexSpaceName is the name of the index space within the named database. Indexes for BMCUTIL, BMCSYNC, and BMCXCOPY (tables that are used by BMC utilities) cannot be used.

INDEXSPACE (ALL) TABLESPACE databaseName.tableSpaceName

(ALL) TABLESPACE specifies that all indexes for the named table space are to be recovered. The parentheses around ALL are optional.

TABLESPACE specifies the table space from which all indexes are to be recovered as follows:

databaseName is the name of the database to which the table space belongs. The name cannot be DSNDB01, DSNDB06, DSNDB07, or any database defined with TYPE='W' in SYSIBM.SYSDATABASE. The default is DSNDB04.
tableSpaceName is the name of the table space whose indexes are to be recovered. BMCUTIL, BMCSYNC, and BMCXCOPY (tables that are used by BMC utilities) cannot be used.

If you do not specify the TABLESPACE option, BMC AMI Recover determines the table space for the first valid index specified. All other specified indexes must belong to the same table space.

NOWORKDDN

The NOWORKDDN option causes the keys to be sent directly to the sort routine without first writing these keys to a work data set. With RECOVER INDEX, NOWORKDDN is only valid when you have also specified INDEXLOG AUTO.

Multiple index specification

On this page