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.

AUX=NO

Use the AUX installation option to specify if the auxiliary objects related to a base table space are to be included in recovery.

Valid values are NO, ALL, YES, XML, LOB, HISTORY, and ARCHIVE. The default value is NO.

These values have the following meanings:

  • AUX=NO does not include any auxiliary objects in the recovery.
  • AUX=ALL includes XML and LOB objects in the recovery. It does not include HISTORY spaces with their related auxiliary objects when a table space with system-maintained temporal tables is specified in SYSIN.
  • AUX=YES includes both LOB and XML objects in the recovery, as well as history spaces when a table space with system-maintained temporal tables is specified in SYSIN.
  • AUX=XML includes all XML data objects along with the XML base table space. If the table space specification is found on a RECOVER TABLESPACE or SIMULATE TABLESPACE statement, all implicitly created XML table spaces will be processed along with the base XML table space. If the table space specification is found on a RECOVER INDEX(ALL), REBUILD INDEX(ALL), or SIMULATE INDEX(ALL) statement, all implicitly created XML and node ID indexes on the XML base table space as well as all explicitly created non-LOB indexes will be processed.
  • AUX=LOB includes all LOB data objects along with the LOB base table space. If the table space specification is found on a RECOVER TABLESPACE or SIMULATE TABLESPACE statement, all table spaces created with the LOB attribute will be processed along with the base LOB table space. If the table space specification is found on a RECOVER INDEX(ALL), REBUILD INDEX(ALL) or SIMULATE INDEX(ALL) statement, all indexes on the LOB base table space and all non-LOB explicitly created indexes will be processed.
  • AUX=HISTORY includes history spaces when a table space with system-maintained temporal tables is specified in SYSIN. Similar to IBM Db2 RECOVER VERIFYSET NO behavior, BMC AMI Recover does not check for the following:
    • That the system-maintained temporal space and the history space are recovered as a set
    • That the recovery of the system-maintained temporal space and the history space is to the same log point
    • That all DSNUMs are recovered in the same SYSIN
  • AUX=ARCHIVE tells BMC AMI Recover whether to recover archive tables if you have specified table spaces with archive-enabled base tables in SYSIN. This option does not include related XML or LOB objects.

You can override the value of the AUX installation option at runtime by using the AUX option on the OPTIONS command (AUX) or in the table space specification for any of the following BMC AMI Recover statements:

  • RECOVER TABLESPACE
  • RECOVER INDEX(ALL) TABLESPACE
  • RECOVER INDEXSPACE(ALL) TABLESPACE
  • REBUILD INDEX(ALL) TABLESPACE
  • LOGSCAN TABLESPACE
  • LOGSCAN INDEX(ALL) TABLESPACE
  • LOGSCAN INDEXSPACE(ALL) TABLESPACE

Important

BMC AMI Recover ignores the AUX option when you specify OBJECTSET.

Also, the AUX option has no effect for the ACCUM TABLESPACE, RECOVER UNLOADKEYS, and RECOVER BUILDINDEX commands.

When you specify AUX=YES, AUX=ALL, AUX=XML, AUX=LOB, AUX=HISTORY, or AUX=ARCHIVE, you cannot specify the following options:

You can specify the following options with AUX only if using AUX=NO:

  • TOCOPY dataSetName
  • OBIDXLAT without defaults
  • OUTCOPYDSN
  • RECOVERYDSN

Related topics

Descriptions-of-installation-options

Quick-reference-of-BMC-AMI-Recover-installation-options

TABLESPACE-specification-option



 

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