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

Contents
HP NonStop SQL/MX Installation and Management Guide—544536-007
x
10. Reorganizing SQL/MX Tables and Maintaining
Data (continued)
10. Reorganizing SQL/MX Tables and Maintaining
Data (continued)
Recommended Practices for Improving import Performance 10-27
Using import to Load Partitions 10-31
Support for restarting import 10-32
Examples of Using import to Load an SQL/MX Table 10-33
Using import to Append Data to Tables or Partitions 10-38
Using DUP to Copy Tables Into Tables 10-40
Guidelines for Using DUP 10-40
Examples of Using DUP to Copy Tables 10-41
Using FASTCOPY to Copy Tables into Tables 10-42
Guidelines for Using FASTCOPY 10-42
Examples of Using FASTCOPY to Copy Tables 10-43
DUP versus FASTCOPY 10-44
Using PURGEDATA to Delete Data From Tables 10-45
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