Space announcements

   

This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

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 NGT Recover, and generated SQL statements.

The following figure shows the Temporary objects definition syntax.


Note

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

OptionDescription
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.

ValueDescription
YESDirects 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 NGT Recover. For more information, see TABLE NAME userID.tableName.
NOUse this value only when a table space contains a single table. Log Master directs NGT 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 NGT 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 NGT Recover to use the storage group where the original table space was stored.

DATABASE databaseName

Specifies the DB2 database where NGT 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 NGT 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 NGT Recover uses as it creates temporary copies of a dropped table during the recovery. The default value for userID is ALPTMPUS.

Related topic


Was this page helpful? Yes No Submitting... Thank you

Comments