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

Index
HP NonStop SQL/MX Installation and Management Guide—523723-004
Index-18
S
SQL/MX UDR server 3-20
SRLs 3-7
START DISK command, SCF 12-38
START TMF command 12-2
Startup cost, SQL/MX 15-8
Statements, execution costs 15-8
Statistics
displaying 15-3
execution 15-8
FILE entity 15-6
Measure collection 15-4/15-10
MXCI STATISTICS option 15-3
performance 15-1
PROCESSH entity 15-7
program execution 15-8
reports, Measure 15-6
SQLPROC report 15-6
SQLSTMT report 15-6
updating 12-10
STATUS command 10-4
STOP DISK command, SCF 12-38
Stored procedures
adding 9-15
altering 9-22
dropping 9-35
querying metadata about 8-38
restoring 12-23
Super ID, privileges for executing
utilities 1-16
SYSKEY 7-14
System catalog, displaying
information 8-35
System defaults
altering 9-22
alternative setting 6-7
ANSI compliance 6-12
CACHE_HISTOGRAMS 6-7
CACHE_HISTOGRAMS_
REFRESH_INTERVAL 6-3, 6-7
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-7
HIST_SECURITY_WARNINGS 6-3
INDEX_ELIMINATION_LEVEL 6-3
INTERACTIVE_ACCESS 6-3
ISOLATION_LEVEL 6-12
MAX_ROWS_LOCKED_FOR_
STABLE_ACCESS 6-3
MSCF_ET_REMOTE_MSG_
TRANSFER 6-3
MXCMP_PLACES_LOCAL_MODULES
6-3
NAMETYPE 6-8, 6-12
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-12
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
PRIMARY_KEY_CONSTRAINT_
DROPPABLE_OPTION 6-4, 6-12