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

HP NonStop SQL/MX Installation and Management Guide—640325-001
8
10. Reorganizing SQL/MX Tables and Maintaining
Data
Adding Partitions to SQL/MX Tables and Indexes 9-11
Adding Schemas 9-13
Adding SQL/MP Aliases 9-14
Adding Stored Procedures in Java (SPJs) 9-14
Adding SQL/MX Tables 9-14
Adding Triggers 9-16
Adding Views 9-17
Altering Objects in an SQL/MX Database 9-18
Authorization Requirements for Altering Database Objects 9-19
Altering SQL/MX Indexes 9-20
Altering Partitions for SQL/MX Tables and Indexes 9-21
Altering SQL/MP Aliases 9-21
Altering SPJs 9-22
Altering System Defaults 9-22
Altering SQL/MX Tables 9-22
Altering Triggers 9-25
Altering Views 9-25
Dropping Objects From an SQL/MX Database 9-26
Authorization Requirements for Dropping Database Objects 9-26
Dropping Catalogs 9-28
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
D
ropping SQL/MX Tables 9-34
D
ropping 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