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

Index
HP NonStop SQL/MX Installation and Management Guide—544536-007
Index-3
C
Blocks, key-sequenced file 4-6
Broken bit, changing 12-34
BROKEN flag 12-32
Broken partitions, recovering 12-33
Buffer size, effect on query
performance 15-14
C
C preprocessor 3-17
Cache size 15-14
CACHE_HISTOGRAMS 6-7
CACHE_HISTOGRAMS_
REFRESH_INTERVAL 6-3, 6-7
CALLS counter, Measure 14-9
CASCADE option 12-11
CAST function 7-24
Catalogs
adding 9-4
CATALOGS table, displaying contents
of 8-33
creating 7-7
dropping 9-28
querying metadata about 8-20/8-23
recovering 12-6
SCF ALTER DISK issues 12-38
SCF ALTER DISK, LABEL
issues 12-39
Changing catalog, schema, and object
UIDs 12-35
Changing the database 9-1, 9-18
Character data types 7-25
CLEARONPURGE attribute
altering index attributes 9-20
altering table attributes 9-24
Clustering keys
access paths 7-33
creating and using 7-13
example of 7-14
indexes 7-33
COBOL preprocessor 3-17
Columns
adding 9-5
altering 9-22
data types 7-29
default value 7-30
dropping 9-28
indexed
benefits of 4-14
defining 4-16
KEYTAG 4-16
names 7-23
null value 7-30
performance issues 7-24
querying metadata about 8-47/8-55
renaming 4-11, 7-39
specifying attributes 7-32
specifying indexes 4-17, 4-18
values restriction 4-14
Compatibility issues for releases 13-25
Compilation statistics 14-8
Concurrency 15-2
Consistency 8-60
Consistent files, recovering 12-32
Constraints
adding 9-7
altering 9-23
changing 9-23
creating 7-37
dropping 9-29
performance issues 15-18
querying metadata about 8-44/8-46
restoring 12-24
CONTROL QUERY DEFAULT 6-2
COPYOSS macro 3-3
Correcting file label information 12-33
Correcting problem data 12-32
Corrupt bit, changing 12-34
CRASHOPEN option 12-2
Crash-open files, recovery 12-1