SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Metadata Tables

HP NonStop SQL/MX Reference Manual—640322-001

10-55

Local Autonomy

This attribute controls how SQL/MX handles local autonomy:

Attribute Setting

SKIP_UNAVAILABLE_PARTITIO

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.