Skip to Content

INDEXLOG

Related topics

OPTIONS option descriptions

Examples of BMC AMI Recover jobs

INDEXLOG NO

DD statements for REBUILD INDEX jobs

RECOVER TABLESPACE, RECOVER INDEX, and RECOVER INDEXSPACE commands

The INDEXLOG option setting determines the behavior of the RECOVER INDEX command. If it is not specified on the OPTIONS command statement, the setting of INDEXLOG in the installation options is used.

You might consider using INDEXLOG YES, even though you might have to change some RECOVER INDEX commands to REBUILD INDEX commands. However, if you have no immediate plans to start making index image copies, you might prefer INDEXLOG NO so that you will not have to change syntax.

Warning

Important

The RECOVER INDEXSPACE command always invokes a recovery that is based on copies and logs, regardless of the INDEXLOG setting. REBUILD INDEX always rebuilds indexes, regardless of the INDEXLOG setting.

Value

Description

INDEXLOG YES

INDEXLOG YES causes the RECOVER INDEX command to use copies, log, or both for index recovery.

INDEXLOG NO

INDEXLOG NO causes the RECOVER INDEX command to rebuild the index by extracting the keys from the table space. When you specify INDEXLOG NO, the RECOVER INDEX and the REBUILD INDEX commands are synonyms.

Warning

Important

In this space, references to REBUILD INDEX might be replaced with RECOVER INDEX if INDEXLOG NO is specified.

INDEXLOG AUTO

INDEXLOG AUTO causes the RECOVER INDEX command to recover the index from image copies and log if possible. However, if BMC AMI Recover determines that it cannot recover the index (for example, because of missing image copy or a point-in-time recovery), the RECOVER INDEX request automatically converts to a REBUILD INDEX request. INDEXLOG AUTO supports BACKOUT recoveries.

Conversion from RECOVER INDEX to REBUILD INDEX is not supported for the following options:

  • OUTCOPY: The OUTCOPY option is not supported for REBUILD INDEX so this request is not eligible for conversion.
  • OBIDXLAT: The OBIDXLAT option is not supported for REBUILD INDEX so this request is not eligible for conversion.
  • TOLOGPOINT: If the TOLOGPOINT option is included in the RECOVER INDEX request, the request is only eligible for conversion to REBUILD INDEX if the associated table space is also recovered to the same log point in the same job step.
  • TOCOPY: If the TOCOPY option was included in the RECOVER INDEX request, the request is only eligible for conversion to REBUILD INDEX if the associated table space is also recovered in the same job step.
  • DSNUM: If the RECOVER INDEX command was for a specific data set of a nonpartitioned index, the request is not eligible for conversion to REBUILD INDEX.

 

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

BMC AMI Recover for Db2 13.1