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 Log Master for Db2 13.1.

Temporary objects definition

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

This syntax determines:

  • Whether Log Master creates temporary copies of the dropped table and table space as it recovers a dropped table.
  • The physical and logical locations where Log Master stores the temporary copies.

This syntax applies only to recovery of individual tables, not table spaces. 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 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 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. 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. 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 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, 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, 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.

Related topic

DROPRECOVERY-statement


 

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