DB2 Version 9.7 for Linux, UNIX, and Windows

Adding database partitions using the Add Partitions launchpad

Use the Add Partitions launchpad to guide you through the tasks necessary to add partitions to an instance. The launchpad also helps you assign the newly added partitions to database partition groups in the databases that are in the instance, and then redistribute data in the database partition groups.

About this task

You should backup all databases in the instance before and after redistributing data in database partition groups. If you do not back up your databases, you might corrupt the databases and you might not be able to recover them.

To add partitions:
  1. Optional: Backing up data using the Backup wizard.
  2. Open the Add Partitions launchpad: From the Control Center, expand the object tree until you find the instance object that you want to work with.
  3. Right-click the object, and click Add Partitions in the pop-up menu. The Add Partitions launchpad opens.
  4. Adding database partitions to an instance using the Add Partitions wizard.
  5. Redistributing data in a database partition group.
  6. Optional: Backing up data using the Backup wizard.