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-9
Alternative Settings For Selected System Defaults
QUERY_CACHE_REQUIRED_
PREFIX_KEYS
The default
value is 255.
A value greater than the number of
columns in a composite key
indicates all columns of the key are
required. The value 0 means that
the presence of any one column of a
composite primary or partition key in
an equality key predicate is
sufficient to make that predicate
cacheable. A value greater than
zero but less than the number of
columns in the key indicates that the
first n columns of the key must be
present in a key predicate for that
predicate to be considered
cacheable.
QUERY_CACHE_
STATEMENT_PINNING
The default
value is OFF.
The value CLEAR means that all
subsequent query cache entries are
unpinned, and all pinned entries in
the cache are also unpinned. The
value ON means that all subsequent
query cache entries into the cache
are pinned.
RECOMPILATION_WARNINGS The default
value is OFF.
The value ON means that NonStop
SQL/MX generates a warning when
a statement is automatically
recompiled in an application
(because of various factors). A
warning is also generated when a
similarity check passes. Set this
default to ON only if your application
needs to receive warning messages
when automatic recompilations take
place, or if it needs to know if a
similarity check has passed. When
automatic recompilation occurs,
NonStop SQL/MX always logs an
EMS event regardless of the setting
of this CQD.
The value OFF means that NonStop
SQL/MX will not generate this
warning.
Table 6-3. Alternative Settings for Selected System Defaults (page3of5)
System Default Default Value Alternative Setting