SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Metadata Tables
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
10-65
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-115.
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-115 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 OFF (the default value,) a
warning is displayed indicating that POS was not applied, and
a simple table is created without partitions. When set to ON,
an error is displayed indicating that location names could not
be generated.
The default is OFF.
Attribute Setting