AUX

The AUX option specifies if auxiliary objects will be included with the recovery of the base table spaces.

The AUX option is available on the OPTIONS command or in the table space specification for any of the following BMC AMI Recover commands:

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

If you do not specify AUX on one of these commands, BMC AMI Recover uses the value of the AUX installation option (AUX-NO), which has a default value of NO.

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 ALL, AUX XML, or AUX LOB, you cannot specify the following options:

TOCOPY dataSetName
OBIDXLAT without defaults
OUTCOPYDSN
RECOVERYDSN

Valid values are NO, ALL, XML, and LOB.

Value	Description
AUX NO	BMC AMI Recover does not include XML or LOB objects. You may include HISTORY spaces with the HISTORY keyword when a table space with system-maintained temporal tables is specified in SYSIN. For more information, see HISTORY. You can include ARCHIVE spaces with the ARCHIVE keyword when a table space with an archive table is specified in SYSIN. For more information, see ARCHIVE.
AUX ALL	BMC AMI Recover includes XML and LOB objects for the base table space. It does not include HISTORY spaces with their related auxiliary objects when a table space with system-maintained temporal tables is specified in SYSIN. You may include HISTORY objects with the HISTORY keyword. See HISTORY. You can include ARCHIVE spaces with the ARCHIVE keyword when a table space with an archive table is specified in SYSIN. For more information, see ARCHIVE.
AUX XML	BMC AMI Recover 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	BMC AMI Recover 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.

Important

Specifying AUX … on the OPTIONS statement in SYSIN applies AUX ... to all RECOVER statements. To override AUX in the OPTIONS statement, specify AUX … only on the RECOVER statements you wish to override.

HISTORY

When you specify HISTORY, BMC AMI Recover includes history spaces when a table space with system-maintained temporal tables is specified in SYSIN.

You must specify AUX to use the HISTORY keyword. The meaning of the HISTORY keyword depends on the AUX option specified, as follows:

AUX NO HISTORY includes regular tables, system-time base tables, and their related HISTORY tables. It does not include related XML or LOB objects.
AUX ALL HISTORY includes regular tables, system-time base tables and their related HISTORY tables, and all related XML or LOB objects.
AUX XML HISTORY includes regular tables, system-time base tables and their related HISTORY tables, and all related XML objects.
AUX LOB HISTORY includes regular tables, system-time base tables and their related HISTORY tables, and all related LOB objects.

AUX

HISTORY

ARCHIVE

On this page