SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—523725-004
5-52
Manage Partitions of Hash 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 value of the source partition.
See EXTENT on page 8-6 and MAXEXTENTS on page 8-8.
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
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-8.