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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—544517-008
5-80
Manage Partitions of Hash Partitioned Tables and
Indexes
new-partition-name
is a SQL identifier for a partition.
partition-size
is the size of the new partition.
partition-extent-size [ MAXEXTENTS num-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 largest maxextents size possible using the
combination of primary, secondary and max extent values.
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 largest extent size possible using the combination
of primary, secondary and max extent values.
See EXTENT on page 8-6 and MAXEXTENTS on page 8-7.
When you add a hash partition, a subset of data from existing partitions is
redistributed to the new partition.
WITH SHARED ACCESS [commit-options]
specifies that the operation is an online operation. If commit-options is
omitted, the effect is the same as specifying COMMIT WHEN READY
TIMEOUT DEFAULT ONCOMMITERROR ROLLBACK WORK.
COMMIT [WORK] [ WHEN READY ] [on-error]
[ { AFTER time } ]
[ { BEFORE time } ]
specifies the time at which the Commit Phase should occur. COMMIT WHEN
READY specifies that the Commit Phase should occur at the earliest possible
time. COMMIT AFTER time specifies that the Commit Phase should occur
after the given time. COMMIT BEFORE <time> specifies that the Commit
Phase should occur before the given <time>. The on-error clause specifies
what should happen if the Commit Phase fails with a retryable error. If omitted,
the effect is the same as specifying TIMEOUT DEFAULT ONCOMMITERROR