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

Reviewing and Setting System Defaults
HP NonStop SQL/MX Installation and Management Guide—544536-007
6-11
Alternative Settings For Selected System Defaults
SCRATCH_DISKS The default is for
the system to
determine what
disks to use.
Set to a list of scratch disk volumes,
where each item in the list has the
form \node.$volume, and the
items in the list are separated by a
comma (,). Use this default to
restrict scratch disks to the volumes
specified.
SCRATCH_DISKS_
EXCLUDED
The default is for
the system to
determine what
disks to use.
Set to a list of scratch disk volumes,
where each item in the list has the
form \node.$volume, and the
items in the list are separated by a
comma (,). Use this default to
exclude certain volumes from being
used for scratch disks.
SCRATCH_DISKS_
PREFERRED
The default is for
the system to
determine what
disks to use.
Set to a list of scratch disk volumes,
where each item in the list has the
form \node.$volume, and the
items in the list are separated by a
comma (,). Use this default to
indicate preference for volumes to
be used for scratch disks.
TEMPORARY_TABLE_
HASH_PARTITIONS
The default
value is the
current default
location of the
creator of the
first trigger.
Set to a list of disk volumes, where
each item in the list has the form
\node.$volume, and the items in
the list are separated by a comma
(,). Use this default to indicate how
the triggers temporary tables are to
be hash-partitioned.
Table 6-4. Alternative Settings for Selected System Defaults (page5of6)
System Default Default Value Alternative Setting