Physical Modeling › DB2 z/OS Property Editors › Define a DB2 z/OS Table

Define a DB2 z/OS Table

Use the DB2 z/OS Table editor to create a table, or work with table properties for an existing DB2 z/OS table.

To define a DB2/zOS Table

1. Right-click a Table in the Model Explorer and select Properties.

   The DB2 z/OS Table Editor opens.

2. Select a table and work with the following options:

   Note: Click New on the toolbar to create a table. Use the Enter filter text text box to filter a very large list of tables to locate the one you want to work with.

   Physical Name

   Specifies the physical name of the table.

   Schema

   Specifies the schema to associate with the table. Select a schema from the drop-down list.

   DB2 z/OS Type

   Specifies the table type. Select a value from the drop-down list; valid values are Permanent and Global Temporary.

   Physical Only

   In a Logical/Physical model, specifies that the table does not appear on the logical side of the model.

   Generate

   Generates DDL for this object during Forward Engineering.

3. Work with the following fields on the General tab:

   In Tablespace

   Specifies the tablespace the table is associated with. Select a tablespace from the drop-down list.

   In Database

   Specifies the database the table is associated with. Select a database from the drop-down list.

   Edit Procedure

   Specifies the edit routine for the selected table. Enter a value in the field.

   Validation Procedure

   Specifies the validation exit routine for the table. Enter a value in the field.

   Object Id

   Specifies the OBID (identifier for an object's internal descriptor) to use for the selected table. Enter a value in the field.

   Data Capture

   Specifies whether action logging is augmented.

   CCSId

   Specifies the encoding scheme for string data stored in the table. Valid Values: ASCII, EBCDIC, UNICODE.

   Has Volatile Cardinality

   Specifies that index access should be used on this table wherever possible for SQL operations. Clear the check box to specify NOT VOLATILE.

   Audit Access Type

   Identifies the types of access to the selected table that causes auditing to be performed. Valid Values: None, Changes, All.

   Has Restriction on Drop

   Indicates that the selected table has the restriction on drop. Clear the check box to remove the restriction on dropping the table, and the database and table space that contain the table.

   Is Appendable

   Specifies that append processing is used for the selected table. Clear the check box to indicate APPEND NO.

   Label

   Specifies the description of the table.

4. Work with the following fields on the Partitions tab:

   Properties:

   Partition Type

   Specifies the partition type for the selected table or index. Select Range or Size from the drop-down menu.

   Partition Elements:

   Name

   Specifies the partition name.

   Partition Number

   Displays a read-only integer designating the partition number.

   Partition Columns:

   Column

   Specifies the columns to determine key data over which the range is defined to determine the target data partition of the data.

   Nulls Last

   Specifies that null values are treated as positive infinity during comparison.

   Sort Order

   Specifies the order in which the data in the selected columns are sorted. Select from the drop-down list; valid values are Ascending and Descending.

   Default: Ascending

5. Work with the other tabs in the editor to access additional design features, for example:
   • Specify volumetrics options on the Volumetrics tab.
   • Define constraints for a selected table on the Validation tab.
   • Define alias and synonym names on the Alias & Synonym tab. You can open the Synonym editor from an icon on this tab if none yet exist.
   • Associate permissions with the selected table on the Permission tab.
   • Review where the table is used on the Where Used tab.
   • Change the object creation order on the Object Creation Order tab.
6. (Optional) Click the Comment tab and enter any comments you want associated with the table.
7. (Optional) Click the UDP tab to work with user-defined properties for the table.
8. (Optional) Click the Notes tab to view history information and view or edit user notes.
9. Click Close.

   The Table Editor closes.

More information:

Specify Volumetric Information for a Table

Define DB2 z/OS Table Partition Elements

Define DB2 z/OS Table Synonyms

Define DB2 z/OS Permissions at Database Level

Add a Comment in a Property Editor

Add a UDP in a Physical Property Editor