Temporary objects definition

This topic describes the Temporary objects definition syntax used in the DROPRECOVERY statement.

This syntax determines:

  • Whether BMC AMI Log Master creates temporary copies of the dropped table and table space as it recovers a dropped table.

Related topic

DROPRECOVERY-statement

  • The physical and logical locations where BMC AMI Log Master stores the temporary copies.

This syntax applies only to recovery of individual tables, not table spaces. BMC AMI Log Master includes this information in generated data definition language (DDL) statements, the INDEP OUTSPACE syntax that it can pass to BMC AMI Recover, and generated SQL statements.

The following figure shows the Temporary objects definition syntax. 


GUID-51116388-14C7-483E-9497-DBB76347BC7C-low.png

Important

You can enter only one occurrence of each keyword (STOGROUP, DATABASE, TABLESPACE, or OWNER) in a drop recovery step.

Option

Description

INDEP YES | NO

Specifies whether BMC AMI Log Master creates and uses temporary copies to recover the dropped table. Use the default value of YES for normal processing.

Value

Description

YES

Directs BMC AMI Log Master to create temporary copies of the dropped table and the table space that originally contained the dropped table. This is the default value. BMC AMI Log Master generates INDEP OUTSPACE syntax and passes it to BMC AMI Recover. For more information, see TABLE NAME userID.tableName.

NO

Use this value only when a table space contains a single table. BMC AMI Log Master directs BMC AMI Recover to recover the dropped table directly into the original table space (which makes the table space unavailable for a period of time). For a single-table table space, this value improves drop recovery performance because BMC AMI Log Master avoids generating and executing MIGRATE SQL to move data from the temporary copy of the table into the original location. When you specify NO, BMC AMI Log Master ignores any locations that you specify for temporary objects.

STOGROUP storageGroupName

Specifies which Db2-defined storage group BMC AMI Recover uses to create temporary copies of Db2 objects during the recovery of a dropped table. If you do not specify a storage group, BMC AMI Log Master directs BMC AMI Recover to use the storage group where the original table space was stored.

DATABASE databaseName

Specifies the Db2 database where BMC AMI Recover creates temporary copies of Db2 objects during the recovery of a dropped table. The default value for databaseName is ALPTMPDB.

TABLESPACE tableSpaceName

Specifies the table space where BMC AMI Recover creates temporary copies of a dropped table during the recovery. The default value for tableSpaceName is ALPTMPTS.

OWNER userID

Specifies the user ID that BMC AMI Recover uses as it creates temporary copies of a dropped table during the recovery. The default value for userID is ALPTMPUS.

 

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