SQL/MX 3.2.1 Management Manual (H06.26+, J06.15+)

Index
A
ABORT DISK command
SCF, 263
Access Privileges, 79
Adding
Catalogs, 152
Columns, 152
Constraints, 154
Indexes, 155
Objects, 150
Partitions, 157, 307
Schemas, 159
Sequence Generators, 159
SQL/MP Aliases, 160
SQL/MX Tables, 160
Triggers, 161
Views, 161
All Privileges for a Column, 146
ALTER DISK, ALTNAME, 264
ALTER DISK, LABEL, 264
ALTER DISK, VOLNAME, 264
Altering
Distributed Objects, 280
Indexes, 164
Objects, 162
Partitions, 164
Sequence Generators, 167
SPJs, 165
SQL/MP Aliases, 165
SQL/MX Tables, 166
System Defaults, 165
Triggers, 168
Views, 168
ANSI Views, 36
Authorization Requirements, 163
B
Backup and Restore 2, 19
C
Catalog References, 271
Catalog UID, 118
Character Sets, 21
Checking Module Dependencies, 226
Clustering Key, 31
Co-located Indexes, 281
Column Attributes, 95
Concurrency, 293
Converting Modules, 232
Creating
Catalogs, 77
Constraints, 99
Distributed Database, 278
Indexes, 96
Keys, 81
Partitions, 83
RDF Backup Catalogs, 57
RDF Backup Schemas, 57
Schemas, 78
Sequence Generators, 102
SPJ, 102
SQL/MX Database, 73
SQL/MX Metadata, 76
SQL/MX Tables, 80
Triggers, 102
Views, 101
D
Data Integrity, 20, 306
Data Type Problems
Check Data Consistency, 257
Label Data, 255
Resource Fork Run-Time Metadata, 256
Retrieve Run-Time Metadata, 257
Database
Access and Security, 43
Layout, 35
Security, 21
Tools, 27
DDL Lock, 181
DEFINITION_SCHEMA _VERSION_vernum, 23
DISPLAY STATISTICS, 286
DISPLAY USE OF, 106
Displaying
All Tables in a Catalog, 125
All Tables in a Schema, 127
Column Information, 138
Constraint Information, 136
Index Information, 131
Partition Information, 135
Sequence Generators, 147
Table Information, 125
Version Numbers, 147
Distributed Databases
Recovery
Protection, 19
Distributing
Programs Across Nodes, 218
SQL/MX Database Objects, 279
Dropping
Catalogs, 170
Columns, 170
Constraints, 171
Distributed Objects, 280
Indexes, 172
Objects, 168
Partitions, 172, 307
Schemas, 173
Sequence Generators, 174
SPJs, 175
SQL/MP Aliases, 174
316 Index