NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
Z-19
Examples—=_SQL_RECGEN_node
Examples—=_SQL_RECGEN_node
•
The following 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.)
syncdepth
is the keyword SYNC1 (if you want the temporary files to use SYNCDEPTH 1), or
a simple file name (if you want the temporary files to use SYNCDEPTH 0, as
usual).
The file name must be a legal Guardian file name, but the file is not used and does
not need to exist.
Considerations—=_SQL_TM_node_vol
•
You can use the =_SQL_TM_node_vol DEFINE to change the location of
temporary tables that might require more space than available on the volumes where
the temporary tables would normally be located, causing file-system error 122.
ADD DEFINE =_SQL_TM_node_vol, CLASS MAP,
FILE new-loc.syncdepth