SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
X-20
=_SQL_RECGEN_node DEFINE
=_SQL_RECGEN_node DEFINE
=_SQL_RECGEN_node is a system DEFINE that allows a user with super ID authority
to specify an alternate location for the FastSort record generator program.
node
is the name of the node (without the usual leading backslash “\”) running the SQL
software that is to use the alternate FastSort record generator program.
Example—=_SQL_RECGEN_node
This SQLCI command specifies $DP1.TEST.RGP as the program file for the FastSort
record generator on node \REG1:
ADD DEFINE =_SQL_RECGEN_REGs, CLASS MAP, FILE $DP1.TEST.RGP;
=_SQL_TM_node_vol DEFINE
=_SQL_TM_node_vol is a system DEFINE that directs NonStop SQL/MP to create
temporary tables that would normally go to the specified volume on another specified
volume instead. Optionally, you can also use =_SYS_TM_node_vol to specify
SYNCDEPTH 1 for the redirected temporary files.
node
is the name of the node (without the usual leading “\”) from which to redirect
temporary files.
vol
is the name of the volume (without the usual leading “$”) from which temporary
files are to be redirected.
new-loc
is the name of the system, volume, and subvolume for the temporary files,
specified as a Guardian subvolume name (complete with a “\” preceding the node
name and “$” preceding the volume name).
The subvolume portion of the name is not actually used, but you must include it to
make the DEFINE syntactically correct. (Temporary files use names of the form
\node.$vol.#nnnn and do not use subvolume names.)
ADD DEFINE =_SQL_RECGEN_node, CLASS MAP, FILE prog-file
ADD DEFINE =_SQL_TM_node_vol, CLASS MAP,
FILE new-loc.syncdepth