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

SQL/MX Tables, 175
Triggers, 176
Views, 177
DUP, 207
E
Enhancing Database Performance, 293
F
FASTCOPY, 208
File Recovery, 50
File Structures, 30
Foreign Key, 31
Frequency of Backups, 63
FUP RELOAD, 178
G
GOAWAY, 263
H
HEADING Attribute, 95
I
import, 194
import to Load Partitions, 200
Index Partitioning, 34
INITIALIZE DISK, 265
K
Key-Sequenced File Structure, 32
Keys, 31
L
Locating MXCS Schema, 117
M
Maintaining
Data, 178
Local Autonomy in a Network, 274
Managing
Buffer Space, 297
Database Applications, 212
Distributed Database, 266
DP2 Data Cache Memory Size, 303
Local Distributed Database, 266
Mixed Versions, 282
Modules, 223
Network Security, 274
Network-Distributed Database, 267
Online Dumps, 51
Partitions, 83
Partitions for SQL/MX Indexes, 98
System-Clustered Tables and Indexes, 193
Table Data, 88
Measurement Models, 290
Memory Management, 304
Minimizing Contention, 295
MODIFY, 184
Moving Programs From Development to Production, 214
Multiple DISPLAY USE OF Operations, 228
MXCS, 26
MXCS_SCHEMA, 23
MXGNAMES, 309
mxtool INFO, 106
mxtool VERIFY, 106
N
Naming Conventions, 270
Naming Database Objects
ANSI
Guardian Physical Names, 22
Network Environments, 281
O
Object Types, 24
Online and Offline Partition Management, 184
OSS Environment, 26
P
Parallel Index, 305
Parallel Processing, 21
Partitioning Key, 31
Performance, 284
Performance Measurement Tool, 287
Performing
Recovery on Failed Utility Operations, 183
Recovery Operations, 235
Planning
Database Recovery, 45
Database Security, 42
Object Naming, 29
SQL/MX Tables, 29
Primary Key, 31
PURGEDATA, 210
Q
Querying SQL/MX Metadata, 105
R
Range Partitioning and Hash Partitioning, 34
RDBMS, 19
Recompiling a Module, 222
Recovering
Database Objects, 239
Databases After Disk or Node Failures, 235
Disk Volumes, 235
Files, 236
Metadata, 239
Range Partitions, 239
SCF Commands, 263
SPJs, 240
Tables, 240
Recovering Views and Indexes, 251
Recovery
Dropped Database Objects, 47
Guidelines, 46
REGISTER CATALOG, 219
Remote Application Processes, 281
317