SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
P-16
PARTITION Clause
PARTITION Clause
PARTITION is a clause on the ALTER INDEX, ALTER TABLE, CREATE INDEX, and
CREATE TABLE statements that defines secondary partitions for a table or index.
[\node.][$volume.][subvol.]object
is the name of a secondary partition. Each fully expanded partition name must be
unique in the network, but must have the same subvolume and simple object name
as the index or table being partitioned.
CATALOG catalog
specifies the name of a catalog to contain the description of the partition. The
catalog must be on the same node as the partition. The default is the current
default catalog.
PHYSVOL volume-name
specifies a physical volume on which to place the secondary partition if SMF is
installed on your node. This option overrides SMF. volume-name can be either the
name of a physical volume or equivalent DEFINE.
Do not include the node name in your volume name.
This option is available only if you specify a virtual volume for partition.
volume-name must belong to the virtual volume you specify.
EXTENT { size | ( pri-size[,sec-size] ) }
specifies the EXTENT file attribute for the partition. For more information, see
EXTENT File Attribute on page E-30.
PARTITION ( partition [ , partition ] ... )
partition is:
[\node.][$volume.][subvol.]object
[| CATALOG catalog |]
[| PHYSVOL volume-name |]
[| EXTENT { size | ( pri-size[,sec-size] ) } |]
[| MAXEXTENTS integer |]
[| { FORMAT 1 | FORMAT 2 } |]
[ FIRST KEY { value } ]
{ ( value [ , value ] ... ) }