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=NO


This option specifies what behavior RECOVER INDEX has. Valid values are NO, YES, and AUTO.

  • INDEXLOG=NO, the default, indicates that RECOVER INDEX and REBUILD INDEX are synonyms and indexes are rebuilt from the keys extracted from the table space.
  • INDEXLOG=YES indicates that RECOVER INDEX recovers indexes from copies, the log, or both, while REBUILD INDEX rebuilds indexes from the keys extracted from the table space.
  • INDEXLOG=AUTO indicates that RECOVER INDEX first attempts an index recovery from image copies, the log, or both. However, if an image copy for the index does not exist, BMC AMI Recover converts the request to a REBUILD INDEX request.

    INDEXLOG=AUTO supports BACKOUT recoveries. However, conversion from RECOVER INDEX to REBUILD INDEX is not supported for following options:

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

Important

If you plan to make index image copies, you might consider using INDEXLOG=YES or INDEXLOG=AUTO, but realize that you may have to change some RECOVER INDEX command statements to REBUILD INDEX. However, if you have no immediate plans to start making index image copies, you may prefer to leave the default, INDEXLOG=NO, so that you will not have to change syntax.

You can override the INDEXLOG installation option by using the INDEXLOG keyword with the OPTIONS command (see INDEXLOG).

Important

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


 

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