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

Contents

HP NonStop SQL/MX Installation and Management Guide—544536-007

9. Adding, Altering, and Dropping SQL/MX

Database Objects (continued)

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

Objects (continued)

Dropping Columns from an SQL/MX Table 9-28

Dropping Constraints 9-29

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

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