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-11
Alternative Settings For Selected System Defaults
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.
TIMEOUT The default is
6000 in
hundredths of
seconds, which
is equivalent to
60 seconds.
The time in hundredths of seconds
to wait for a lock before returning an
error. The range of values you 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.
UDR_JAVA_OPTIONS The default
value is OFF.
Set to OFF to specify no application-
specific JVM startup options in the
SPJ environment. Set to
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.
VARCHAR_PARAM_DEFAULT_
SIZE
The default
value is 255
characters.
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.
Table 6-3. Alternative Settings for Selected System Defaults (page5of5)
System Default Default Value Alternative Setting