Defining a partition policy record requires you to define the table being partitioned and the attributes of the partition listed in the following table:

Table 1. Partition policy record
Property Description
Policy name A unique name for the partition policy. Do not use spaces or special characters such as the asterisk (*), the ampersand (&), and the period ( . ).You can use the underscore (_) character in addition to alphanumeric.
Description A description of the partition policy.
Database connection The database connection name of a table-partitioning-enabled database.
Table The name of the table.
Default data area The default storage area for the table’s data.
Default index area The default storage area for the table’s indexes.
Default LOB area he default storage area for the table’s LOBs.
Allocation Object allocation rule
  • None — Set new partitions not to allocate space (default). Use this option if you want to allocate space individually to new partitions when you create them later by adding partition policy details to the policy.
  • Immediate — Set new partitions to allocate space. Use this option if you want to allocate space globally to new partitions when you create them later by adding partition policy details to the policy.
Has range The table partition type
  • No (unchecked in the OpenEdge Management wizard) — Indicates that the partition is a list partition or all list sub-partitions.
  • Yes (checked in the OpenEdge Management wizard) — Indicates that the partition or your last sub-partition is a range.
Partition fields Identifies the partition fields. You can easily select the fields with the Use Add field from table or Add fields from index to add partition fields. If a local index uses the selected field, the index appears in the Partition aligned indexes area.
Partition aligned indexes Identifies partition-aligned indexes to use in the partitioning.