SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

SQL/MX Utilities
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
5-89
Considerations for MODIFY
applications or that are being used with READ access. WRITE access is
prohibited.
•
Most of MODIFY partition management operations ignore triggers. However, the
REUSE form of MODIFY returns an error if you use the PURGEDATA option on a
table with DELETE triggers and if there is data in the partition:
*** ERROR[20294] The partition cannot be reused because the
partition contains data and the table has an enabled DELETE
trigger.
•
If the MODIFY operation fails, use the RECOVER utility to undo or resume the
failed partition operation. For details, see Checking File Locks on page 5-4.
Online Partition Management
MODIFY supports online partition management for range partitioned tables and
indexes where the partitioning key is a prefix of the clustering key. Other processes
can read and write the object while it is being repartitioned, except during a short
period at the end when file labels and metadata are updated.
Online partition management is not supported for these types of tables and indexes:
•
System-clustered tables
•
Range partitioned tables and indexes where the partitioning key is not a prefix of
the clustering key
Offline Partition Management for Range Partitions
MODIFY supports these offline partition management operations for range partitions:
•
Adding a new empty partition.
•
Dropping an existing empty partition.
•
Moving an existing partition to a new location.
•
Splitting an existing partition and then moving the first or last part of the data to a
new partition.
•
Splitting an existing partition and then merging the first or last part of the data to an
existing adjacent partition.
•
Merging two adjacent partitions into one.
•
Reusing an existing partition by setting the FIRST KEY values of the partition to
new values. You can optionally remove existing data in the partition to be reused.
Offline Partition Management for Hash Partitions
MODIFY supports these offline partition management operations for hash partitions: