Adding database partitions

One of the notable advantages of database partitioning is scalability. Let us suppose that we want to supplement the processing power by providing more CPUs and memory, or we intend to add a new server in the infrastructure to increase processing power. In any of these cases, we should add one or more partitions to our existent database proportionally with the supplementary processing power, in order to benefit from the scalability of the multipartitioned environment. It is recommended to allocate a minimum of one CPU per database partition.

Getting ready

In the following recipe, we will add two new partitions, one on nodedb21 and one on nodedb22.

How to do it...

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

Using Control Center

1. In Control Center, right-click to navigate to the db2instp instance, and then right-click and choose Add Database Partitions….

   

2. In the Add Database Partitions Wizard screen, click on the Next button, and next click...