SQL/MX 2.x Installation and Management Guide (H06.04+)

Contents

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

9. Adding, Altering, and Dropping SQL/MX

Database Objects (continued)

9. Adding, Altering, and Dropping SQL/MX Database Objects

(continued)

Dropping SQL/MX Indexes 9-30

Dropping Partitions for SQL/MX Tables and Indexes 9-31

Dropping Schemas 9-32

Dropping SQL/MP Aliases 9-33

Dropping SPJs 9-34

Dropping SQL/MX Tables 9-34

Dropping Triggers 9-36

Dropping Views 9-37

10. Reorganizing SQL/MX Tables and Maintaining Data

Purging Dropped Tables From the DDL Directory 10-1

Choosing a Reorganization Method 10-2

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-4

Suspending a Reorganization Operation 10-4

DDL Lock Considerations for MODIFY, import, POPULATE INDEX, DUP, and

PURGEDATA 10-5

Consequences of a Failed Utility Operation 10-6

Using a Query to Obtain DDL Lock and Process ID Information 10-7

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-12

Recovering a Failed MODIFY Request and Resetting Flags 10-13

Using MODIFY to Manage Range-Partitioned Tables and Indexes 10-15

Using MODIFY to Manage Hash-Partitioned Tables and Indexes 10-19

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-22

Other import Features 10-24

Recommended Practices for Improving import Performance 10-25