Dropping database partitions
You can drop a database partition that is not being used by any database and free the computer for other uses.
Before you begin
- If you receive message SQL6034W (Database partition not used in any database), you can drop the database partition.
- If you receive message SQL6035W (Database partition in use by database), use the REDISTRIBUTE DATABASE PARTITION GROUP command to redistribute the data from the database partition that you are dropping to other database partitions from the database alias.
Procedure
To drop a database partition using the command line:
Issue the STOP DBM command with the DROP
DBPARTITIONNUM parameter to drop the database partition.
After the command completes successfully, the system is stopped. Then start the database manager with the START DBM command.