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

SQL/MX and SQL/MP Differences in Recovery Action for Read-Only Queries..........................213
Moving Programs From Development to Production...................................................................214
Reasons Not to Move a Program and Reuse Its Compiled Modules.........................................214
Moving a Program and Recompiling Modules.....................................................................215
Moving a Program to Production and Re-compiling its SQL Statements....................................216
Moving a Program and Reprocessing Modules Using the mxrpm Tool.....................................217
Distributing Programs Across Nodes........................................................................................218
Moving Applications to a Remote Node..............................................................................218
Running Applications on a Remote Node............................................................................218
Using REGISTER CATALOG to Access Objects on Remote Nodes...........................................219
Maintaining Local Autonomy for Programmatic Queries........................................................219
Ensuring Proper Name Resolution...........................................................................................220
Setting DEFINEs...............................................................................................................220
Setting SQL/MP Aliases....................................................................................................220
Assigning Permissions for Running Database Applications..........................................................221
Managing Permissions for Files in OSS Space.....................................................................221
Managing Permissions for Files in Guardian Space..............................................................221
Maintaining Query Execution Plan Validity..............................................................................222
Factors Affecting the Query Execution Plan..........................................................................222
Recompiling a Module.....................................................................................................222
Migrating SQL/MX Nodes to Obtain Improved Query Plan Performance.................................222
Displaying and Analyzing Query Execution Plans................................................................223
Managing Modules..............................................................................................................223
Producing Locally Placed Modules or Globally Placed Modules.............................................223
Securing User Modules.....................................................................................................223
Checking Module Dependencies with DISPLAY USE OF........................................................226
Grouping Applications and Modules to Run Multiple DISPLAY USE OF Operations...................228
Removing Modules...........................................................................................................231
Converting Globally Placed Modules to Locally Placed Modules............................................232
Managing Module Files and Their Applications During Fallback From SQL/MX Release 3.2......233
Backing Up and Restoring Programs.......................................................................................233
10 Performing Recovery Operations.............................................................235
Recovering Databases After Disk or Node Failures....................................................................235
Recovering Disk Volumes.......................................................................................................235
Recovering Files....................................................................................................................236
Recovering Files With the TIME Option...............................................................................236
Recovering Files to New Locations......................................................................................237
Recovering Metadata............................................................................................................239
Recovering Database Objects................................................................................................239
Recovering Range Partitions...............................................................................................239
Recovering SPJs...............................................................................................................240
Recovering Tables............................................................................................................240
Recovering Views and Indexes...........................................................................................251
Restoring Objects With BRCOM RESTORE...............................................................................251
Restoring Catalogs...........................................................................................................251
Restoring Schemas...........................................................................................................252
Restoring Tables and Partitions...........................................................................................252
Restoring Indices and Index Partitions.................................................................................252
Using SHOWDDL............................................................................................................253
Repairing Damaged SQL/MX Metadata and Objects...............................................................253
Strategies for Repairing Damaged Metadata and Objects.....................................................254
Identifying Problem Data and Objects................................................................................255
Using FIXUP to Correct Problem Data and Objects...............................................................259
Examples of Using FIXUP..................................................................................................261
Contents 9