Try OpenEdge Now
skip to main content
Managing Table Partitioning in Databases
Managing Table Partitioning in a Database : Managing table partition policy details : Creating table partition policy details
 

Creating table partition policy details

To create 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.
5. Review the following policy detail options:
*The Policy name setting is set to the name of the table partition policy.
*The Table setting is set to the name of table.
*The Policy type setting is set to one of the following:
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.
*The Default allocation setting is set to one of the following:
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.
7. Enter a unique value in the Values column.
8. Enter the Name and Description of the partition detail in the Name/Description column. Name is a mandatory field.
9. In the Allocation column:
*Select the Allocated option to allocate storage area in the database.
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.