Redistribute

Go Up to Available object actions by DBMS

DBArtisan lets you redistribute the data in a nodegroup. The Redistribute action implements the REDISTRIBUTE NODEGROUP and lets you specify UNIFORM, USING DISTFILE, USING TARGETMAP, -CONTINUE, or ROLLBACK parameters.

Platform Availability

• DB2 LUW

To Redistribute the Data in a Nodegroup

1. If using the Datasource Explorer select the Nodegroups node or if using the Datasource Navigator expand that node.

   DBArtisan displays the nodegroups.

2. Select one or more nodegroups, right-click the selected objects, and then select Redistribute from the context menu.

   DBArtisan opens the Redistribute Nodegroup dialog.

3. Select one of the following methods:
   • Uniform
   • Using Dist File (provide the distinct file name in the corresponding box)
   • Using Target Map (provide the target file name in the corresponding box)
4. Click Execute. For information on the scheduling option, see Scheduling.