Create Clone
Go Up to Available object actions by DBMS
This action provides support for ADD CLONE option functionality, letting you create a clone on an existing base table. This creates a table with a cloned definition but with no data.
- Note: The base table must reside on a universal tablespace. For more information, see Tablespaces Wizard (DB2 Z/OS).
Platform Availability
- DB2 z/OS version 9 ^
To Create a Clone for One or More Tables:
- Initiate a Create Clone action against one or more tables. For more information see Initiating an object operation.
- Use the following table as a guide to understanding and modifying settings in the Create Clone wizard:
Step | Settings and tasks | |
---|---|---|
Action Options |
Lets you provide a Clone Name. | |
Dependencies |
Lists referring and referenced objects potentially impacted by the change. For details, see Dependencies. | |
Preview |
Displays the DDL that will execute the object action. For more information, see Preview. |
- 3. Click Execute. For information on the scheduling option, see Scheduling.
The clone for a table is not displayed in the Datasource Navigator/Explorer listing of tables for a data source. To determine whether a table has a clone, see the Dependencies tab/panel on a Table editor or on the wizard for object actions such as Drop or Rename.
After creating a clone for a table, you can exchange data between the base table and the clone.
Related Information