Use the Redistribute Data wizard to
create an effective redistribution plan for your database partition
group and redistribute your data. First you select your redistribution
method and strategy, then you make more advanced choices.
Before you begin
To work with database partition groups, you must have SYSADM
or DBADM authority.
Procedure
To redistribute data in your database partition group:
- Open the Redistribute Data wizard:
- From the Control Center, expand the object tree until
you find the Database Partition Groups folder. Any existing database partition groups are displayed in
the contents pane on the right side of the window.
- Right-click on the database partition group that you
want to work with and select Redistribute from
the pop-up menu. The Redistribute Data wizard
opens.
You can also open the Redistribute Data wizard
from the Adding database partitions using the Add Partitions
launchpad or the Dropping database partitions
from the instance using the Drop Partitions launchpad.
- Complete each of the applicable wizard pages. Click
the wizard overview link on the first page for more information. The Finish push
button is enabled when you specify enough information for the wizard
to redistribute your data.