SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—544517-008
10-55
Partition Management
GEN_MAX_NUM_PART_
NODE_ENTRIES
When a statically compiled statement references partitioned
objects, this default is used to control the size of a partition list
prepared by the compiler and used by the executor when it
first opens the object, to support node and disk autonomy. If
some of the nodes and volumes across which an object is
partitioned are offline, the executor can attempt to open a
partition on another node and volume given by an entry in the
partition list. This default specifically controls the maximum
number of nodes for which there will be one or more entry in
the list. You can limit the number of nodes on which the
executor attempts to find an available partition, by setting this
default to a low value.
Allowable values: 0 - 4294967295, SYSTEM.
The default is 255.
PM_OFFLINE_
TRANSACTION_
GRANULARITY
Number of rows to be copied in an offline MODIFY
transaction. This attribute enables partition operations, which
can involve large amounts of data, to be done in many
separate, smaller transactions.
Allowable values: 50 to 4194303, inclusively.
The default is 5000.
PM_ONLINE_
TRANSACTION_
GRANULARITY
Number of rows to be copied in an online MODIFY
transaction. This attribute enables partition operations, which
can involve large amounts of data, to be done in many
separate, smaller transactions.
Allowable values: 50 to 4194303, inclusively.
The default is 400.
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-93.
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-93 for
details.
The default is 1.
Attribute Setting