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
To Redistribute the Data in a Nodegroup
- If using the Datasource Explorer select the Nodegroups node or if using the Datasource Navigator expand that node.
- DBArtisan displays the nodegroups.
- Select one or more nodegroups, right-click the selected objects, and then select Redistribute from the context menu.
- DBArtisan opens the Redistribute Nodegroup dialog.
- 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)
- Click Execute. For information on the scheduling option, see Scheduling.