ODBC Server Installation and Management Manual

Installing the NonStop ODBC Server
HP NonStop ODBC Server Installation and Management Manual—429395-002
2-57
Configuring SQL/MP
The DEFINEs are set in the ZNSDEF table during configuration, either by the
NOSCOM interface to NOSUTIL or by the NonStop ODBC Server Configuration
Manager. When the SCS process is started, it inherits the DEFINEs. When SCS
creates NonStop ODBC servers, they inherit the DEFINEs, and when a NonStop
ODBC server starts a SQL/MP compiler process, it inherits the DEFINEs. Thus, the
DEFINEs apply to all of the NonStop ODBC servers run under the given SCS.
Two DEFINEs commonly used with the NonStop ODBC Server are as follows:
•
=_SQL_CMP_PARALLEL_ON enables SQL/MP parallel execution.
The SQL/MP compiler recognizes the presence of this DEFINE. If it exists, parallel
execution is enabled. Enabling parallel execution causes the compiler to consider,
but not necessarily choose, a parallel plan.
NOSUTIL sets this DEFINE automatically at the time the SCS is started.
•
=_SQL_EXE_STOP_SORTPROGS terminates sort processes.
The SQL/MP executor recognizes the presence of this DEFINE. If it exists, the
executor stops all sort processes started on behalf of a cursor whenever the cursor
is closed.