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

Contents
HP NonStop SQL/MX Installation and Management Guide—523723-004
ix
9. Adding, Altering, and Dropping SQL/MX
Database Objects (continued)
Altering Views 9-26
9. Adding, Altering, and Dropping SQL/MX Database
Objects (continued)
Dropping Objects From an SQL/MX Database 9-27
Authorization Requirements for Dropping Database Objects 9-28
Dropping Catalogs 9-29
Dropping Columns 9-29
Dropping Constraints 9-30
Dropping Indexes 9-31
Dropping Partitions 9-32
Dropping Schemas 9-33
Dropping SQL/MP Aliases 9-35
Dropping SPJs 9-35
Dropping Tables 9-36
Dropping Triggers 9-38
Dropping Views 9-39
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-3
Suspending a Reorganization Operation 10-4
DDL Lock Considerations for MODIFY, import, 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-6
Performing Recovery on Failed Utility Operations 10-7
Structure Changing Operations That Can Run With Active or Inactive DDL Locks
Present 10-8
Using MODIFY to Manage Table and Index Partitions 10-9
MODIFY and EMS Messages 10-10
Online and Offline Partition Management 10-10
MODIFY and TMF 10-10
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