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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—540440-003
5-53
Manage Partitions of Hash Partitioned Tables and
Indexes
the size of the primary extent and secondary extents separately. If you do
not specify EXTENT, MODIFY uses the extent size values of the source
partition.
See EXTENT on page 8-6 and MAXEXTENTS on page 8-7.
WITH SHARED ACCESS [commit-options]
specifies that the operation is an online operation. If you do not specify
commit-options, the default is COMMIT WHEN READY.
COMMIT [ WORK ] [ WHEN READY ]
[ { AFTER time } ]
[ { BEFORE time } ]
time
is the time at which the commit phase should occur. If the time has already passed,
MODIFY returns an error.
time is a quoted string datetime literal.
Manage Partitions of Hash Partitioned Tables and Indexes
Use MODIFY to manage hash partitions of SQL/MX tables and indexes.You can drop
only the last partition. You must manage tables and indexes separately regardless of
whether they are related. Only offline partition operations are supported.
WHEN READY Commit phase should occur at the earliest possible time.
AFTER time Commit phase should occur after time.
BEFORE time Commit phase should occur before time.
The form of MODIFY for hash partitioned tables and indexes is:
MODIFY {TABLE | INDEX} [[catalog.]schema.]object
{drop | move | add}
drop is:
DROP [PARTITION] WHERE partition-identification
move is:
MOVE [PARTITION] [WHERE partition-identification]
[TO] LOCATION new-partition [partition-size]
add is:
ADD [PARTITION] [TO] LOCATION new-partition [partition-size]
partition-identification is:
LOCATION [\node.]$volume[.subvolume.file-name]
| {FIRST | LAST} PARTITION
| [KEY=] VALUE(partition-number)