Managing database partitions

You can start or stop partitions, drop partitions, or trace partitions.

Before you begin

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

Procedure

To start or to stop a specific database partition, use the START DATABASE MANAGER command or the STOP DATABASE MANAGER command with the DBPARTITIONNUM parameter.
To drop a specific database partition from the db2nodes.cfg configuration file, use the STOP DATABASE MANAGER command with the DROP DBPARTITIONNUM parameter.
Before using the DROP DBPARTITIONNUM parameter, run the DROP DBPARTITIONNUM VERIFY command to ensure that there is no user data on this database partition.
To trace the activity on a database partition, use the options specified by IBM Support.
Attention: Use the trace utility only when directed to do so by IBM Support or by a technical support representative.
The trace utility records and formats information about Db2 operations. For more details, see the db2trc - Trace command topic.