NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
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
If ServerWare SMF is installed on your node, specifies a physical volume on which
to place the secondary partition. This option overrides ServerWare SMF. volume-
name can be either the name of a physical volume or equivalent DEFINE.
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. See EXTENT File Attribute on
page E-32 for more information.
MAXEXTENTS integer
specifies the MAXEXTENTS file attribute for the partition. See MAXEXTENTS
File Attribute on page M-2 for more information.
PARTITION ( partition [ , partition ] ... )
partition is:
[\node.][$volume.][subvol.]object
[| CATALOG catalog |]
[| PHYSVOL volume-name |]
[| EXTENT { size | ( pri-size[,sec-size] ) } |]
[| MAXEXTENTS integer |]
[ FIRST KEY { value } ]
{ ( value [ , value ] ... ) }