Copy to Copy

Go Up to Available object actions by DBMS

Platform Availability

• DB2 z/OS

The Copy to Copy dialog lets you make image copies. Starting with either the local primary or recovery site primary copy, the Copy to Copy dialog can make up to three copies of the following types:

• Local primary
• Local backup
• Recovery site primary
• Recovery site backup

The copies are used by the RECOVER utility 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 Copy to Copy execution.

To Perform a Copy To Copy Operation

1. Initiate a Copy To Copy action against a tablespace or index. For more information see Initiating an object operation.
2. Use the following table as a guide to understanding and modifying settings in the Copy To Copy Utility wizard:

Step	Settings and tasks
1	Do you want the utility to be restartable?	Lets you specify to execute Wizard in restartable mode. You can restart it from the Datasource Navigator/Explorer.
	Tape Stacking	Stacks similar output data sets as successive files on one logical tape volume, where a logical tape volume can consist of a multi-volume aggregate, if any of the resulting data sets on the tapes span volumes. Within one utility execution, output data sets are stacked on a logical tape volume of the same usage type. For example, local primary image copies are stacked separately from local backup image copies. Also lets you specify the Copy and Recovery dataset information once as variable names appended with generated values.
2-4	Object Grid	Displays the target tablespaces, indexspaces, or indexes. Your can select multiple items in the list. The Partition column is editable. You can add the partition numbers in this column, separated by commas.
	Add	For details, see Object Selector Dialog Box.
	Delete	Deletes the selected objects.
	Set Properties	For details, see Object Properties Dialog Box.

3. When ready, click Finish.

Object Properties Dialog Box

The Object Properties dialog opens when you click the Set Properties button against a selected object when performing a Copy To Copy operation.

The table below describes the options and functionality on this dialog box:

Option	Description
From	Copy - The particular image copy data set (dsn) as the input to COPYTOCOPY job. Specify the name in the Dataset Name field. Last Copy - The most recent image copy that was taken for the tablespace or index space to be the input to COPYTOCOPY job. This could be a full or incremental copy. Last Full Copy - The most recent full image copy that was taken for the object to be the input to COPYTOCOPY job. Last In CR Copy - The most recent incremental image copy that was taken for the object to be the input to COPYTOCOPY job.
Dataset Name	Only available if you selected a From Value of Copy.This field lets you specify a dataset name.
Would you like to specify the volume information	Only available if you selected a From Value of Copy. If you select Yes, you can specify a Volume and view the Sequence Number.
Local Site Primary Copy	Lets you specify a dataset name for the local site primary image copy. This relates to the copydsn1 parameter in the stored procedure.
Local Site Backup Copy	Lets you specify the device for the image copy. This relates to the copydevt1 parameter in the stored procedure.
Recovery Site Primary Copy	Lets you specify the primary space allocation amount for the image copy. This relates to the copyspace1 parameter in the stored procedure.
Recovery Site Backup Copy	Lets you specify a dataset name for the local site backup image copy. This relates to the copydsn2 parameter in the stored procedure.

Object Selector Dialog Box

The table below describes the options and functionality on the panel of the Object Selector dialog

Option	Description
Database Like	Lets you type the pattern for querying the tablespaces. You can type multiple words, separated by spaces.
Tablespace Like	Lets you type the pattern for querying the tablespaces. You can type multiple words, separated by spaces.
Creator Like	Lets you type the pattern for querying the creator. You can type multiple words, separated by spaces.
Index Like	Lets you type the pattern for querying the index. You can type multiple words, separated by spaces.
Match Case	Lets you specify match case.
Object Grid	Lets you select one or more rows in this list.
Query	Repopulates grid based on the object query.
Select All	Selects all rows in Object Grid.
Unselect All	Unselects all rows in Object Grid.