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

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
10-53
Partition Management
POS_LOCATIONS Physical locations of nonprimary partitions to be automatically
created, specified as [\node.]$volume. You can specify
multiple locations separated by commas.
If you enter a space (“ “), NonStop SQL/MX chooses the
locations of the second through last partitions at random.
NonStop SQL/MX does not place partitions on these types of
disks: audit trail volumes, nonaudited disks, optical disks,
phantom disks, or SMS virtual disks.
See Creating Partitions Automatically
on page 2-89.
The default is no specification.
POS_NUM_OF_PARTNS Number of partitions to be automatically created. If the value
is greater than 1, NonStop SQL/MX creates that many
partitions, including the primary partition.
A value of 1 or 0 indicates that Partition Overlay Support
(POS) is disabled.
See Creating Partitions Automatically
on page 2-89 for
details.
The default is 1.
POS_RAISE_ERROR Determines whether an error should be raised when the POS
feature cannot generate location names for the partitions to
be created or if a warning should be raised indicating that the
POS feature was not applied, and a simple table is created
without partitions. When set to 0 (the default value,) a warning
is displayed indicating that POS was not applied, and a
simple table is created without partitions. When set to 1, an
error is displayed indicating that location names could not be
generated.
The default is 0.
Attribute Setting