SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Reviewing and Setting System Defaults

HP NonStop SQL/MX Installation and Management Guide—523723-004

6-6

New System Default for Release 2.1

Table 6-2 describes the DDL_DEFAULT_LOCATIONS system default, which is new

for Release 2.1. For information on using DDL_DEFAULT_LOCATIONS to specify one

or more default volumes for the primary range partition in a CREATE statement that

does not include a LOCATION clause, see Using DDL_DEFAULT_LOCATIONS to

Distribute Primary Range Partitions on page 7-17.

Note. This attribute is available only to systems running Release 2.1 (SPR equivalent is ABU).

Table 6-2. New System Defaults for Release 2.2

Default Description

DDL_DEFAULT_LOCATIONS The physical location of the primary range partition to be

created by CREATE statements that do not provide 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 specify this system 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 =_ default

environment variable (the default volume).

If you enter a CREATE CATALOG statement without

specifying the LOCATION clause and you specify this

default, the location of the catalog’s metadata 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 =_ default

environment variable (the default volume) for the

metadata location.

The default is no specification.