Administration Guide

How Data Is Redistributed in Tables

When doing data redistribution on a table, the utility does the following:

1. Locks the row for the table in the SYSTABLES catalog table.

2. Invalidates all plans that involve this table. The partitioning map ID associated with the table will change because the table is being redistributed. Because the plans are invalidated, the compiler must obtain the new partitioning information for the table and generate plans accordingly.

3. Locks the table in exclusive mode.

4. Redistributes the data in the table.

5. If the redistribution operation succeeds, it:

   1. Issues a COMMIT for the table.

   2. Continues with the next table in the nodegroup.
   utility:

   1. Issues a ROLLBACK on updates to the table.

   2. Ends the entire redistribution operation and returns an error.

[ DB2 List of Books | Search the DB2 Books ]