Creating an auxiliary table

To create a new auxiliary table, perform the following on the Db2® Object Functions panel:

  1. Type 12 in the Object Type entry field.
  2. Type C on the command line.
  3. Press Enter. FM/Db2 displays the Create Auxiliary Table panel.

Auxiliary tables are required for LOB support. An auxiliary table is needed if a table contains a LOB column. If such a column is defined, an auxiliary table needs to be defined to store the data for that column. If the table is also partitioned, there needs to be an auxiliary table for each partition.

Related references