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

Index
HP NonStop SQL/MX Installation and Management Guide—523723-004
Index-5
D
DDL locks (continued)
performing recovery on failed utility
operations 10-7
using a query to obtain DDL lock and
process ID information 10-6
DDL operation limits 16-5
DDL statements 1-17
DDL_DEFAULT_LOCATIONS
description of 6-6
using to distribute primary range
partitions 7-17
Decoupled keys 7-15
DEFAULT clause 7-28
DEFAULT NULL clause 7-29
Default settings
altering 9-22
ANSI compliance 6-12
description of 6-1
general considerations 6-7
new for Release 2.0 6-3
new for Release 2.1 6-5
setting and updating 6-2
SYSTEM_DEFAULTS table 6-2
Defaults
See System defaults
DEFAULTS table, installing 3-17
DEFINE names 1-7
Defining table columns 7-20
Definitional integrity 1-4
DELETES counter 15-10
dependent objects 11-20
Disks
erasing 12-38
labeling 12-37
message operation statistics 15-9
mirrored volumes
recovery 5-6
SCF 12-38
prefetch operation 16-11
read operation statistics 15-9
Disks (continued)
renaming 12-36
SCF STOP DISK and START
DISK 12-38
DISK-READS counter, Measure 15-9,
15-10
DISPLAY STATISTICS command 15-1,
15-3
DISPLAY USE OF
checking module dependencies
with 11-20
description of 8-2
displaying all modules and dependent
objects 11-20
displaying all modules dependent on a
specific object 11-21
displaying dependent objects for one or
more specified modules 11-21
displaying the modules in a local
directory 11-21
Displaying and analyzing query execution
plans 11-15
Distributed database
ANSI name lookup 13-4
catalog reference 13-4, 13-9
creating 13-19
effect of network lines 13-13
local 13-1
managing 13-1
naming database objects 13-6
performance issues 13-23
registering a catalog 13-20
security guidelines 13-6, 13-11
transparency 13-5
unregistering a catalog 13-20
user data distribution 13-4
using catalog references 13-8
versioning 13-3
visibility rules 13-5
ways to distribute objects 13-2
Distributed objects, managing 13-1