Processing related LOB and XML spaces (AUX spaces)

Edit online

In an object profile, Db2 Automation Expert can automatically include LOB and XML spaces that are related to base table spaces. These auxiliary spaces can be included either at job build time or at job run time, depending on whether you specify the use of LISTDEFS in the job profile.

About this task

LOB and XML spaces can be included in the object profile when one or more base table spaces are selected via the Enter Tablespaces Like to Display window, or on the Update Object Profile Display.

Procedure

  1. In the Process AUX field on the Enter Tablespaces Like to Display window, or in the AUX field on the Update Object Profile Display, enter one of the following values and press Enter.
    • L: Processes the base table space and all its related LOB table spaces.
    • X: Processes the base table space and all its related XML table spaces.
    • A: Processes the base table space and all its related LOB and XML table spaces. The point in time when related XML or LOB objects are discovered and resolved depends on the value in the Generate Listdefs field in the job profile, as follows:
      • When Generate Listdefs is set to Y, only the base table space is listed, but the ALL keyword is included in the LISTDEF. Related XML or LOB spaces (or both) are discovered at run time so that the base table spaces and its related LOB spaces or XML spaces are included in the JCL at run time.
      • When Generate Listdefs is set to N, the base table space and its related LOB or XML table spaces (or both) are discovered and included in the JCL at job build time.
    • N: Processes only the base table space object.
  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 the base 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 Update Object Profile Display shows the base table space with Y in the Wildcard field.
  3. On the Update Object Profile Display, the base table space is listed and the AUX field indicates whether LOB, XML, or both types of related objects will be selected.
    You can use the EXPLODE primary or line command to see an expanded list of all of the table spaces and index spaces, including LOB and XML objects, that are included in the profile.
  4. Verify that the LISTDEF options for the job profile are set as desired.
    1. On the Update Jobs Profile Display, enter Y in the Update Job Generation options field and press Enter.
    2. On the Generation Options panel, enter Y in the Update Template/Listdef/Option parms field and press Enter.
    3. On the Utility Parms window, in the Generate Listdefs field, enter the desired value.