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

Index
HP NonStop SQL/MX Installation and Management Guide—523723-004
Index-6
E
Distributing programs across nodes 11-8
DML statements 1-17
DOUBLE PRECISION data type 7-24
DP2
changing for fallback A-1
fallback SPRs 3-2
file labels 8-2
DP2_CACHE_4096_BLOCKS 6-3, 6-7
DROP command, CASCADE option 12-10
Dropping aliases 9-35
Dropping catalogs 9-29
Dropping columns 9-29
Dropping constraints 9-30
Dropping indexes 9-31
Dropping objects
authorization requirements 9-27
summary 9-27
Dropping partitions
description of 9-32
example of 9-33
Dropping schemas 9-33
Dropping SQL/MP aliases 9-35
Dropping stored procedures 9-35
Dropping table data 9-37
Dropping tables 9-36
Dropping triggers 9-38
Dropping views 9-39
Dump
See also Backing up
file recovery 12-2
DUP
copying tables 10-34
guidelines for using 10-33
DYNAMIC_HISTOGRAM_
COMPRESSION 6-3
E
EDIT files
for recovery 12-37
storing tables definitions 7-20
ELAPSED-BUSY-TIME counter,
Measure 15-8
ELAPSED-RECOMPILE-TIME counter,
Measure 15-9
EMS events file 3-7
Enhancements to optimizer and UPDATE
STATISTICS 16-7
Enscribe database migration 14-15
Enscribe files, LOAD utility 10-29
Ensuring proper object name
resolution 11-11
Environment, database management 1-1
ESCALATIONS counter, Measure 15-9,
15-10
Executable files
description of 3-11
versions 3-19
Execution, cost statistics 15-8
EXPLAIN, indexes 9-10
External names, SQL objects 8-14
F
Fallback
description of A-1
dropping SQL/MX objects A-6
from Release 2.1 to 2.0 A-3
initializing NonStop SQL/MX A-7
installing independent products A-7
loading the previous RVU A-6
ODBC A-4
planning for 14-4
procedure A-4
Release 1.8 requirement 14-2
removing DDL files A-5
removing user modules A-5
SPRs 3-2, 14-4
starting TMF A-7
tasks A-4
to Enscribe
and Release 2.x A-8
description of A-9