Temporary objects definition
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.
You can enter only one occurrence of each keyword (STOGROUP, DATABASE, TABLESPACE, or OWNER) in a drop recovery step.
|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.
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.
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.
Specifies the table space where NGT Recover creates temporary copies of a dropped table during the recovery. The default value for tableSpaceName is ALPTMPTS.
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.