Auxiliary Tables

An auxiliary table is a table used to store LOB data for a LOB column belonging to a regular (base) table.
carcudb2
An auxiliary table is a table used to store LOB data for a LOB column belonging to a regular (base) table.
The Auxiliary Table screens let you alter, create and template DB2 auxiliary tables. These screens appear when you specify
A
(auxiliary) in the Table Type field on the Table Create, Alter, or Template screens.
The Aux Table screens let you alter, create, and template DB2 auxiliary tables. As with regular tables, you can:
  • Enter selection criteria to bring up lists of objects to choose from.
  • Apply user defaults to the table definition using the Apply Def command.
  • Display the original and current definitions of an object using the COMPARE command.
In addition, you can display a list of LOB columns in the base table, by specifying selection criteria in the Base Table field. From this list, you can select the LOB column for your table.
When altering a table object of any type, you cannot switch from an auxiliary table to a standard table and vice-versa. However, you can change the type on a create or template.
For auxiliary tables, you must specify a LOB tablespace that resides in the same database as that of the base table in the Tablespace field.
The Base Table, Creator, Column Name, and Part fields are unique to auxiliary tables and contain the LOB column information for the auxiliary table as follows:
  • Base Table
    Indicates the name of the table that contains the LOB column for the auxiliary table. To select from a list, enter selection criteria.
  • Creator
    Identifies the creator of the base table that contains the LOB column for the auxiliary table.
  • Column Name
    Specifies the name of the LOB column in the base table for which the auxiliary table is to store LOB data.
  • Part
    Specifies the partition of the base table for which the auxiliary table is to store the specified column's LOB data.
  • TS Parts
    Indicates whether the tablespace is partitioned. A value is required when the tablespace is partitioned. Do not specify a partition when the tablespace is not partitioned. This field is optional when the specified base table or its tablespace is not found.
    Do not specify a partition number for an auxiliary table that already exists for the same partition, base table and LOB column. For more information about the fields, press F1 (Help).