Creating table partition policy details

1. Select Database Administration > Data Connections from the management console. The Database Administration page appears.

2. Select a database connection from the list of connections available in the Connections panel.

3. Click Partition policies in the Storage Management area. The Table Partition Policies page appears.

4. Click Edit Details in the Action column of a partition policy to edit its details. The Edit Partition Policy Details page appears.

Table 1. Policy type options
Option	Description
range	This option indicates that the policy details specify a range of values.
list	This option indicates that the policy details specify a list of values.
list-range	This option indicates that the policy details allow both a range and a list of values.

Table 2. Default allocation options
Option	Description
None	This option indicates that the new partitions must not be allocated any space.
Immediate	This option indicates that the new partitions must be allocated storage space.

The Has composite partition setting shows whether the table partition policy has composite partitions.

The Read-only composite partition setting shows whether a composite table partition policy is read-only.

6. Click Add to add a partition policy detail at the end of the list of existing partition policy details. You can also select a partition policy detail and click Insert Before or Insert After to add a new partition policy detail before or after the selected partition policy, respectively. A new row for the partition policy detail is added to the list.

8. Enter the Name and Description of the partition detail in the Name/Description column. Name is a mandatory field.

This field is disabled in the following cases:

If the Object allocation rule option is set to Immediate while creating the table partition policy.

If partition policy details are added to a non-empty table before creating a table partition policy.

is set to partition object-allocation rules have been specified earlier while creating the partition policy.

If the Composite option is selected, the table data is in the default partition.

For a non-empty table, the Composite option is selected after the partition policy creation.

Select the Split-target option to specify that the table data is ready to migrate from the default partition to the respective partitions based on the partition policy details.

Selecting this option enables the partition policy detail for splitting. The table data must be migrated to the respective partitions using the PartitionSplitUtility API. Once the PartitionSplitUtility API is executed, the Split-target option is disabled to specify that the table values have already been migrated to the respective partition as per the partition policy detail.

Select the Read-only option to set the table partition policy detail as read-only.

Since a composite partition is set at the policy level, if the Composite option is selected, the Read-only option is also selected and is not editable. You can still set the Read-only option for a non-composite table partition policy details.

10. Enter the Data, Index, and LOB values in the Areas column. These values are inherited from the parent policy.

11. Click Partitions in the Partitions column to set partitions for the policy detail. The Policy Detail Partitions dialog appears. You can set the following options:

Select a partition to view its properties in the Partition Properties area.

Set the Area by clicking the search icon. The Area Selection dialog enables you to search for and select the available partition areas.

Select the buffer pool in the Buffer pool list. The available options are Primary (default) and Alternate.

12. Click OK to apply the policy detail partition changes or Cancel to undo the changes.

13. In the Edit Partition Policy Details page, click Update and then click Commit at the bottom of the page to save your created table partition policy detail.