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

Index
HP NonStop SQL/MX Installation and Management Guide—544536-007
Index-5
D
DDL locks (continued)
operations that can run with DDL locks
present 10-9
performing recovery on failed utility
operations 10-8
using a query to obtain DDL lock and
process ID information 10-6
DDL operation limits 15-6
DDL statements 1-13
DDL_DEFAULT_LOCATIONS
description of 6-6
using to distribute primary range
partitions 7-19
Decoupled keys 7-16
DEFAULT clause 7-30
DEFAULT NULL clause 7-31
Default settings
altering 9-22
ANSI compliance 6-13
description of 6-1
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
DEFINE names 1-7
Defining table columns 7-23
Definitional integrity 1-4
DELETES counter 14-10
dependent objects 11-19
Disks
erasing 12-39
labeling 12-39
message operation statistics 14-9
mirrored volumes
recovery 5-6
SCF 12-39
prefetch operation 15-15
read operation statistics 14-9
renaming 12-38
Disks (continued)
SCF STOP DISK and START
DISK 12-39
DISK-READS counter, Measure 14-9,
14-10
DISPLAY STATISTICS command 14-1,
14-3
DISPLAY USE OF
checking module dependencies
with 11-19
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-23
Displaying and analyzing query execution
plans 11-14
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
using co-located indexes 13-23
using remote application
processes 13-23
versioning 13-3
visibility rules 13-5