Administration Guide

Data Redistribution and Other Operations

You can do the following operations on objects of the nodegroup while the utility is running. You cannot, however, do them on the table that is being redistributed. You can:

• Create indexes on other tables. The CREATE INDEX statement uses the partitioning map of the affected table.
• Drop other tables. The DROP TABLE statement uses the partitioning map of the affected table.
• Drop indexes on other tables. The DROP INDEX statement uses the partitioning map of the affected table.
• Query other tables.
• Update other tables.
• Create new tables in a table space defined in the nodegroup. The CREATE TABLE statement uses the target partitioning map.
• Create table spaces in the nodegroup.

You cannot do the following operations while the utility is running:

• Another redistribution operation on the nodegroup
• An ALTER TABLE on any table in the nodegroup
• Drop the nodegroup
• Alter the nodegroup.