DB2 Version 9.7 for Linux, UNIX, and Windows

Redistributing data in a database partition group

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:

  1. Open the Redistribute Data wizard:
    1. 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.
    2. 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.

  2. 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.