Db2 RECOVER options
You can set recover options that are specific to IBM Db2 RECOVER (DSNUTILB) on the DSNUTILB Options panel.
The fields are listed alphabetically in the following table along with the BMC AMI Recovery Manager defaults:
Field and DSNUTILB keyword | Default value | Description | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
DSNUTILB sitetype Keyword: SITETYPE | Local | Specifies whether to recover the local site image copy (DSNUTILB keyword LOCALSITE) or the remote site image copy (DSNUTILB keyword RECOVERYSITE). | ||||||||||
SORTKEYS Keyword: SORTKEYS | No | Specifies that index keys be sorted in parallel with the reload and build phases to improve performance We recommend using this option if you need to create more than one index. WORKDDN specifications are ignored when you specify Yes. | ||||||||||
STATISTICS Keyword:STATISTICS | No | Gathers index statistics from the Db2 catalog If STATISTICS is set to No, the values in REPORT, UPDATE, and KEYCARD are not generated in the JCL. | ||||||||||
REPORT Keyword: REPORT | Yes | Prints the statistics collected (the ACCESSPSATH and SPACE statistics reports) You use this keyword in conjunction with STATISTICS Yes. | ||||||||||
UPDATE Keyword:UPDATE | NONE | Updates the Db2 catalog tables with the collected statistics, as follows:
| ||||||||||
KEYCARD Keyword:KEYCARD | No | Collects all values in all of the key column combinations for the target indexes This option is valid only when you specify STATISTICS Yes. | ||||||||||
Recover scope Keyword:Recover scope | Recovers only those objects that have changed since the specified recovery point. The RECOVER utility does not process objects in the list that have not changed since the recovery point. The following objects are exceptions and are recovered even if they have not changed since the specified recovery point:
| |||||||||||
Parallel (SPE2010) Keyword:Parallel | 1 | Specifies the maximum number of objects to be processed in parallel. If you omit Parallel, one object is recovered at a time. If you specify Parallel 0 or do not specify Tape units, the utility determines the optimal number of objects to process in parallel. Valid values are from 1 to 999. | ||||||||||
Tape Units (SPE2010) Keyword:Tape Units | 0 | Specifies the maximum number of tape units that the utility allocates. If you omit this keyword or specify 0, the utility determines the number of tape drives to allocate for recovery. Valid values are from 0 to 999. | ||||||||||
Listdef (SPE2010) Keyword:Listdef | Enables you to group database objects into reusable lists. You can then specify these lists in other utility control statements to indicate that the utility should process the items in the list.
|