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

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
10-52
Partition Management
GEN_MAX_NUM_PART_
DISK_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 is 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 volumes per node for which there will be an entry
in the list. You can limit the number of partitions that the
executor attempts to open per node by setting this default to a
low value.
Allowable values: 0 through 4294967040, SYSTEM.
The default is 3.
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 - 4294967040, 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.
Attribute Setting