SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—523725-004
5-48
Manage Partitions of Range Partitioned Tables and
Indexes
LOCATION [\node.]$volume[.subvolume.file-name]
| [KEY=] {FIRST | LAST} PARTITION
| [KEY=] key-value
is a location for a partition, or the partitioning key (the FIRST KEY) value
(key-value) of a partition, to be modified.
If the partition is the primary partition, you can also specify the partition using
the FIRST PARTITION phrase. If the partition is the rightmost partition in the
list of partitions of the table, you can use the LAST PARTITION phrase. You
can use either phrase to specify a partition if it is the only partition of the object.
[\node.]$volume
| [\node.]$volume.subvolume.file-name
is the physical location of a partition. If you do not specify the file name, only
one partition can exist for the given data source.
\node can be either the local node or a remote node. If you do not specify
\node, the default is the Guardian system named in your =_DEFAULTS define.
You can use the add-move-boundary-range clause to specify a range of
data in a partition (either the beginning part or the last part) to be split and then
merged into an adjacent and existing partition.
An operation is a prefix merge if the range of data begins from the top of the
existing partition. For a prefix merge operation, you can specify only the TO
PREVIOUS PARTITION clause. The split partition cannot be the primary
partition.
An operation is a postfix merge if the range of data ends at the bottom of the
partition. You can specify only the TO NEXT PARTITION clause. The split
partition cannot be the last partition (the rightmost partition in the list).
partition-size
is the size of the new partition.
partition-extent-size [ MAXEXTENTS max-extents ]
is the size of the new partition. You can specify the sizes of the primary and
secondary extents and the maximum number of extents. If you do not
specify MAXEXTENTS, MODIFY uses the value of the source partition.
partition-extent-size
is the extent size of the new partition.
EXTENT { ext-size }
{ (pri-ext-size, sec-ext-size) }
ext-size is an unsigned integer value. You can specify it as the size for
both primary and secondary extents of the new partition. You can specify