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

Index
HP NonStop SQL/MX Installation and Management Guide—523723-004
Index-16
S
Replicated data 13-24
Reports, Measure statistics 15-6
Requesters 16-13
Resource fork
description of 8-2
physical files 12-24
run-time metadata 12-27
RESTORE command 12-22
Rows, ordering using an index 4-14
Running applications on a remote
node 11-9
Run-time library files 3-16
Run-time metadata, retrieving 12-29
S
S72000 processor requirement 14-1
Safeguard, used for SQL/MX file
security 5-4
Sample database migration 3-2
SAVE_DROPPED_TABLE_DDL
alternate setting 6-10
description of 6-4
recovery 5-8
SCF SQLMXBUFFER attribute 16-9
SCF (Subsystem Control Facility)
ABORT DISK command 12-36
ALTER DISK command 12-36
ALTER DISK, LABEL command 12-37
commands, recovering from 12-35
INITIALIZE DISK command 12-38
START DISK command 12-38
STOP DISK command 12-38
Schemas
adding 9-13
dropping 9-33
querying metadata about 8-26/8-29
SCRATCH_DISKS 6-10
SCRATCH_DISKS_ EXCLUDED 6-10
SCRATCH_DISKS_ PREFERRED 6-11
SCRATCH_FREESPACE_THRSHOLD_PE
RCENT 6-5
Security
globally placed modules 11-17
locally placed modules 11-19
planning 5-1
Safeguard 5-4
views 7-38
SELECT statement views 16-14
Sequential cache 16-11
SERVER object, OPEN command 2-5
Servers
constraints 16-13
opening 2-5
remote 13-24
SET STATISTICS ON command 15-1, 15-3
Setting DEFINEs 11-11
Setting SQL/MP aliases 11-12
Setting the national character set 3-28
Setting the SCF SQLMXBUFFER
attribute 16-9
SHOWDDL command
CREATE INDEX statement 12-21
DDL syntax 5-8
description of 8-4
example of 12-17
OBEY command file 5-9
output files 12-23
recovery 5-8, 12-23
SHOWLABEL command
description of 8-3, 12-29
statistics 15-2
Software
requirements 2-3
verifying executable file versions 3-19
versioning 1-12
Software products, independent 2-4
SPJ product files 3-14
SQL audited objects, recovering
purged 5-8
SQL objects 5-8, 8-14