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-278
Manage Partitions of Range Partitioned Tables and
Indexes
An operation is a postfix merge if the range of data ends at the bottom of the
partition. You can specify only the TO NEXT PARTITION clause. The split
partition cannot be the last partition (the rightmost partition in the list).
partition-size
is the size of the new partition.
partition-extent-size [ MAXEXTENTS max-extents ]
is the size of the new partition. You can specify the sizes of the primary and
secondary extents and the maximum number of extents. If you do not
specify MAXEXTENTS, MODIFY uses the value of the source 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 secondary extents separately. If you do
not specify EXTENT, MODIFY uses the extent size values of the source
partition.
See EXTENT on page 9-6 and MAXEXTENTS on page 9-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 ONCOMMITERROR
ROLLBACK WORK.
COMMIT [ WORK ] [ WHEN READY ] [on-error] }
[ [ AFTER time ] [ BEFORE time ]
time
is the time at which the commit phase should occur. The on-error clause
specifies what will happen if the Commit Phase fails with a retryable error. If the
time has already passed, MODIFY returns an error.
time is a quoted string datetime literal.
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.