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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—544517-008
5-76
Manage Partitions of Hash Partitioned Tables and
Indexes
RECLAIM | NO RECLAIM
specifies whether SQL/MX should automatically start ORSERV processes to
reclaim unused freespace in affected partitions (RECLAIM) or whether the user
must manually perform FUP RELOAD operations (NO RECLAIM). Partitions that
contain unused freespace have the UNRECLAIMEDSPACE (F) flag set in the file
label. Until the freespace is reclaimed, the flag remains set and any new MODIFY,
DUP, or BACKUP operation you attempt to perform on the object will fail with error
20290 (operation still in progress). DML operations can be performed on the
object, but all other operations will fail. If omitted, the default for range partitioned
objects is RECLAIM. The option will be ignored in situations where MODIFY does
not need to reclaim freespace.
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.
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
[RECLAIM | NO RECLAIM]
[with-shared-access]
move is:
MOVE [PARTITION] [WHERE partition-identification]
[TO] LOCATION new-partition
[NAME new-partition-name]
[partition-size]
[RECLAIM | NO RECLAIM]
[with-shared-access]
add is:
ADD [PARTITION] [TO] LOCATION new-partition
[NAME new-partition-name]
[partition-size]
[RECLAIM | NO RECLAIM]
[with-shared-access]
partition-identification is:
LOCATION [\node.]$volume[.subvolume.file-name]
| NAME partition-name
| {FIRST | LAST} PARTITION
| [KEY=] VALUE(partition-number)