SQL/MX 3.x Installation and Management Guide (H06.22+, J06.11+)

Index
HP NonStop SQL/MX Installation and Management Guide—640325-001
Index-15
S
Security
globally placed modules 11-16
locally placed modules 11-17
planning 5-1
Safeguard 5-4
views 7-40
SELECT statement views 15-19
Sequential cache 15-14
SERVER object, OPEN command 2-4
Servers
constraints 15-18
opening 2-4
SET STATISTICS ON command 14-1, 14-3
Setting DEFINEs 11-11
Setting SQL/MP aliases 11-11
Setting the national character set 3-22
SHOWDDL command
CREATE INDEX statement 12-22
DDL syntax 5-8
description of 8-4
example of 12-18
OBEY command file 5-9
output files 12-25
recovery 5-8, 12-24
SHOWLABEL command
description of 8-3, 12-30
statistics 14-2
Software
requirements 2-2
verifying executable file versions 3-15
Software products, independent 2-3
SPJ product files 3-12
SPRs for H-series RVUs 3-3
SQL audited objects, recovering
purged 5-8
SQL objects 8-10
sqlcli.h file 3-14
SQLHIST file 3-13
SQLPROC entity
counters 14-9
description of 14-6
statistics 14-7
SQLSTMT entity
counters 14-9/14-11
description of 14-6
statistics 14-7
SQL-NEWPROCESS counter,
Measure 14-9
SQL-NEWPROCESS-TIME counter,
Measure 14-9
SQL-OBJ-RECOMPILE-TIME counter,
Measure 14-9
SQL-STATEMENT-RECOMPILES counter,
Measure 14-9
SQL-STATEMENT-RECOMPILES-TIME
counter, Measure 14-9
SQL/MP aliases
adding 9-14
altering 9-21
dropping 9-33
querying metadata about 8-44
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-4
measurement models 14-9
metadata 1-8
object types 1-10
objects
label data 12-27
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