SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—544517-008
10-49
Local Autonomy
Local Autonomy
This attribute controls how SQL/MX handles local autonomy:
Module Management
This attribute determines where globally placed modules are generated:
Attribute Setting
SKIP_UNAVAILABLE_PARTITIO
N
This attribute provides local autonomy for certain
situations by directing SQL/MX to continue processing a
query even if partitions required for the access plan of
the query are not available. This attribute applies to
partitioned tables, but affects only the main query in a
SELECT statement without INTO clause. (SQL always
stops processing and returns an error when a required
partition is unavailable for a SELECT statement in the
search condition of UPDATE or DELETE statement, or
any other DDL or DML statement.)
If set to ON, SQL/MX continues processing the query
even if one or more partitions required for the query
plan are not available. A warning message is displayed
for each partition that is unavailable. For certain simple
SQL queries, such as, single table unique select,
SQL/MX enables Online Transaction (OLT) optimization.
In such cases, this CQD has no impact. For more
information about OLT optimization, see the SQL/MX
query guide.
If set to OFF, an error is displayed indicating that
partition is not available.
The default setting is OFF.
Attribute Setting
MXCMP_PLACES_LOCAL_
MODULES
Set to ON or OFF.
If OFF, NonStop SQL/MX generates global modules in
the USERMODULES directory.
If ON and you do not specify
mxcmp -g moduleLocal=OSS-dir
on the command line, compiled modules are placed in
the current OSS directory.
If ON and you specify
mxcmp -g moduleLocal=OSS-dir
on the command line, compiled modules are placed in
the OSS-dir directory.
The default is OFF.
For more information about module management, see
the SQL/MX Programming Manual for C and COBOL.