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-5
D
DDL operation limits 15-6
DDL statements 1-13
DDL_DEFAULT_LOCATIONS
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-8
description of 6-1
setting and updating 6-1
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-11
dependent objects 11-19
Disks
erasing 12-39
labeling 12-39
message operation statistics 14-10
mirrored volumes
recovery 5-6
SCF 12-40
prefetch operation 15-15
read operation statistics 14-10
renaming 12-38
SCF STOP DISK and START
DISK 12-40
DISK-READS counter, Measure 14-10,
14-11
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-20
displaying the modules in a local
directory 11-22
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
ways to distribute objects 13-2
Distributed objects, managing 13-1
Distributing programs across nodes 11-8
DLLs
ZCLIDLL 3-6
ZCLIPDLL 3-6
DML statements 1-13
DOUBLE PRECISION data type 7-26
DP2
file labels 8-2
DP2_CACHE_4096_BLOCKS 6-3