SQL/MX 3.1 Installation and Management Guide (H06.23+, J06.12+)

Index
HP NonStop SQL/MX Release 3.1 Installation and Management Guide—663852-001
Index-16
S
subvolume and file naming 7-2
using InstallSqlmx 3-18
verifying software versions of Java
components 2-3
verifying the versions of executable
files 3-15
SQL/MX buffer
causes and symptoms of reuse
failures 15-9
how DP2 reuses plan fragments 15-9
managing 15-8
plan fragment size reduction 15-10
reducing reuse failures 15-13
using SCF ALTER DISK to resize the
buffer 15-12
using SCF STATS DISK to monitor
reuse failures 15-10
SQL/MX C 3-17
SQL/MX COBOL 3-17
SQL/MX compilation
compile and recompile statistics 14-9
elapsed time statistics 14-9
gathering statistics 14-7
number of compiles statistics 14-9
SQL/MX C++ 3-17
SQL/MX environment
description of 1-11
JDBC/MX 1-13
MXCS 1-12
NonStop Server for Java 4 1-12
OSS 1-12
SQL/MX objects 5-8
SQL/MX objects, repairing 12-25
START DISK command, SCF 12-40
START TMF command 12-2
Statements, execution costs 14-10
Statistics
displaying 14-3
execution 14-9
FILE entity 14-7
Measure collection 14-5/14-11
MXCI STATISTICS option 14-3
performance 14-1
PROCESSH entity 14-8
program execution 14-9
reports, Measure 14-7
SQLPROC report 14-7
SQLSTMT report 14-7
updating 12-11
STATUS command 10-4
STOP DISK command, SCF 12-40
Stored procedures
adding 9-14
altering 9-22
dropping 9-34
querying metadata about 8-45
restoring 12-24
Super ID, privileges for executing
utilities 1-12
SYSKEY 7-15
System catalog, displaying
information 8-42
System defaults
altering 9-22
alternative setting 6-3
ANSI compliance 6-8
CACHE_HISTOGRAMS 6-3
CACHE_HISTOGRAMS_
REFRESH_INTERVAL 6-3
DP2_CACHE_4096_BLOCKS 6-3
FFDC_DIALOUTS_FOR_ MXCMP 6-3
FLOATTYPE 6-3
HIST_SCRATCH_VOL 6-3
ISOLATION_LEVEL 6-8
NAMETYPE 6-3, 6-8
NATIONAL_CHARSET 6-4
NOT_NULL_CONSTRAINT_
DROPPABLE_OPTION 6-8
NOT_NULL_CONSTRAINT_DROPPAB
LE_OPTION 6-4
PRIMARY_KEY_CONSTRAINT_
DROPPABLE_OPTION 6-8