SQL/MX 3.x Installation and Management Guide (H06.22+, J06.11+)

Contents

HP NonStop SQL/MX Installation and Management Guide—640325-001

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