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

Metadata Tables
HP NonStop SQL/MX Reference Manual—544517-008
10-54
Partition Management
The TACL command INFO DEFINE =_DEFAULTS can be used to look at the
default volume and subvolume for the current TACL session. For more information
on the =_DEFAULTS define, see the Guardian Programmer’s Guide.
Partition Management
These attributes are used by NonStop SQL/MX for partition management:
Attribute Setting
DDL_DEFAULT_
LOCATIONS
Physical location of the primary range partition to be created
by CREATE statements that do not specify a LOCATION
clause, specified as [\node.]$volume. You can specify
multiple locations separated by commas.
If you enter a CREATE TABLE or CREATE INDEX statement
without specifying a LOCATION clause and you have
specified this default, the location is determined by picking
one volume from the specified list.
If the statement does not have a LOCATION clause and you
do not specify this default or set it to space (" "), NonStop
SQL/MX uses the value of the =_DEFAULTS environment
variable (the default volume) for the partition location.
If you enter a CREATE CATALOG statement without
specifying a LOCATION clause and you have specified this
default, the location of the catalog's metadata is determined
by picking one volume from the specified list.
The default is no specification.
Note: This attribute is available only to systems running
NonStop SQL/MX Release 2.1 or later.
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 4294967295, SYSTEM.
The default is 3.