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
Specifies the partition type for the selected table or index. Select Range or Size from the drop-down menu.
Partition Elements:
Specifies the partition name.
Identifies the storage group for the partition. Select a storage group name from the drop-down list.
Displays a read-only integer designating the partition number.
Indicates that the specified range values are included in the data partition.
Specifies the minimum primary space allocation. Enter an integer in the text box.
Specifies the minimum secondary space allocation. Enter an integer in the text box.
Indicates that you want to define data sets rather than use DB2-managed data sets.
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.
Specifies how often to leave a page of free space when the partition is loaded or reorganized. Enter an integer in the text box.
Indicates the group bufferpool type. Select a group type from the drop-down list: Changed, All, None, System.
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.
Indicates that DB2 tracks modified pages in the space map pages of the partition. Clear the check box to indicate TRACKMOD NO.
Identifies the catalog name for the data set.
Indicates that data compression applies to the rows of the partition.
|
Copyright © 2013 CA.
All rights reserved.
|
|