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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—540440-003
5-56
Manage Partitions of Hash Partitioned Tables and
Indexes
specify MAXEXTENTS, MODIFY checks all partitions and 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 value of the source
partition.
See EXTENT on page 8-6 and MAXEXTENTS on page 8-7.
ADD [PARTITION]
[TO] LOCATION new-partition [partition-size]
is the volume new-partition for the added partition.
[TO] LOCATION new-partition
specifies the location of the new partition.
new-partition
is a disk volume or a Guardian file for the new partition. If you use disk volume
syntax, MODIFY generates the file suffix name part. The specified new
partition can be on the local system or a remote system.
The new partition becomes the last partition of the table or index.
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