Db2 RECOVER options
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 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 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 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.
|