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

Index
HP NonStop SQL/MX Installation and Management Guide—544536-007
Index-6
E
Distributed database (continued)
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, 6-7
DROP command, CASCADE option 12-11
Dropping aliases 9-33
Dropping catalogs 9-28
Dropping columns 9-28
Dropping constraints 9-29
Dropping indexes 9-30
Dropping objects
authorization requirements 9-26
summary 9-26
Dropping partitions
description of 9-31
example of 9-32
Dropping schemas 9-32
Dropping SQL/MP aliases 9-33
Dropping stored procedures 9-34
Dropping table data 9-36
Dropping tables 9-34
Dropping triggers 9-36
Dropping views 9-37
Dump
See also Backing up
file recovery 12-2
DUP
copying tables 10-41
guidelines for using 10-40
DYNAMIC_HISTOGRAM_
COMPRESSION 6-3
E
EDIT files
for recovery 12-38
storing tables definitions 7-22
ELAPSED-BUSY-TIME counter,
Measure 14-9
ELAPSED-RECOMPILE-TIME counter,
Measure 14-9
EMS events file 3-6
Ensuring proper object name
resolution 11-10
Environment, database management 1-1
ESCALATIONS counter, Measure 14-10
Executable files
description of 3-9
versions 3-15
Execution, cost statistics 14-8
EXPLAIN, indexes 9-9
External names, SQL objects 8-11
F
FASTCOPY
guidelines for using 10-42
FCHECK
description of 1-14
performed by InstallSqlmx 3-20
FFDC_DIALOUTS_FOR_ MXCMP 6-7
Field names, defining 7-23
FILE entity, Measure
access costs 14-10
description of 14-5
statistics 14-6
File label data 12-27
File label information, correcting 12-33
File locations 3-9
File recovery 5-8
File Utility Program
See FUP
FILEINFO utility
file recovery 12-3