SQL/MX 3.x Installation and Management Guide (H06.22+, J06.11+)

Index
HP NonStop SQL/MX Installation and Management Guide—640325-001
Index-6
E
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
E
EDIT files
for recovery 12-38
storing tables definitions 7-22
ELAPSED-BUSY-TIME counter,
Measure 14-10
ELAPSED-RECOMPILE-TIME counter,
Measure 14-10
EMS events file 3-6
Ensuring proper object name
resolution 11-10
Environment, database management 1-1
ESCALATIONS counter, Measure 14-11
Executable files
description of 3-9
versions 3-15
Execution, cost statistics 14-9
EXPLAIN, indexes 9-9
External names, SQL objects 8-10
F
FASTCOPY
guidelines for using 10-42
FCHECK
description of 1-14
performed by InstallSqlmx 3-20
FFDC_DIALOUTS_FOR_ MXCMP 6-3
Field names, defining 7-23
FILE entity, Measure
access costs 14-11
description of 14-6
statistics 14-7
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
volume recovery 12-2
Files
See also Tables
characteristics 4-3
command summary 1-13
consistent, recovering 12-33
EDIT 7-22
EMS events 3-6
executable 3-9
header 3-14
interface description 3-14
messages 3-14
recovering 12-2, 12-4
reorganizing 10-2
SPJ product 3-12