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-12
Alternative Settings For Selected System Defaults
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-4. Alternative Settings for Selected System Defaults (page6of6)
System Default Default Value Alternative Setting