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

Index
HP NonStop SQL/MX Installation and Management Guide—523723-004
Index-4
D
CREATE TABLE statement
adding columns 9-23
adding tables 9-16
creating table partitions 7-15
description of 7-11
CREATE VIEW statement 7-37
Creating catalogs 7-6
Creating constraints 7-35
Creating table partitions 7-15
C++ preprocessor 3-23
D
Damaged objects, deleting 12-35
Data
checking 1-4, 16-13
integrity constraints 16-13
partitioned 7-15
replicated 13-24
validity 1-4
views and consistency 4-11
Data consistency, checking 12-29
Data problems
correcting 12-31
identifying 12-26
Data types
ASCII 7-23
character 7-22
datetime 7-22
default column 7-28
DOUBLE PRECISION 7-24
FLOAT 7-24
guidelines 7-21
INTERVAL 7-25
matching 7-30
NUMERIC 7-22
performance issues 7-22
REAL 7-24
VARCHAR 7-23
Database
access costs 15-9
access strategy 4-11
altering objects 9-18
changing 9-1
crash-open files 12-1
detecting inconsistencies 8-62
enhancing performance 16-1
integrating new columns 9-6
management
environment 1-1
guidelines 9-1
tasks 1-17
tools 1-17
object naming 1-6
planning 4-1
production 1-1
protection and recovery 1-2
recovery, node failure 12-1
relocating 15-1
reorganization 10-3
SCF ALTER DISK issues 12-36
SCF ALTER DISK, LABEL
issues 12-37
SCF STOP DISK issues 12-38
test 12-38
DataLoader/MX 14-14, 14-15
Data, dropping 9-37
DBA (database administrator)
tasks 1-17
tools 1-17
DDL directory, purging dropped tables 10-1
DDL licensing product 3-6
DDL locks
consequences of a failed utility
operation 10-6
description of 10-5
operations that can run with DDL locks
present 10-8