SQL/MX 3.2 Management Manual (H06.25+, J06.14+)

Table 6 Settings for Selected System Defaults (page 1 of 5) (continued)
Alternative SettingDefault ValueSystem Default
behaves like RESTRICT; ON means that NO ACTION
behaves like RESTRICT, without warning or errors.
DDL is saved only if SAVE_DROPPED-TABLE_DDL is
set to the default ON setting. HP recommends that
The default value is ON.SAVE_DROPPED_TABLE_DDL
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”
(page 237).
Set to a list of scratch disk volumes, where each item
in the list has the form \node.$volume, and the items
The default is for the system
to determine what disks to
use.
SCRATCH_DISKS
in the list are separated by a comma (,). Use this
default to restrict scratch disks to the volumes
specified.
Set to a list of scratch disk volumes, where each item
in the list has the form \node.$volume, and the items
The default is for the system
to determine what disks to
use.
SCRATCH_DISKS_ EXCLUDED
in the list are separated by a comma (,). Use this
default to exclude certain volumes from being used
for scratch disks.
Set to a list of scratch disk volumes, where each item
in the list has the form \node.$volume, and the items
The default is for the system
to determine what disks to
use.
SCRATCH_DISKS_ PREFERRED
in the list are separated by a comma (,). Use this
default to indicate preference for volumes to be used
for scratch disks.
Set to a list of disk volumes, where each item in the
list has the form \node.$volume, and the items in the
The default value is the
current default location of the
creator of the first trigger.
TEMPORARY_TABLE_
HASH_PARTITIONS
list are separated by a comma (,). Use this default
to indicate how the triggers temporary tables are to
be hash-partitioned.
The time in hundredths of seconds to wait for a lock
before returning an error. The range of values you
The default is 6000 in
hundredths of seconds, which
is equivalent to 60 seconds.
TIMEOUT
can enter is from -1 to 2147483519. The value -1
directs NonStop SQL/MX not to time out. The value
0 directs NonStop SQL/MX not to wait for a table
lock. If the lock cannot be acquired, an error is
returned immediately.
Set to OFF to specify no application-specific JVM
startup options in the SPJ environment. Set to
The default value is OFF.UDR_JAVA_OPTIONS
ANYTHING to enable NonStop SQL/MX to select
the JVM startup options for an SPJ environment. CALL
statements compiled with this setting are serviced in
an SPJ environment chosen by NonStop SQL/MX.
Set to a value from 1 to 4096 to change the default
length of untyped parameters converted to the
VARCHAR type during compilation of a query.
The default value is 255
characters.
VARCHAR_PARAM_DEFAULT_
SIZE
70 Reviewing and Setting System Defaults