SQL/MX 2.x Reference Manual (H06.04+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
10-39
Default Attributes
SCRATCH_FREESPACE_
THRESHOLD_PERCENT
Amount of scratch space
left on disks as a
threshold.
Scratch Disk
Management on
page 10-62
SIMILARITY_CHECK
Determines whether
similarity checks are
made to either keep or
recompile an access plan.
Statement
Recompilation on
page 10-64
SORT_MAX_HEAP_SIZE_MB
Allocates a default value
to the heap memory size
for operations involving
the sort operator.
Query Optimization and
Performance on
page 10-54
STREAM_TIMEOUT
Default time for a fetch
operation using stream
access to wait for more
rows before timing out.
Stream Access on
page 10-66
TABLELOCK
Default when table locks
are used.
Locking on page 10-46
TEMPORARY_TABLE_
HASH_PARTITIONS
Specifies partitioning for
trigger temporary tables.
Trigger Management on
page 10-68
TIMEOUT
Default time to wait for a
lock before NonStop
SQL/MX returns a timeout
error.
Locking on page 10-46
UDR_JAVA_OPTIONS
Specifies JVM startup
options for the Java
environment of an SPJ.
Stored Procedures in
Java on page 10-66
UPD_ORDERED
Controls whether rows
must be inserted,
updated, or deleted in
clustering key order.
Query Optimization and
Performance on
page 10-54
UPD_ABORT_ON_ERROR
Controls whether an
update, insert, or delete
function is aborted if an
error occurs.
Statement Atomicity on
page 10-64
Attribute Description Category