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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—523725-004
5-51
Manage Partitions of Hash Partitioned Tables and
Indexes
Otherwise, the values of the primary partition apply.
partition-identification is optional only when the object has only one
partition.
partition-identification
describes the partition.
LOCATION partition
| {FIRST | LAST} PARTITION
| [KEY=] VALUE(partition-number)
is a location for a partition, or the partitioning key (the FIRST KEY) value
(key-value) of a partition, to be moved or dropped.
If you use partition-number, it must range from 0 to n-1, where n is the
number of partitions. VALUE(0) represents the first partition, VALUE(1) represents
the partition adjacent to the first partition, and so on. VALUE(n-1) represents the
last partition.
[\node.]$volume
| [\node.]$volume.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.
[TO] LOCATION new-partition
specifies the location of the new partition.
new-partition
is a disk volume or a Guardian file for the new partition. If you use disk volume
syntax, MODIFY generates the file suffix name part. The specified new
partition can be on the local system or a remote system.
partition-size
is the size of the new partition.
partition-extent-size [ MAXEXTENTS num-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 checks all partitions and uses the value
of the source partition.
partition-extent-size
is the extent size of the new partition.