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

Contents
HP NonStop SQL/MX Installation and Management Guide—640325-001
ix
10. Reorganizing SQL/MX Tables and Maintaining
Data
10. Reorganizing SQL/MX Tables and Maintaining Data
Purging Dropped Tables From the DDL Directory 10-1
Using FUP RELOAD to Reorganize Tables 10-2
Reorganizing Table Files With FUP RELOAD 10-2
Determining the Status of a Reorganization With FUP STATUS 10-3
Suspending a Reorganization Operation 10-4
DDL Lock Considerations for MODIFY, import, POPULATE INDEX, DUP, FASTCOPY,
and PURGEDATA 10-5
Consequences of a Failed Utility Operation 10-6
Using a Query to Obtain DDL Lock and Process ID Information 10-6
Performing Recovery on Failed Utility Operations 10-8
Structure Changing Operations That Can Run With Active or Inactive DDL Locks
Present 10-9
Using MODIFY to Manage Table and Index Partitions 10-10
MODIFY and EMS Messages 10-10
Online and Offline Partition Management 10-10
MODIFY and TMF 10-11
MODIFY and Table Reloading 10-11
Recovering a Failed MODIFY Request and Resetting Flags 10-13
Using MODIFY to Manage Range-Partitioned Tables and Indexes 10-14
Using MODIFY to Manage Hash-Partitioned Tables and Indexes 10-18
Managing System-Clustered Tables and Indexes 10-21
Using import to Load SQL/MX Tables 10-22
Guidelines for Using import 10-22
Summary of import Options 10-23
Other import Features 10-26
Recommended Practices for Improving import Performance 10-27
Using import to Load Partitions
10-30
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