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

MXCI Commands
HP NonStop SQL/MX Reference Manual—540440-003
4-66
Examples of SHOWCONTROL
MAX_ROWS_LOCKED_FOR_STABLE_ACCESS 1
MDAM_SCAN_METHOD ON
MIN_MAX_OPTIMIZATION ON
MIN_COALITIONS
MP_SUBVOLUME SKYOSTST
MP_SYSTEM \HPIDMR5
MP_VOLUME $DATA01
MSCF_ET_REMOTE_MSG_TRANSFER 0.00005
MV_AS_ROW_TRIGGER OFF
MV_REFRESH_MAX_PARALLELISM 1
MV_REFRESH_MAX_PIPELINING 1
MXCMP_PLACES_LOCAL_MODULES OFF
NAMETYPE ANSI
NATIONAL_CHARSET UCS2
NOT_NULL_CONSTRAINT_DROPPABLE_OPTION OFF
NUMBER_OF_USERS 1
OLT_QUERY_OPT ON
OPTIMIZATION_LEVEL 3
OPTS_PUSH_DOWN_DAM 0
PARALLEL_NUM_ESPS SYSTEM
PM_OFFLINE_TRANSACTION_GRANULARITY 5000
PM_ONLINE_TRANSACTION_GRANULARITY 400
POS_LOCATIONS
POS_NUM_OF_PARTNS 0
POS_RAISE_ERROR 0
PREFERRED_PROBING_ORDER_FOR_NESTED_JOIN OFF
PRESERVE_MIN_SCALE 0
PRIMARY_KEY_CONSTRAINT_DROPPABLE_OPTION OFF
QUERY_CACHE 1024
QUERY_CACHE_MAX_VICTIMS 10
QUERY_CACHE_REQUIRED_PREFIX_KEYS 255
QUERY_CACHE_STATEMENT_PINNING OFF
READONLY_CURSOR TRUE
RECOMPILATION_WARNINGS OFF
REF_CONSTRAINT_NO_ACTION_LIKE_RESTRICT SYSTEM
REMOTE_ESP_ALLOCATION SYSTEM
SAVE_DROPPED_TABLE_DDL OFF
SCHEMA SCH
SCRATCH_DISKS
SCRATCH_DISKS_EXCLUDED
SCRATCH_DISKS_PREFERRED
SCRATCH_FREESPACE_THRESHOLD_PERCENT 10
SIMILARITY_CHECK ON
SORT_MAX_HEAP_SIZE_MB 20
STREAM_TIMEOUT -1
TABLELOCK SYSTEM
TEMPORARY_TABLE_HASH_PARTITIONS
TIMEOUT 6000
UDR_JAVA_OPTIONS OFF
UPD_ORDERED ON
UPD_SAVEPOINT_ON_ERROR ON
VARCHAR_PARAM_DEFAULT_SIZE 255
ZIG_ZAG_TREES OFF