Removing database partitions

Practically this recipe is linked with the previous one. Here, we will continue to remove the partitions 3 and 4 from the database.

Getting ready

Before deleting a partition, our first concern would be to make sure that the partition contains no data. Therefore, verification will be the first operation to be executed. If database partitions are empty, we can proceed further with removal. In this recipe, we will verify and remove the partitions 3 and 4, added previously, in the Adding database partitions recipe in this chapter.

How to do it...

You can perform these operations with Control Center or using the command line.

Using Control Center

1. In Control Center, navigate to instance db2instp, and right-click on Open Database partition servers. Next, right-click on the partition number and choose Drop….

   

2. Follow these steps, as instructed by the wizard:

   • Drop Database Partition from Database Partition Groups

   • Redistribute Data

   • Drop Database Partitions from Instance

Using the command...