Copy to Copy
Go Up to Available object actions by DBMS
Platform Availability
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
- Initiate a Copy To Copy action against a tablespace or index. For more information see Initiating an object operation.
- 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. |