SQL/MX 3.2.1 Management Manual (H06.26+, J06.15+)

Dropping SQL/MX Indexes...............................................................................................172
Dropping Partitions for SQL/MX Tables and Indexes.............................................................172
Dropping Schemas...........................................................................................................173
Dropping Sequence Generators.........................................................................................174
Dropping SQL/MP Aliases................................................................................................174
Dropping SPJs.................................................................................................................175
Dropping SQL/MX Tables.................................................................................................175
Dropping Triggers............................................................................................................176
Dropping Views...............................................................................................................177
8 Reorganizing SQL/MX Tables and Maintaining Data..................................178
Purging Dropped Tables From the DDL Directory.......................................................................178
Using FUP RELOAD to Reorganize Tables.................................................................................178
Reorganizing Table Files With FUP RELOAD........................................................................179
Determining the Status of a Reorganization With FUP STATUS................................................180
Suspending a Reorganization Operation.............................................................................180
DDL Lock Considerations for MODIFY, import, POPULATE INDEX, DUP, FASTCOPY, and
PURGEDATA........................................................................................................................181
Consequences of a Failed Utility Operation.........................................................................182
Using a Query to Obtain DDL Lock and Process ID Information..............................................182
Performing Recovery on Failed Utility Operations.................................................................183
Structure Changing Operations That Can Run With Active or Inactive DDL Locks Present............183
Using MODIFY to Manage Table and Index Partitions...............................................................184
MODIFY and EMS Messages............................................................................................184
Online and Offline Partition Management...........................................................................184
MODIFY and TMF...........................................................................................................185
MODIFY and Table Reloading...........................................................................................186
Recovering a Failed MODIFY Request and Resetting Flags.....................................................186
Using MODIFY to Manage Range-Partitioned Tables and Indexes..........................................188
Using MODIFY to Manage Hash-Partitioned Tables and Indexes............................................191
Using MODIFY to Change the Location of a Sequence Generator..........................................193
Managing System-Clustered Tables and Indexes...................................................................193
Using import to Load SQL/MX Tables......................................................................................194
Guidelines for Using import...............................................................................................194
Summary of import Options..............................................................................................194
Other import Features.......................................................................................................197
Recommended Practices for Improving import Performance....................................................197
Using import to Load Partitions..........................................................................................200
Support for restarting import..............................................................................................201
Examples of Using import to Load an SQL/MX Table............................................................202
Using import to Append Data to Tables or Partitions.............................................................205
Using DUP to Copy Tables Into Tables.....................................................................................207
Guidelines for Using DUP.................................................................................................207
Examples of Using DUP to Copy Tables..............................................................................208
Using FASTCOPY to Copy Tables into Tables............................................................................208
Guidelines for Using FASTCOPY........................................................................................208
Examples of Using FASTCOPY to Copy Tables.....................................................................209
DUP versus FASTCOPY......................................................................................................210
Using PURGEDATA to Delete Data From Tables.........................................................................210
Guidelines for Using PURGEDATA......................................................................................210
Examples of Using PURGEDATA to Delete Table Data...........................................................211
9 Managing Database Applications............................................................212
Writing SQL/MX Applications to Recover From Temporary Network or Hardware Service
Interruptions.........................................................................................................................212
Recovery for Read-Only Queries........................................................................................213
8 Contents