SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Metadata Tables
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
10-44
Default Attributes
MAX_ROWS_LOCKED_
FOR_STABLE_ACCESS
Maximum number of rows
that are locked in STABLE
ACCESS mode.
Locking on page 10-58
MDAM_SCAN_METHOD
Enables or disables the
MultiDimensional Access
Method.
Query Optimization and
Performance on
page 10-68
MEMORY_USAGE_SAFETY_NET
Specifies the MXCMP
memory threshold in
megabyte.
Query Optimization and
Performance on
page 10-68
MIN_MAX_OPTIMIZATION
Enables or disables MIN-
MAX optimization.
Query Optimization and
Performance on
page 10-68
MP_SUBVOLUME
Default NonStop operating
system Guardian
subvolume.
Object Naming on
page 10-62
MP_SYSTEM
Default NonStop operating
system Guardian system
name.
Object Naming on
page 10-62
MP_VOLUME
Default NonStop operating
system Guardian volume.
Object Naming on
page 10-62
MSCF_ET_REMOTE_MSG_
TRANSFER
Factors in the cost of
transferring messages to
and from a remote node.
Query Optimization and
Performance on
page 10-68
MULTIUNION
Controls the MultiUnion
operator.
Query Optimization and
Performance on
page 10-68
MXCMP_PLACES_LOCAL_
MODULES
Determines where
globally placed modules
are generated.
Module Management
on page 10-61
NAMETYPE
Default for the use of
three-part logical names
(ANSI) or four-part
Guardian names (NSK).
Object Naming on
page 10-62
NATIONAL_CHARSET
Default character set for
the use of NCHAR.
Character Set on
page 10-50
NOT_NULL_CONSTRAINT_
DROPPABLE_OPTION
Default for DROPPABLE
(ON) or NOT
DROPPABLE for NOT
NULL constraint.
Constraint Droppable
Options on page 10-51
NUMBER_OF_USERS
Number of users that can
run concurrent queries
that use large amounts of
memory.
Query Optimization and
Performance on
page 10-68
Attribute (page 5 of 9) Description Category