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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—540440-003
5-54
Manage Partitions of Hash Partitioned Tables and
Indexes
[[catalog.]schema.]object
is the name of the object. If you do not specify the schema and catalog name,
MODIFY uses the current default schema and catalog of your MXCI session.
object is a table or an index, depending on the TABLE or INDEX keyword.
DROP [PARTITION] WHERE partition-identification
is the hash partition to be dropped. The specified partition must be the last partition
(the rightmost partition in the partition array).
partition-identification
describes the partition.
LOCATION [\node.]$volume[.subvolume.file-name]
| {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 dropped.
If you use the LOCATION clause, you must identify the last partition of the
table or index.
If you use partition-number, it must an unsigned integer and 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.
You cannot drop the primary hash partition (the FIRST PARTITON).
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.
new-partition is:
LOCATION [\node.]$volume[.subvolume.file-name]