SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—544517-008
5-78
Manage Partitions of Hash Partitioned Tables and
Indexes
[\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.
MOVE [PARTITION] [WHERE partition-identification]
[TO] LOCATION new-partition
[NAME new-partition-name]
[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.