COPYTOCOPY

The COPYTOCOPY online utility makes image copies from an image copy that was taken by the COPY utility. The COPYTOCOPY utility can also make image copies from inline copies that the REORG or LOAD utilities make.

Start of change Starting with the local primary copy or a recovery-site primary copy, or a copy created by using FlashCopy® technology, COPYTOCOPY can make up to four sequential format copies of one or more of the following types of copies: End of change

Local primary
Local backup
Recovery site primary
Recovery site backup

You can make both full and incremental image copies of a LOB or XML table space.

You cannot run COPYTOCOPY on concurrent copies.

The RECOVER utility uses the copies when recovering a table space or index space to the most recent time or to a previous time. These copies can also be used by MERGECOPY, UNLOAD, and possibly a subsequent COPYTOCOPY execution.

Output

Output from the COPYTOCOPY utility consists of:

Up to three sequential data sets that contain the image copy. If the copy base is a FlashCopy, four sequential copies can be made.
Up to three sequential data sets that contain the image copy.
Rows in the SYSIBM.SYSCOPY catalog table that describe the image copy data sets that are available to the RECOVER utility. Your installations responsible for ensuring that these data sets are available if the RECOVER utility requests them.

The entries for SYSCOPY columns remain the same as the original entries in the SYSCOPY row when the COPY utility recorded them. The COPYTOCOPY job inserts values in the columns DSNAME, GROUP_MEMBER, JOBNAME, AUTHID, DSVOLSER, and DEVTYPE.

Authorization required

To execute this utility, you must use a privilege set that includes one of the following authorities:

IMAGCOPY privilege for the database
DBADM, DBCTRL, or DBMAINT authority for the database. If the object on which the utility operates is in an implicitly created database, DBADM authority on the implicitly created database or DSNDB04 is required.
System DBADM authority
SYSCTRL or SYSADM authority

An ID with installation SYSOPR authority can also execute COPYTOCOPY, but only on a table space in the DSNDB01 or DSNDB06 database.

Restrictions on running COPYTOCOPY

COPYTOCOPY does not support the following catalog and directory objects:
- DSNDB01.SYSUTILX and its indexes
- DSNDB01.DBD01 and its indexes
- DSNDB01.SYSDBDXA and its indexes
- DSNDB06.SYSCOPY and its indexes
An image copy from a COPY job with the CONCURRENT option cannot be processed by COPYTOCOPY.
COPYTOCOPY does not check the recoverability of an object.
COPYTOCOPY does not support a range of partitions within a partitioned table space. Specify individual DSNUM(n). From the inline copy, COPYTOCOPY copies only the specified partition into the output image copy data set.

Execution phases of COPYTOCOPY

The COPYTOCOPY utility operates in these phases:

Phase: Description
UTILINIT: Performs initialization
CPY2CPY: Copies an image copy
UTILTERM: Performs cleanup

Syntax and options of the COPYTOCOPY control statement
The COPYTOCOPY utility control statement, with its multiple options, defines the function that the utility job performs.
Data sets that COPYTOCOPY uses
The COPYTOCOPY utility uses a number of data sets during its operation.
Concurrency and compatibility for COPYTOCOPY
The COPYTOCOPY utility has certain concurrency and compatibility characteristics associated with it.
Full or incremental image copies with COPYTOCOPY
You can copy a full image copy or an incremental image copy by using FROMLASTCOPY keyword.
Incremental image copies with COPYTOCOPY
You can use COPYTOCOPY to make an incremental image copy. An incremental image copy is a copy of the pages that have changed since the last full or incremental image copy.
Using more than one COPYTOCOPY statement
You can use more than one control statement for COPYTOCOPY in one DB2 utility job step.
Copying from a specific image copy
You can specify a particular image copy that is to be used as input to the COPYTOCOPY utility by using the FROMCOPY option.
Copying a FlashCopy image copy by using COPYTOCOPY
COPYTOCOPY can create up to four sequential image copies of a FlashCopy image copy. COPYTOCOPY and COPY are the only utilities that can create sequential copies from a FlashCopy image copy.
Using TEMPLATE with COPYTOCOPY
Template data set name substitution variables resolve as usual. COPYTOCOPY does not use the template values of the original COPY utility execution.
Updating SYSCOPY records
The image copies COPYTOCOPY made are registered in SYSIBM.SYSCOPY for later use by the RECOVER utility. Other utilities can use these copies, too.
How COPYTOCOPY determines which input copy to use
The COPYTOCOPY utility makes a copy of an existing image copy. Which image copy the utility uses as input depends on the options that you specify and where you run the utility job.
Generation data group definitions for the COPYTOCOPY utility
You can use generation data groups to hold image copies. Use of generation data groups offers the benefit of automating allocation of data set names and deletion of the oldest data set. You can also use templates when using generation data groups.
Using DB2 with DFSMS products
You can use DB2 with DFSMS products.
Image copies on tape
Do not combine a full image copy and incremental image copies for the same table space on one tape volume. If you do, the RECOVER TABLESPACE utility cannot allocate the incremental image copies.
Copies of lists of objects from tape
The COPYTOCOPY utility determines the number of tape drives to use for the function.
Termination or restart of COPYTOCOPY
You can terminate or restart the COPYTOCOPY utility.
Sample COPYTOCOPY control statements
Use the sample control statements as models for developing your own COPYTOCOPY control statements.

Parent topic: DB2 online utilities