Auxiliary tables

Chapter 12 DBMS-Specific Features

Auxiliary tables

Auxiliary tables are used to store large object (LOB) data, such as graphics, video, etc, or to store rarely-accessed data in order to improve the performance of the base table.

Auxiliary tables are supported for IBM DB2 v9.x and higher for z/OS. PowerDesigner models auxiliary tables as extended objects with a stereotype of <<Auxiliary Table>>.

Creating an auxiliary table

You can create an auxiliary table in any of the following ways:

Select Model→Auxiliary Table to access the List of Auxiliary Tables, and click the Add a Row tool.
Right-click the model or package in the Browser, and select New→Auxiliary Table.

Auxiliary table properties

You can modify an object's properties from its property sheet. To open an auxiliary table property sheet, double-click its Browser entry in the Auxiliary Tables folder.

The following extended attributes are available on the DB2 tab:

Name	Description
Database	Specifies the database in which the LOB data will be stored. Scripting name: Database
Tablespace	Specifies the table space in which the auxiliary table is created. Scripting name: Tablespace
Table	Specifies the table that owns the LOB column. Scripting name: Table
Column	Specifies the name of the LOB column in the auxiliary table. Scripting name: Column
Partition	Specifies the partition of the base table for which the auxiliary table is to store the specified column. Scripting name: Partition