Processing referentially related table spaces

Edit online

Db2 Automation Expert provides the ability to include all table spaces related via referential integrity. This allows a utility to maintain referential constraints by executing all referentially related objects at the same time.

About this task

Some job steps cannot use LISTDEFs for object determination. These include the job registration step for the job tracking task; START and STOP DATABASE commands; Db2 Automation Expert utilities such as reallocation; and any IBM® utility or command that does not support LISTDEFs, such as REPAIR. If RI spaces are to be processed and job generation options specify LISTDEFS, the job steps that cannot use LISTDEFs must determine the RI structure at job build time. If the RI structure changes between job build and job execution time, the object lists may not be consistent between steps.

Procedure

  1. To process referentially related objects, do one of the following:
    • On the Enter Tablespaces Like to Display window, enter one of the following values in the Process Referentially Dependent Tablespaces field.
      Y
      Specifying Y processes the table space and all its referentially dependent table spaces. The RI will be expanded depending on the value of the LISTDEF job option. With LISTDEFs off, the RI will be expanded at build time. If LISTDEFs are selected, the RI will be expanded at utility execution time via LISTDEF RI keyword. However, wildcarded objects that are processed at the partition level are always exploded at build time, because the LISTDEF RI and PARTLEVEL keywords are mutually exclusive.
      B
      Specifying B means that RI is expanded at build time if the LISTDEF job option is set to N. If the LISTDEF job option is set to Y, RI is expanded at run time.
      R
      Specifying R forces RI to be expanded at utility execution time. LISTDEFs are required with this option. This option cannot be specified for wildcarded objects that are processed at the partition level, because the LISTDEF RI and PARTLEVEL keywords are mutually exclusive.
      N
      Specifying N does not process referentially related table spaces.
    • On the Update Object Profile Display, when viewing objects already included in the profile, enter Y, B, R or N in the Process RI column for the selected objects. Refer to the previous step for a description of these values.
  2. On the Update Object Profile Display, you can view the objects that are included in the profile by using the EXPLODE primary or line command.