SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
2-282
Manage Partitions of Hash Partitioned Tables and
Indexes
When you drop a hash partition, data from that partition is redistributed to
the remaining partitions.
[\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]
Moves an existing hash partition 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 [\node.]$volume[.subvolume.file-name]
| NAME partition-name
| [KEY=] {FIRST | LAST} PARTITION
| [KEY=] VALUE(partition-number)
is the 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 =_DEF
AULTS
define.
[TO] LOCATION new-partition
specifies the location of the new partition.