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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—544517-008
5-75
Manage Partitions of Range Partitioned Tables and
Indexes
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 8-6 and MAXEXTENTS on page 8-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.
ROLLBACK [WORK]
specifies that the operation should be terminated. The effect is the same as issuing
a separate RECOVER command with the CANCEL option. ROLLBACK WORK
might only be specified in the last <on-error> clause.
ONCOMMITERROR commit-options
specifies what action SQL/MX should take if a retryable error occurs during
Commit Phase. Retryable errors include file in use, lock request timeouts, resource
unavailability, and BEFORE or AFTER time window misses.
A nonretryable error always causes SQL/MX to cancel changes to the database
and terminate the operation, no matter what you specify in the
ONCOMMITERROR option.
ONCOMMITERROR is recursive because it appears within a COMMIT option and
specifies another COMMIT option. You can specify up to three COMMIT options on
a single statement; specifying four or more causes an error.
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.