SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—523725-004
10-38
Default Attributes
For more information, see the description for the individual attribute.
SCRATCH_FREESPACE_
THRESHOLD_PERCENT
Amount of scratch space
left on disks as a
threshold.
Scratch Disk
Management on
page 10-60
SIMILARITY_CHECK
Determines whether
similarity checks are
made to either keep or
recompile an access plan.
Statement
Recompilation on
page 10-62
STREAM_TIMEOUT
Default time for a fetch
operation using stream
access to wait for more
rows before timing out.
Stream Access on
page 10-64
TABLELOCK
Default when table locks
are used.
Locking on page 10-45
TIMEOUT
Default time to wait for a
lock before NonStop
SQL/MX returns a timeout
error.
Locking on page 10-45
TEMPORARY_TABLE_
HASH_PARTITIONS
Specifies partitioning for
trigger temporary tables.
Trigger Management on
page 10-66
UDR_JAVA_OPTIONS
Specifies JVM startup
options for the Java
environment of an SPJ.
Stored Procedures in
Java on page 10-64
UPD_ORDERED
Controls whether rows
must be inserted,
updated, or deleted in
clustering key order.
Query Optimization and
Performance on
page 10-53
UPD_ABORT_ON_ERROR
Controls whether an
update, insert, or delete
function is aborted if an
error occurs.
Statement Atomicity on
page 10-62
UPD_SAVEPOINT_ON_ERROR
Controls whether DP2
savepoints should be
used and if the transaction
should be aborted in case
of an error.
Statement Atomicity on
page 10-62
VARCHAR_PARAM_
DEFAULT_SIZE
Controls the allowable
length of a LIKE
predicate.
Table Management on
page 10-65
ZIG_ZAG_TREES
Enables or disables the
optimizer to consider zig-
zag trees in addition to
linear trees.
Query Optimization and
Performance on
page 10-53
Attribute Description Category