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-10
Alternative Settings For Selected System Defaults
REF_CONSTRAINT_NO_
ACTION_LIKE_RESTRICT
The default
value is
SYSTEM.
This default affects the behavior of a
new referential constraint specified
with NO ACTION.
OFF means that SQL issues error
1301; SYSTEM means that SQL
issues warning 1302 saying that it
behaves like RESTRICT; ON means
that NO ACTION behaves like
RESTRICT, without warning or
errors.
SAVE_DROPPED_TABLE_DDL The default
value is ON.
DDL is saved only if
SAVE_DROPPED-TABLE_DDL is
set to the default ON setting. HP
recommends that you do not
change this default value in
production environments. In
development and testing
environments, or for specific
applications where tables are
frequently created and dropped, it is
recommended that the value be set
to OFF. Under these conditions,
DDL files accumulate quickly and
there is no automated cleanup
mechanism. For more information,
see Removing Unneeded DDL Files
on page 12-8.
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.
Table 6-3. Alternative Settings for Selected System Defaults (page4of5)
System Default Default Value Alternative Setting