SQL/MX 2.x Installation and Management Guide (H06.10+, J06.03+)

Index
HP NonStop SQL/MX Installation and Management Guide—544536-007
Index-17
S
SQL/MX objects 5-8
SQL/MX objects, repairing 12-25
START DISK command, SCF 12-39
START TMF command 12-2
Statements, execution costs 14-9
Statistics
displaying 14-3
execution 14-8
FILE entity 14-6
Measure collection 14-4/14-10
MXCI STATISTICS option 14-3
performance 14-1
PROCESSH entity 14-7
program execution 14-8
reports, Measure 14-6
SQLPROC report 14-6
SQLSTMT report 14-6
updating 12-11
STATUS command 10-4
STOP DISK command, SCF 12-39
Stored procedures
adding 9-14
altering 9-22
dropping 9-34
querying metadata about 8-36
restoring 12-24
Super ID, privileges for executing
utilities 1-12
SYSKEY 7-15
System catalog, displaying
information 8-33
System defaults
altering 9-22
alternative setting 6-7
ANSI compliance 6-13
CACHE_HISTOGRAMS 6-7
CACHE_HISTOGRAMS_
REFRESH_INTERVAL 6-3, 6-7
CHECK_CONSTRAINT_PRUNING 6-6
DDL_DEFAULT_LOCATIONS 6-6
System defaults (continued)
DP2_CACHE_4096_BLOCKS 6-3, 6-7
DYNAMIC_HISTOGRAM_COMPRESS
ION 6-3
FFDC_DIALOUTS_FOR_ MXCMP 6-7
FLOATTYPE 6-3, 6-7
GEN_MAX_NUM_PART_DISK_
ENTRIES 6-3
GEN_MAX_NUM_PART_NODE_
ENTRIES 6-3
HIST_NO_STATS_REFRESH_
INTERVAL 6-3
HIST_SCRATCH_VOL 6-8
HIST_SECURITY_WARNINGS 6-3
INDEX_ELIMINATION_LEVEL 6-3
INTERACTIVE_ACCESS 6-3
ISOLATION_LEVEL 6-13
MAX_ROWS_LOCKED_FOR_
STABLE_ACCESS 6-3
MSCF_ET_REMOTE_MSG_
TRANSFER 6-3
MULTIUNION 6-6
MXCMP_PLACES_LOCAL_MODULES
6-3
NAMETYPE 6-8, 6-13
NATIONAL_CHARSET 6-8
new for Release 2.0 6-3
new for Release 2.1 6-5
NOT_NULL_CONSTRAINT_
DROPPABLE_OPTION 6-4, 6-13
NOT_NULL_CONSTRAINT_DROPPAB
LE_OPTION 6-8
PM_OFFLINE_TRANSACTION_
GRANULARITY 6-4
PM_ONLINE_TRANSACTION_
GRANULARITY 6-4
POS_LOCATIONS 6-4
POS_NUM_OF_PARTNS 6-4
POS_RAISE_ERROR 6-4
PRESERVE_MIN_SCALE 6-4