NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
S-92
Examples—SYSTEM
•
The following commands are not equivalent:
>> SYSTEM \local-node;
>> SYSTEM ;
The first command shown causes the network restrictions on file-name lengths to
take effect; the second command does not. See the Expand Network Management
Guide for information on network file-name lengths.
•
SYSTEM sets the node name qualifier in the =_DEFAULTS DEFINE. (You can also
change to a different default node by using the ALTER DEFINE =_DEFAULTS
command and changing the node specified for the VOLUME attribute.)
Examples—SYSTEM
•
The following command makes \SYS1 the default node:
>> SYSTEM \SYS1;
System DEFINEs
A system DEFINE is a DEFINE used in Tandem 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
Tandem documentation.)
SQL uses these system DEFINEs:
=_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 NonStop SQL/MP
software
=_SQL_EXE_USE_SWAPVO
L
Directs SQL to allocate temporary tables for serial plans
on the swap volume for the process