Previous Topic: Define DB2 LUW Table or Index PartitionsNext Topic: Define DB2 LUW Permissions at Database Level


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