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-5

New System Default for SQL/MX Release 2.1

Table 6-2 describes the DDL_DEFAULT_LOCATIONS system default, which is

supported by SQL/MX Release 2.1 or later. For information on using

DDL_DEFAULT_LOCATIONS to specify one or more default volumes for the primary

range partition in a CREATE statement that does not include a LOCATION clause, see

Using DDL_DEFAULT_LOCATIONS to Distribute Primary Range Partitions on

page 7-19.

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.

Note. This attribute is available only to systems running SQL/MX Release 2.1 or a later

release of NonStop SQL/MX.

Table 6-1. New System Defaults for SQL/MX Release 2.0 (page 3 of 3)

Default Description