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-7
Default Settings to Review After Installing NonStop
SQL/MX
Default Settings to Review After Installing
NonStop SQL/MX
Alternative Settings For Selected System Defaults
Table 6-3 lists the system defaults that you should consider changing after you install
NonStop SQL/MX and before you run your applications.
Table 6-3. Alternative Settings for Selected System Defaults (page1of5)
System Default Default Value Alternative Setting
CACHE_HISTOGRAMS The default
value is ON.
The value OFF means histograms
are only fetched for columns of a
table that are involved in a
statement.
CACHE_HISTOGRAMS_
REFRESH_INTERVAL
The default
value is 3600.
A value of less than 3600 seconds
means the cached histograms are
refreshed more frequently than once
per hour.
DP2_CACHE_4096_BLOCKS The default
value is 1024.
You should set the value of this
attribute to the average value of
4KB block disk cache settings for all
volumes in the system.
FFDC_DIALOUTS_FOR_
MXCMP
The default
value is OFF.
The value ON allows FFDC
dial-outs to occur when the compiler
terminates abnormally or detects an
internal error.
FLOATTYPE The default
value is
TANDEM.
The value IEEE means that the
IEEE float format is to be used.
HIST_SCRATCH_VOL For SQL/MX
tables, the
default is the
volume specified
by the
_DEFAULTS
define. For
SQL/MP tables,
the default is the
volume of the
table’s primary
partition.
Any disk volume to be used tor
UPDATE STATISTICS temporary
files.