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

Remote Database Facility, 19
Removing Modules, 231
Reorganizing SQL/MX Tables, 178
Repair SQL/MX Metadata and Objects, 253
Reserved Catalogs, 78
RESTORE SHOWDDL ON, 67
Restoring
Catalogs, 251
Indices and Index Partitions, 252
Schemas, 252
Tables and Partitions, 252
Restoring Objects, 251
Reviewing and Setting System Defaults, 68
S
Safeguard Security, 44
SCF ALTER DISK, 302
Securing User Modules, 223
SECURITY_SCHEMA, 23
Sequence Generator
Displaying Information, 147
Modifying Location, 193
sequence generator, 25
Sequence Generator Privileges
Altering, 168
Sequence Generators
Adding, 159
Altering, 167
Creating, 102
Dropping, 174
SET STATISTICS, 286
Setting
DEFINEs, 220
SQL/MP Aliases, 220
SHOWDDL, 107
SHOWLABEL, 106
SQL/MX Database Recovery
Backup and Restore 2, 61
SQL/MX Metadata, 23
START DISK, 265
Statistics
DISKFILE and DISCOPEN Statistics, 289
FILE Statistics, 289
ROCESSH Statistics, 289
SQLPROC Statistics, 288
SQLSTMT Statistics, 288
STOP DISK, 265
Subvolume and File Naming Guidelines, 73
SYSKEY, 31
SYSTEM_DEFAULTS_SCHEMA, 23
SYSTEM_SCHEMA, 23
SYSTEM_SQLJ_SCHEMA, 23
T
Tasks, 27
TMF Concepts, 48
TMF DUMP FILES, 53
Tools for Gathering Statistics, 284
Transaction Backout, 49
Transaction Management Facility, 19
U
Understanding SQL/MX Table, 30
UPSHIFT Attribute, 96
user schemas, 23
Using
Indexes, 37
Keys, 81
Queries, 293
RDF, 56
SCF STATS DISK, 299
SHOWDDL, 253
SQL/MX Tables, 35
Views, 36
V
Volume Recovery, 50
W
With Compiled Modules, 214
Without Compiled Modules, 215
318 Index