SQL/MX 3.x Installation and Management Guide (H06.22+, J06.11+)

Reviewing and Setting System Defaults
HP NonStop SQL/MX Installation and Management Guide—640325-001
6-4
Alternative Settings For Selected System Defaults
NATIONAL_CHARSET The default
value is UCS2.
The value ISO88591 is appropriate
if ISO88591 is the preferred national
character set.
A value for NATIONAL_CHARSET
is set when you run the
InstallSqlmx script during
installation of NonStop SQL/MX.
This value can be changed only by
reinstalling NonStop SQL/MX. For
more information, see Section 3,
Installing NonStop SQL/MX.
NOT_NULL_CONSTRAINT_
DROPPABLE_OPTION
The default
value is OFF.
The value ON means that, by
default, a NOT NULL column
constraint is DROPPABLE.
PRESERVE_MIN_SCALE The default
value is 0.
A value from 0 to 18 specifies the
minimum scale for the result of an
arithmetic operation when the
precision exceeds 18.
PRIMARY_KEY_CONSTRAINT_
DROPPABLE_OPTION
The default
value is OFF.
The value ON means that, by
default, a PRIMARY KEY column
constraint is DROPPABLE.
QUERY_CACHE The default
value is 1024.
The value 0 deactivates the query
cache in the current session.
QUERY_CACHE_MAX_
VICTIMS
The default
value is 10.
A very large value means that all the
cache entries could be displaced to
accommodate one very large query.
A value of 0 means that, when the
cache becomes full, no cache
entries (pinned or unpinned) can be
displaced, and no new entries can
be entered into the cache.
Table 6-1. Settings for Selected System Defaults (page 2 of 5)
System Default Default Value Alternative Setting