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-7
System Default Settings to Review After Installing
SQL/MX Release 2.x
System Default Settings to Review After
Installing SQL/MX Release 2.x
Alternative Settings For Selected System Defaults
Table 6-4 lists the system defaults that you should consider changing after you install
SQL/MX Release 2.x and before you run your applications. For more information about
these and other system defaults, see the SQL/MX Reference Manual.
Table 6-4. Alternative Settings for Selected System Defaults (page1of6)
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.