Auxiliary table properties (DB2 for z/OS)

Properties for DB2® for z/OS® auxiliary table objects

For more information about specific syntax, see the reference information that is included with each database product. Syntax definitions for some database vendors or versions might differ from the following descriptions.

Auxiliary tables are supported for DB2 for z/OS data servers and are used to store LOB data.

General page
Property Description
Name Specifies a name for the object.
Label Specifies a label. This label is displayed in visual diagrams.
Table Space Specifies the table space in which the auxiliary table is created. The name must identify an empty LOB table space that currently exists at the current server. The LOB table space must be in the same database as the associated base table.
Column Specifies the base table and the column of that table that is to be stored in the auxiliary table. If the base table is nonpartitioned, an auxiliary table must not already exist for the specified column. If the base table is partitioned, an auxiliary table must not already exist for the specified column and specified partition.
Documentation page
Specifies user-supplied information about the object.
Annotation page (in edit mode only)
Add, modify, or delete properties.

Feedback