Image | Audio | Video |
---|---|---|
X |
Redistributes extender data when a node is added to or removed from a nodegroup, or when a new partition map is established for a nodegroup.
Authorization
SYSADM, DBADM
Command syntax
>>-REDISTRIBUTE NODEGROUP--nodegroup--+----------+------------->< '-CONTINUE-'
Command parameters
Examples
Redistribute the nodegroup called my_nodegroup:
redistribute nodegroup my_nodegroup
Usage notes
Connect to the database before using this command.
The CONTINUE parameter should not be used the first time you run the REDISTRIBUTE NODEGROUP command following DB2's REDISTRIBUTE command. If it is used the first time, then an error is logged and redistribution starts from the beginning.
To maintain data integrity, you must redistribute one nodegroup at a time. Wait until one nodegroup has finished redistribution before starting another.
If REDISTRIBUTE NODEGROUP fails, you can refer to the file "redist.log" for a detailed explanation in one of the following directories: