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-14
S
FROMARCHIVE option 12-2, 12-10
Guardian names 12-3
indexes 12-13
MAP NAMES parameter 12-6
TOFIRSTPURGE option 12-10
Recovery
BROKEN flag, resetting 12-33
broken partition 12-33
catalog 12-6
consistent files 12-33
crash-open files 12-1
disk or node failure 12-1
EDIT files 7-22
file 12-2
from SCF commands 12-37
indexes 12-22
planning 5-1
RESETBROKEN option 12-33
SQL/MX objects 5-8
tables
description of 5-8
partitioned 12-13
with indexes 12-13
TMF 5-20, 12-2
tools 12-1
views 12-22
volume 12-2
Redefinition timestamp, changing 12-34
REDONEEDED flag (FILEINFO) 12-2, 12-3
REF_CONSTRAINT_NO_
ACTION_LIKE_RESTRICT
alternate settings 6-6
ANSI compliance 6-8
RELEASED attribute, TMF online
dumps 12-10
Releases, compatibility issues 13-25
RELOAD command 10-2
Remote Database Facility (RDF) 5-6
Remote node availability 13-13
Remote node, running applications on 11-9
Removing modules 11-26
Rename Table 7-40
Repairing damaged SQL/MX objects 12-25
REPEAT USE ALLOWED clause 7-3
Reports, Measure statistics 14-7
Requesters 15-18
Resource fork
description of 8-2
physical files 12-25
run-time metadata 12-29
RESTORE command 12-23
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-6
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-40
STOP DISK command 12-40
Schemas
adding 9-13
dropping 9-32
querying metadata about 8-27/8-36
SCRATCH_DISKS 6-6
SCRATCH_DISKS_ EXCLUDED 6-6
SCRATCH_DISKS_ PREFERRED 6-7










