Db2 COPY (DSNUTILB) options

You can set backup options that are specific to the IBM Db2 COPY utility on the DSNUTILB Copy Options panel.

The options are listed alphabetically in the following table along with the DSNUTILB defaults used by BMC AMI Recovery Manager. For some options, availability depends on the version of Db2 that is installed in your system.

For more detailed information about the DSNUTILB COPY utility options that you can use with BMC AMI Recovery Manager, see the IBM Db2 command and utility reference.

Related topics

Backup-option-descriptions

Displaying-updating-and-deleting-backup-options-for-standard-copies

DSNUTILB-copy-options

Syntax-for-updating-object-set-options

Option

Default value

Description

CHANGELIMIT

Null

Specifies whether to make incremental or full image copies based on a specified percentage of changed pages

Use this option in conjunction with Full copy Auto, and provide a percentage at the Incremental percent and Full percent prompts, as follows:

  • To create an incremental copy when the number of changed pages is more than zero but less than a percentage, type the percentage at Incremental percent.
  • To create an incremental copy when changed pages are between two percentages, type the smaller percentage at Incremental percent and the larger percentage at Full percent. No copy is made if the number of changed pages is less than or equal to the smaller percent.
  • To create a full copy when the changed number of pages is equal to or more than a percentage, type it at Incremental percent or at Full percent.
  • To create a full copy when no pages have changed, type 0 at either prompt. Otherwise, no copy is made when no pages have changed.

Important

You may enter the incremental and full percentage values in either decimal or integer format. Valid integer values range from 0 to 100. Valid decimal values are 00.0 to 99.9. A decimal value can only be specified only to the tenth’s place (1/10 of a percent).

Concurrent/DFSMS

NO

Makes concurrent copies using the DFSMS Concurrent Copy utility

This option is valid only when you specify a full image copy. SHRLEVEL REFERENCE is required for objects with a page size greater than 4K.

Copy Objects as an Object Set

NO

Specifies that all target objects share a common point of consistency

This option is valid for table spaces, index spaces, and indexes. Only full image copies are supported for indexes.

Copy Objects in Parallel

NO

Copies objects in parallel

Be aware of the following information:

  • Concurrent/DFSMS and Copy Objects in Parallel are mutually exclusive.
  • You must specify Yes to Copy Objects as an Object Set to be able to copy objects in parallel.
  • Copy Objects in Parallel is not available when copying objects to tape.

Full copy

YES

Specifies whether a full or incremental copy should be made, as follows:

Value

Description

Yes

Full image copy

No

Incremental image copy

Auto

Use the CHANGELIMIT option to escalate to a full image copy request when the following conditions exist:

  • The most recent full image copy is a DFSMS concurrent copy.
  • No full image copy exists 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.


Important

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

Max parallel objects

1

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

SHRLEVEL

REFERENCE

Specifies the level of access that is allowed to Db2 applications and utilities that are executing concurrently during the copy process, as follows:

Value

Description

Shrlevel Reference

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

Shrlevel Change

Allows other programs to write to the spaces in the object set. This option is not valid for table spaces having a page size of 32 kilobytes (KB) when you specify Concurrent/DFSMS Yes.

Max tape units

0

Specifies the maximum number of tape units that the utility allocates. A value of 0 means lets the utility determine the number of tape units to use. Valid values are from 0 to 999.

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 all the items in the list.

Value

Description

Yes

Generates DSNUTILB JCL with LISTDEF, TEMPLATE, and COPY LIST

No

Generates DSNUTILB JCL with a DD statement for each object to be copied


 

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