SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Contents
HP NonStop SQL/MX Installation and Management Guide—523723-004
x
10. Reorganizing SQL/MX Tables and Maintaining
Data (continued)
10. Reorganizing SQL/MX Tables and Maintaining
Data (continued)
Using import to Load and Append Input Data Into SQL/MX Tables 10-22
Guidelines for Using import 10-22
Summary of import Options 10-23
Other import Features 10-24
Recommended Practices for Improving import Performance 10-24
Using import to Load Partitions 10-28
Examples of Using import to Load an SQL/MX Table 10-29
Using import to Append Data to Tables or Partitions 10-31
Using DUP to Copy Tables Into Tables 10-34
Guidelines for Using DUP 10-34
Examples of Using DUP to Copy Tables 10-35
Using PURGEDATA to Delete Data From Tables 10-35
Guidelines for Using PURGEDATA 10-35
Examples of Using PURGEDATA to Delete Table Data 10-36
11. Managing Database Applications
Migrating Applications to Release 2.x 11-1
Migrating SQL/MP Applications to Release 2.x 11-2
Migrating SQL/MX Applications From Release 1.8 to Release 2.x 11-2
Migrating SQL/MX Applications From Release 2.0 to Release 2.1 11-3
Moving Programs From Development to Production 11-3
Reasons Not to Move a Program With Compiled Modules 11-3
Moving a Program Without Compiled Modules 11-4
Distributing Programs Across Nodes 11-8
Versioning Issues for a Distributed Database Environment
11-8
Moving Applications to a Remote Node
11-9
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-11
Setting DEFINEs 11-11
Setting SQL/MP Aliases 11-12
Assigning Permissions for Running Database Applications 11-13
Managing Permissions for Files in OSS Space 11-13
Managing Permissions for Files in Guardian Space 11-13
Maintaining Query Execution Plan Validity 11-14
Factors Affecting the Query Execution Plan 11-14