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

Editing table partition policy details

To edit 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. Double-click an existing partition policy detail to update the following options:
*In the Name/Description column, you can click the policy detail description to update it.
*In the Allocation column, you can set the Split-target and Read-only options.
*The Split-target option is editable for new table partition policy details. You can set this option for all policy details other than the final policy detail in the list.
*The Read-only option is editable only if the Allocated and Split-target options are selected. However, you cannot edit the Read-only option for a composite partition policy detail since a composite partition is set at the policy level.
*In the Default Areas column, you can set the Index and LOB values.
*In the Partitions column, you can click Partitions to set partitions for the policy detail. The Policy Detail Partitions dialog appears.
The Partitions option is available only if the Split-target option is set.
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.
This field is disabled if the partition policy has been allocated area during partition policy creation.
*Select the buffer pool in the Buffer pool list. The available options are Primary (default) and Alternate.
6. Click OK to apply the policy detail partition changes or Cancel to undo the changes.
7. Click Update to apply the changes to the partition policy or click Cancel to undo the changes.
8. Optionally, you can select a partition policy detail from the list and click Delete to delete the partition policy. Click Yes in the confirmation dialog.
Note: You can delete a partition policy only if the object-allocation rules are not allocated to the policy.