SQL/MP Installation and Management Guide

Index
HP NonStop SQL/MP Installation and Management Guide—523353-004
Index-8
D
DEFINEs (continued)
distributed databases 12-1
duration 10-31
examples, with SQLCI 10-34
identifiers 10-30
INVOKE statement 10-33
name resolution 10-13
names
locally distributed databases 12-1
network distributed databases 12-3
run-time environment 10-33
naming rules 10-30
network distributed databases 12-3
OBEY command files 10-31
PATHMON 10-37
PATHMON environment, set
duration 10-38
PATHMON, altering 10-37
programs 10-32
SORT DEFAULTS 14-26
SQL recompilation 10-10
SQLCI 10-31
SQL_CMP_CPUS 12-11
SQL_CMP_DOUBLE_SBB_OFF 14-21
SQL_CMP_DOUBLE_SBB_ON 14-21
SQL_EXE_DOUBLE_SHUTOFF 14-19
table creation 5-17
TACL, example 10-35, 10-36
Definitional integrity 1-6
DEFMODE option 10-31, 10-32
DELETE statement 10-41
Dependencies
determining 6-1, 9-2
displaying 6-2
DETAIL command 9-10, 9-11
Dictionary
See Data dictionary
Disk process 3-2
Disks
See also Volumes
database environment 1-1
erasing 11-33
labeling 11-31
mirrored volumes
PUP 11-33
recovery 4-1
requirements 2-2
prefetch operation 14-18
PUP REMOVE and REVIVE 11-33
read operation statistics 13-9
renaming 11-32
DISK-READS counters, Measure 13-9,
13-10
DISPLAY STATISTICS command 13-1,
13-3
DISPLAY USE OF utility 6-3
DISTINCT clause, avoiding sort 3-21
Distributed database
access paths 12-5
catalogs 12-4, 12-5
creating 12-7
effect of network lines 12-6
indexes 12-7
local 12-1
managing 12-1
partitions 12-5, 12-8
performance issues 12-9
security 12-4
SQL compilation 12-6
tables 12-7
views 12-7
ways to distribute objects 12-2
Distributed objects
altering 12-8
dropping 12-8
managing 12-1