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-290
Considerations for MODIFY
•
You can run MODIFY as either an offline or online operation. You can perform
online operations while the partition is being used by another application. You can
perform offline operations only on partitions that are not being used by other
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 DDL Locks on page 2-9.
•
MODIFY records the status of the operation in the DDL_LOCKS metadata table.
You can query this table to determine the progress of MODIFY operation.
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 the following object types:
•
System-clustered tables
•
Range partitioned tables and indexes where the partitioning key is not a prefix of
the clustering key
•
Sequence generators
Status Description
1 The DDL Lock row is created.
2 The target partition is created.
3 Data is copied.
4 Copying of data is in progress.
5 Partition is marked as offline.
6 Partition is purgedata’ed and marked corrupt.
7 ORSERV is about to be started for MODIFY.
8 ORSERV is started for MODIFY.
9 ORSERV is about to be started for RECOVER
10 ORSERV is started for RECOVER.