SQL/MX 3.1 Installation and Management Guide (H06.23+, J06.12+)

Contents
HP NonStop SQL/MX Release 3.1 Installation and Management Guide—663852-001
x
11. Managing Database Applications
Guidelines for Using PURGEDATA 10-45
Examples of Using PURGEDATA to Delete Table Data 10-46
11. Managing Database Applications
Writing SQL/MX Applications to Recover From Temporary Network or Hardware
Service Interruptions 11-1
Recovery for Read-Only Queries 11-2
SQL/MX and SQL/MP Differences in Recovery Action for Read-Only
Queries 11-3
Moving Programs From Development to Production 11-3
Reasons Not to Move a Program With Compiled Modules
11-4
Moving a Program Without Compiled Modules
11-5
Distributing Programs Across Nodes 11-8
Versioning Issues for a Distributed Database Environment 11-8
Moving Applications to a Remote Node 11-8
Running Applications on a Remote Node 11-9
Using REGISTER CATALOG to Access Objects on Remote Nodes 11-9
Maintaining Local Autonomy for Programmatic Queries 11-10
Ensuring Proper Name Resolution 11-10
Setting DEFINEs 11-11
Setting SQL/MP Aliases 11-11
Assigning Permissions for Running Database Applications 11-12
Managing Permissions for Files in OSS Space 11-12
Managing Permissions for Files in Guardian Space 11-13
Maintaining Query Execution Plan Validity 11-13
Factors Affecting the Query Execution Plan
11-13
Recompiling a Module 11-14
Migrating SQL/MX Nodes to Obtain Improved Query Plan Performance
11-14
Displaying and Analyzing Query Execution Plans
11-14
Managing Modules
11-15
Producing Locally Placed Modules or Globally Placed Modules 11-15
Securing User Modules
11-16
Checking Module Dependencies with DISPLAY USE OF
11-19
Grouping Applications and Modules to Run Multiple DISPLAY USE OF
Operations 11-23
Removing Modules
11-26
Converting Globally Placed Modules to Locally Placed Modules
11-27
Managing Module Files and Their Applications During Fallback From SQL/MX
Release 3.0 11-29
Backing Up and Restoring Programs 11-29