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

Index
HP NonStop SQL/MX Installation and Management Guide—544536-007
Index-16
S
SPRs for H-series RVUs 3-3
SQL audited objects, recovering
purged 5-8
SQL objects 8-11
sqlcli.h file 3-14
SQLHIST file 3-13
SQLPROC entity
counters 14-8
description of 14-5
statistics 14-6
SQLSTMT entity
counters 14-8/14-10
description of 14-5
statistics 14-6
SQL-NEWPROCESS counter,
Measure 14-8
SQL-NEWPROCESS-TIME counter,
Measure 14-8
SQL-OBJ-RECOMPILE-TIME counter,
Measure 14-8
SQL-STATEMENT-RECOMPILES counter,
Measure 14-8
SQL-STATEMENT-RECOMPILES-TIME
counter, Measure 14-8
SQL/MP aliases
adding 9-14
altering 9-21
dropping 9-33
querying metadata about 8-35
SQL/MX
access privileges for database
objects 7-10
database objects, naming 13-6
files 3-8
indexes, recovering 12-22
installation tasks 3-2, 3-5
measurement models 14-8
metadata 1-8
object types 1-9
objects
label data 12-27
SQL/MX (continued)
repairing 12-25
restoring 12-22
SCF ALTER DISK issues 12-38
SCF ALTER DISK, LABEL
issues 12-39
views, recovering 12-22
post-installation tasks 3-15
releases and SPR equivalents 3-3
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-11
SQL/MX C 3-17
SQL/MX COBOL 3-17
SQL/MX compilation
compile and recompile statistics 14-8
elapsed time statistics 14-8
gathering statistics 14-6
number of compiles statistics 14-8
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