Creating Models › Target Servers for Physical Models › Database Property Editors › 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. Work with the following options in the General tab:

   Tablespace

   Specifies the name of the tablespace where you want to store the partition data.

   Index Tablespace

   Specifies the tablespace where you want to store the partitioned index that is created on the partitioned table.

   Long Tablespace

   Specifies the tablespace where you want to store long columns.

   Duration Value

   If the key column of the partition is of Date or Timestamp data type, this field specifies the increment for which the partitions are to be created. Enter a numeric value.

   Duration Type

   Specifies the type of duration. For example, months, hours, or days.

5. 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.

6. (Optional) Click the Comment tab and enter any comments that you want to associate with the object.
7. (Optional) Click the Where Used tab to view where the object is used within the model.
8. (Optional) Click the UDP tab to work with user-defined properties for the object.
9. (Optional) Click the Notes tab to view and edit user notes.
10. (Optional) Click the Extended Notes tab to view or edit user notes.
11. Click Close.

    The Table Partition Element Editor closes.

More Information

Define a DB2 LUW Table