Managing database partitions from the Control Center - IBM DB2 9.7 for Linux, UNIX, and Windows

You can work with database partitions using the Database Partitions view of the Control Center.

Before you begin

To work with database partitions you will need authority to attach to an instance. Anyone with SECADM or ACCESSCTRL authority can grant you with the authority to access a specific instance.

To configure a database partition or take a database partition out of the rollforward pending state you must have SYSADM, SYSCTRL, or SYSMAINT authority.

About this task

Using the Database Partitions view you can restart a database partition, take a database partition out of the rollforward pending state, backup a database partition, restore a database partition, or configure a database partition using the Configuration Advisor.

To open the Database Partitions view from the Control Center:

From the Control Center, expand the object tree until you find the partitioned database for which you want to view the database partitions.
Right-click the partitioned database you want and select Open Database Partitions from menu list.
The Database Partitions view opens for the selected partitioned database.

To configure a database partition:

Select the database partitions that you want from the Database Partitions view.
Select Database Partitions, right-click and select Configuration Advisor from the list.
The Configuration Advisor opens. Use the Configuration Advisor to specify values for the database configuration parameters.