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-8
Alternative Settings For Selected System Defaults
NAMETYPE The default
value is ANSI.
The value NSK is appropriate if the
system uses physical Guardian
names (NSK). The NSK setting
applies to the resolution of
unqualified SQL/MP object names.
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-3. Alternative Settings for Selected System Defaults (page2of5)
System Default Default Value Alternative Setting