NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
Z-2
Considerations—=_AUDSERV_XSWAP_node
volume
is the name of the swap volume for the audit fix-up process on the node.
Considerations—=_AUDSERV_XSWAP_node
•
An operation that uses the WITH SHARED ACCESS option starts an audit fix-up
process on each node in the network that contains at least one source object used in
the operation. (There might be more than one node for CREATE INDEX operations
on network-partitioned tables.) The default swap volume for an audit fix-up process
is the volume that contains the program file for the process.
Because an audit fix-up process generates a large swap file, you might want to
specify an alternate swap volume for such a process with the
=_AUDSERV_XSWAP_node DEFINE.
Examples—=_AUDSERV_XSWAP_node
•
The following SQLCI commands specify swap volumes for audit fix-up processes
on nodes \REG1 and \REG2:
>>ADD DEFINE =_AUDSERV_XSWAP_REG1, CLASS MAP, FILE
\REG1.$SCR;
>>ADD DEFINE =_AUDSERV_XSWAP_REG2, CLASS MAP, FILE
\REG2.$VM3;
=_DEFAULTS DEFINE
=_DEFAULTS is a system DEFINE that specifies the current default node, volume,
subvolume, and catalog. =_DEFAULTS determines how to expand partially qualified
Guardian names.
=_DEFAULT always has a VOLUME attribute that specifies the current default volume
and subvolume. If =_DEFAULT has a CATALOG attribute, that attribute specifies the
current default SQL catalog; if not, the VOLUME attribute specifies the subvolume that
is the current default SQL catalog.
You cannot rename or delete the =_DEFAULTS DEFINE, but you can display and alter
it.
CATALOG [\node.][$volume.]subvolume
sets the current default catalog, which is used wherever a catalog name is required
but no CATALOG clause is supplied, such as in DDL statements or in the SQL
compiler command.
ALTER DEFINE =_DEFAULTS,
{| CATALOG [\node.][$volume.]subvolume |}
{| |}
{| VOLUME [\node.][$volume.]subvolume |} ;