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 copy options


The following options are valid for the Db2 DSNUTILB Copy utility:

Option

Description

DSNUTILB_FULL_COPY

Specify the type of copy to make when using IBM Db2 COPY (DSNUTILB) as your copy utility.

Value

Description

YES

Make a full image copy.

NO

Make an incremental image copy.

AUTO

Use the CHANGELIMIT option.

In the following situations, an incremental copy request escalates to a full image copy request:

  • No full image copies exist for the spaces that are being copied.
  • This is the first image copy request after a REORG or LOAD.
  • This is the first copy since a partial recovery was performed.
  • The most recent copy job for this space was terminated.
  • The space is a "special case" table space.
  • The most recent full image copy was a DFSMS Concurrent Copy.

    "Special case" table spaces are located in DSNDB01 and DSNDB06. For more information, see the IBM command and utility reference.

DSNUTILB_SHRLEVEL

Specify the level of access that is allowed to Db2 applications and utilities that are executing concurrently during the copy process.

Value

Description

REFERENCE

Read-only access by other programs to the spaces in the object set during the copy process.

CHANGE

Write access to the spaces in the object set.

This option is not valid for table spaces with a page size of 32 kilobytes (KB) when you specify Concurrent/DFSMS Yes.

DSNUTILB_FULL_CONCURRENT

Specifies whether to make concurrent copies by using the DFSMS Concurrent Copy utility. It is valid only when you are making a full image copy.

DSNUTILB_FULL_INCREMENTAL_PERCENT

Specifies a percent of changed pages used to determine whether to make an incremental copy or no copy. You can enter the incremental percentage value in either decimal or integer format. Valid integer values range from 0 to 100. Valid decimal values are 00.0 to 99.9. You can specify a decimal value only to the tenth’s place (1/10 of a percent).

This option is valid only when used with DSNUTILB_FULL_COPY AUTO.

DSNUTILB_FULL_FULL_PERCENT

Specifies a percent of changed pages used to determine whether to make a full copy instead of an incremental copy. You can enter the full percentage value in either decimal or integer format. Valid integer values range from 0 to 100. Valid decimal values are 00.0 to 99.9. You can specify a decimal value only to the tenth’s place (1/10 of a percent).

This option is valid only when used with DSNUTILB_FULL_COPY AUTO.

DSNUTILB_OBJECTSET

Specifies whether the IBM Db2 COPY utility ensures that all target objects share a common point of consistency. This is valid for table spaces, index spaces, and indexes. Only full image copies are supported for indexes.

DSNUTILB_COPY_PARALLEL

Specifies whether to copy objects in parallel.

Be aware of the following information:

  • This option and DSNUTILB_FULL_CONCURRENT are mutually exclusive options.
  • You must specify DSNUTILB_OBJECTSET YES to be able to copy objects in parallel.
  • This option is not available when copying objects to tape.

DSNUTILB_MAX_PARALLEL (SPE2010)

Specifies the maximum number of objects that should be processed in parallel

DSNUTILB_TAPEUNITS (SPE2010)

Specifies 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 and TEMPLATE syntax

No

Generates DSNUTILB JCL without LISTDEF and TEMPLATE syntax


 

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