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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—540440-003
5-58
Considerations for MODIFY
extents the partition can have. If you do not specify MAXEXTENTS, MODIFY uses
the value of the primary partition.
partition-extent-size
is the extent size of the new partition
EXTENT { ext-size }
{ (pri-ext-size, sec-ext-size) }
ext-size is an unsigned integer value. You can specify it as the size for both
primary and secondary extents of the new partition. You can specify the size of the
primary extent and that of secondary extents separately. If you do not specify
EXTENT, MODIFY uses the extent size values of the largest partition.
See EXTENT on page 8-6 and MAXEXTENTS on page 8-7.
Considerations for MODIFY
•
You must be the owner of a schema to run MODIFY against it.
•
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’s 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-3.
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:
•
Hash partitioned tables and indexes
•
System-clustered tables
•
Range partitioned tables and indexes where the partitioning key is not a prefix of
the clustering key