Previous Topic: DB2 for LUW  Index Extension Exploitation Rule EditorNext Topic: Define DB2 LUW Table Partition Elements


Define DB2 LUW Table or Index Partitions

When your target server is DB2, you can work with options on the Partitions tab on the Table, Index, or Tablespace editors to specify the partition type and elements.

To define DB2 table or index partitions

  1. Click the Partitions tab in the Table, Index, or Tablespace editor and work with the following options:
    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.

    Storage Group

    Identifies the storage group for the partition. Select a storage group name from the drop-down list.

    Partition Number

    Displays a read-only integer designating the partition number.

    Is Ending Value Inclusive

    Indicates that the specified range values are included in the data partition.

  2. Click the Partition Element Editor icon to open the Partition Element editor to specify partition element properties.
  3. On the General tab, work with the following properties:
    Primary Space Allocation

    Specifies the minimum primary space allocation. Enter an integer in the text box.

    Secondary Space Allocation

    Specifies the minimum secondary space allocation. Enter an integer in the text box.

    Define Data Sets (check-box)

    Indicates that you want to define data sets rather than use DB2-managed data sets.

    Erase When Deleted (check-box)

    Indicates that you want DB2-managed data sets to be erased when they are deleted during the execution of a utility or SQL statement that drops the partition.

    Free Page Interval

    Specifies how often to leave a page of free space when the partition is loaded or reorganized. Enter an integer in the text box.

    Group Bufferpool type

    Indicates the group bufferpool type. Select a group type from the drop-down list: Changed, All, None, System.

    Percent Free

    Indicates what percentage of each page to leave as free space when the table is loaded or reorganized. Enter an integer in the text box.

    Track Modified Pages (check)

    Indicates that DB2 tracks modified pages in the space map pages of the partition. Clear the check box to indicate TRACKMOD NO.

    Volume Catalog

    Identifies the catalog name for the data set.

    Is Compressed (check-box)

    Indicates that data compression applies to the rows of the partition.

  4. Click the Columns tab to indicate partition column properties
  5. Click the Boundaries tab to indicate partition boundary properties.
  6. (Optional) Click the Comment tab and enter any comments that you want to associate with the object.
  7. (Optional) Click the UDP tab to work with user-defined properties for the object.
  8. (Optional) Click the Notes tab to view and edit user notes.
  9. Click Close.

    The Table or Index Partition Editor closes.

More Information

Define DB2 LUW Table Partition Elements

Define a DB2 LUW Table

Define a DB2 LUW Tablespace

Define a DB2 z/OS Index

Define a DB2 z/OS Table

Define a DB2 z/OS Tablespace