SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
S-94
System DEFINEs
System DEFINEs
A system DEFINE is a DEFINE used in HP NonStop system software to identify
system defaults or configuration information.
Each system DEFINE name begins with an equal sign and an underscore (=_). This
special prefix is reserved for system DEFINE names. (Do not create DEFINE names
that begin with an equal sign and an underscore unless specifically directed to do so in
HP documentation.)
SQL uses these system DEFINEs:
For more information about a specific system DEFINE, see the entry for that DEFINE.
=_AUDSERV_XSWAP_node Specifies a swap volume for the audit fix-up process
on node
=_DEFAULTS Sets defaults for Guardian name expansion
=_SORT_DEFAULTS Specifies defaults for FastSort operations
=_SQL_CMP_EVENT Directs SQL to log SQL compiler event messages to
a file or home terminal
=_SQL_CMP_EVENT_NO0 Suppresses logging of SQL compiler event
messages to $0
=_SQL_cmp_node Identifies files for components of the SQL/MP
software
=_SQL_EXE_USE_SWAPV
OL
Directs SQL to allocate temporary tables for serial
plans on the swap volume for the process
=_SQL_MSG_node Sets file for SQL message text
=_SQL_RECGEN_node Specifies an alternate location for the FastSort
record generator
=_SQL_TM_node_vol Directs SQL to use another disk for temporary tables
normally allocated on the specified volume;
optionally opens the tables with SYNCDEPTH 1
instead of 0