Auxiliary Tables (DB2)

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 for z/OS v9.x and higher. 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 a 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