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-5
New System Defaults for Release 2.0
SCRATCH_FREESPACE_
THRSHOLD_PERCENT
Indicates how much free space, as a percentage, is left
on a disk as a threshold.
TEMPORARY_TABLE_HASH_
PARTITIONS
Controls the partitioning scheme for triggers temporary
tables.
UPD_ABORT_ON_ERROR Controls whether an error that occurs during the
performance of an insert, update, or delete causes an
abort.
UDR_JAVA_OPTIONS Specifies Java Virtual Machine (JVM) startup options for
the Java environment of a stored procedure in Java
(SPJ).
VARCHAR_PARAM_DEFAULT_
SIZE
Controls the allowable length of a LIKE predicate.
Table 6-1. New System Defaults for Release 2.0 (page 3 of 3)
Default Description