Processing clone tables

Edit online

Db2 Automation Expert can automatically process clone tables that are related to a table spaces. When you specify to process clone objects, only the clone objects are included in the object profile.

About this task

The clone table has the same structure as the base table, exists in the same table space, and is used to hold a copy of the base table. All related objects are cloned as well, such as indexes and before triggers. In addition, data can be exchanged between a base table and clone table by using SQL statements. In Db2 Automation Expert, when you specify to process clone objects, only the clone objects are included in the object profile. If you want to also process the base object, you must separately include the base object with the Process Clone column set to N.

Procedure

  1. On the Enter Tablespaces Like to Display window, enter Y in the Process Cloned Tables field.
  2. Follow one of these steps, depending upon how you are selecting table spaces:
    • If you are selecting table spaces from a list, the Include Tablespace Selection panel is displayed. Enter S next to a clone table and press Enter. A message is displayed to confirm that the table space is added.
    • If you are selecting table spaces by using the Wildcard field, the clone table spaces are automatically included in the object profile.
  3. On the Update Object Profile Display, you can view the clone objects that are included in the profile by using the EXPLODE primary or line command.
    You can also change the value in the Process Clone column.