SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—540440-003
5-55
Manage Partitions of Hash Partitioned Tables and
Indexes
MOVE [PARTITION] [WHERE partition-identification]
[TO] LOCATION new-partition [partition-size]
is an existing hash partition that is to be moved to a new location. You can define
the size of the new partition using the optional partition-size clause.
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.
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