Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Recover for Db2 13.1.

INDEXLOG

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 may 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 may prefer INDEXLOG NO so that you will not have to change syntax.

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.

Important

In this space, references to REBUILD INDEX may 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.

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

 

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