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 Recovery Manager for Db2 13.1.

DSNUTILB recover options

The following options are valid when using the Db2 DSNUTILB Recover utility:

Option

Description

DSNUTILB_SITE_TYPE

Specify the site type for recoveries when using DSNUTILB as the recover utility.

Value

Description

LOCAL

Recover the local site image copy (DSNUTILB keyword LOCALSITE).

RECOVERY

Recover the remote site image copy (DSNUTILB keyword RECOVERYSITE).

DSNUTILB_SORTKEYS

Specifies that index keys should be sorted in parallel with the reload and build phases to improve performance. Specify YES to sort the index keys in parallel. Otherwise, specify NO.

WORKDDN specifications are ignored when you specify YES.

We recommend using this option if you need to recover more than one index.

DSNUTILB_STATISTICS

Gather index statistics from the Db2 catalog. Specify YES to gather statistics. Otherwise, specify NO.

DSNUTILB_REPORT

Print the statistics collected (the ACCESSPATH and SPACE statistics reports). This option is valid only with STATISTICS YES.

DSNUTILB_UPDATE

Update the catalog tables, as follows. This option is valid only with REPORT YES.

Value

Description

NONE

Do not update the catalog tables.

ALL

Insert all the collected statistics in the Db2 catalog tables.

ACCESSPATH

Update only those columns used for access path selection.

SPACE

Update only those columns that provide statistics about the status of the target indexes.

DSNUTILB_KEYCARD

Collect the values in all of the key column combinations for the target indexes. This option is valid only with STATISTICS YES.

DATASET_SIZING

Specifies the method by which object sizes are determined. Statistics in the BMCSTATS table are collected by DASD MANAGER PLUS and optionally by BMC AMI Copy.

Value

Description

CATALOG

Use the Db2 and integrated catalog facility (ICF) catalog information for sizing purposes at the time of JCL generation. Doing so requires sizing calculations at the time of JCL generation.

DEFAULTS

Use existing default sizing information from the Work File options established in the Recovery options.

BMCSTATS

Use statistics from the BMCSTATS tables.

DSNUTILB_PARALLEL (SPE2010)

Specify the maximum number of objects to be processed in parallel.

DSNUTILB_TAPEUNITS (SPE2010)

Specify the maximum number of tape units that the utility allocates.

DSNUTILB_LISTDEF (SPE2010)

Enables you to group database objects into reusable lists.

Value

Description

Yes

Generates DSNUTILB JCL with LISTDEF syntax. 

No

Generates DSNUTILB JCL without LISTDEF syntax

Related topics

Recovery-utility-options

Syntax-for-updating-object-set-options

 

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