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

Index
HP NonStop SQL/MX Installation and Management Guide—544536-007
Index-15
S
Remote Database Facility (RDF) 5-6
Remote node availability 13-13
Remote node, running applications on 11-9
Removing modules 11-27
Rename Table 7-40, 10-41
Repairing damaged SQL/MX objects 12-25
REPEAT USE ALLOWED clause 7-3
Reports, Measure statistics 14-6
Requesters 15-18
Resource fork
description of 8-2
physical files 12-25
run-time metadata 12-28
RESTORE command 12-23
rollback of large block 5-37
Rows, ordering using an index 4-14
Running applications on a remote
node 11-9
Run-time library files
ZCLIDLL 3-12
ZCLIPDLL 3-12
Run-time metadata, retrieving 12-30
S
Safeguard, used for SQL/MX file
security 5-4
SAVE_DROPPED_TABLE_DDL
alternate setting 6-10
description of 6-4
recovery 5-8
SCF (Subsystem Control Facility)
ABORT DISK command 12-37
ALTER DISK command 12-38
ALTER DISK, LABEL command 12-39
commands, recovering from 12-37
INITIALIZE DISK command 12-39
START DISK command 12-39, 12-40
STOP DISK command 12-39, 12-40
Schemas
adding 9-13
Schemas (continued)
dropping 9-32
querying metadata about 8-24/8-27
SCRATCH_DISKS 6-11
SCRATCH_DISKS_ EXCLUDED 6-11
SCRATCH_DISKS_ PREFERRED 6-11
SCRATCH_FREESPACE_THRSHOLD_PE
RCENT 6-5
Security
globally placed modules 11-16
locally placed modules 11-18
planning 5-1
Safeguard 5-4
views 7-40
SELECT statement views 15-19
Sequential cache 15-14
SERVER object, OPEN command 2-5
Servers
constraints 15-18
opening 2-5
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-24
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