After you have redistributed DB2 data, you are ready to redistribute extender data. Enter the extender command REDISTRIBUTE NODEGROUP to start extender data redistribution.
redistribute nodegroup
The REDISTRIBUTE NODEGROUP command redistributes audio, image, and video extender data, and QBIC feature data, placing it at the same node as its corresponding user data.
If the redistribution process returns an error, you can rerun the command. You can rerun the command with or without the CONTINUE parameter, according to the instructions provided by the command response. This option instructs the system to continue from where it stopped, rather than starting from the beginning. The CONTINUE parameter cannot be used the first time you run the REDISTRIBUTE NODEGROUP command after running DB2's REDISTRIBUTE NODEGROUP command.
To maintain data integrity, redistribute one nodegroup at a time. Wait until one nodegroup has finished redistribution before starting another.
You must connect to the database before using this command.
You need SYSADM or DBADM authority to run this command.