AUX=NO

This option specifies whether to include the auxiliary objects related to a base table space in the recovery.

Valid values are as follows:

  • NO—(Default) Does not does not include any auxiliary objects in the recovery.
  • 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.
  • YES—Includes both both LOB and XML objects in the recovery (in addition to history spaces) when a table space with system-maintained temporal tables is specified in SYSIN.

Related topics

BMC-AMI-Recover-installation-options

TABLESPACE-specification-option

  • XML—Includes all XML data objects 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 are processed 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, in addition to all explicitly created non-LOB indexes are processed.
  • 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 are processed 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 are processed.
  • 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 conditions:
    • The system-maintained temporal space and the history space are recovered as a set.
    • The recovery of the system-maintained temporal space and the history space is to the same log point.
    • All DSNUMs are recovered in the same SYSIN.
  • ARCHIVE—Specifies 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 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 only if using AUX=NO:

  • TOCOPY dataSetName
  • OBIDXLAT without defaults
  • OUTCOPYDSN
  • RECOVERYDSN

 

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