SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
X-2
=_AUDSERV_XSWAP_node DEFINE
=_AUDSERV_XSWAP_node DEFINE
=_AUDSERV_XSWAP_node is a system DEFINE that specifies a swap volume for the
audit fix-up process on the specified node.
node
is the name of the node (without the usual leading “\”) for which the swap volume
of the audit fix-up process is to be set.
volume
is the name of the swap volume for the audit fix-up process on the node.
Consideration—=_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.
Example—=_AUDSERV_XSWAP_node

These 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;
ADD DEFINE =_AUDSERV_XSWAP_node, CLASS MAP, FILE volume