SQL/MX 2.x Installation and Management Guide (H06.04+)

Reviewing and Setting System Defaults
HP NonStop SQL/MX Installation and Management Guide—540436-001
6-6
System Default Settings to Review After Installing
SQL/MX Release 2.x
System Default Settings to Review After
Installing SQL/MX Release 2.x
Alternative Settings For Selected System Defaults
Table 6-3 lists the system defaults that you should consider changing after you install
SQL/MX Release 2.x and before you run your applications. For more information about
these and other system defaults, see the SQL/MX Reference Manual.
Table 6-2. New System Defaults for SQL/MX Release 2.1
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 have specified 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 =_ DEFAULTS environment variable (the default
volume) for the partition location.
If you enter a CREATE CATALOG statement without
specifying the LOCATION clause and you have
specified this system default, the location of the
catalog’s metadata is determined by picking one volume
from the specified list.
The default is no specification.
This attribute is available only to systems running
SQL/MX Release 2.1 or later.