Physical Modeling › DB2 LUW Property Editors › Define DB2 LUW Table Partition Elements

Define DB2 LUW Table Partition Elements

Use the options in the Table Partition Elements Editor to set properties for a table partition.

To define DB2 LUW table partition elements

1. Click the Partitions tab in the DB2 LUW Table Editor.

   Two panes display the available partition columns, and the partition elements.

2. Click the Partition Element Editor icon in the Partition Elements pane.

   The Table Partition Elements Editor opens.

3. Work with the following options:

   Name

   Specifies the name of the partition.

   Partition Number

   Specifies the partition number.

   Is Ending Value Excluded

   Specifies whether or not the ending value is excluded in the partition.

4. Click the Boundaries tab and work with the following options:

   Name

   Specifies a name for the partition boundary.

   Partition Column

   Specifies the column participating in the partition. This field is read-only and is based on the columns you have selected in the Partition tab of the DB2 Table Editor.

   Ending Value Type

   Specifies the type of the ending value. Select from the drop-down list; valid values are, Min Value and Max Value.

   Ending Value

   Specifies the last value in the partition.

5. Click the Comment tab and enter any comments you want associated with the table partition element.
6. Click the Where Used tab to review where the selected table partition element is used.
7. Click the UDP tab to work with user-defined properties for the table partition element.
8. Click the Notes tab to view history information and view or edit user notes.
9. Click Close.

   The Table Partition Element Editor closes.

More Information

Define a DB2 LUW Table