Scaling your IBM® Db2 Warehouse cluster up and down

You can change the resources available to your Db2® Warehouse deployment to accommodate changing workloads.

About this task

This task describes how to increase or decrease CPU and memory resources on your Db2 Warehouse hosts.

Restriction:

To perform this task, you need to have root authority.

Stop services on the head node (MPP) or the single node (SMP).
```
docker exec -it Db2wh stop
```
Stop the container on the node where the machine you want to modify is hosted.
```
docker stop Db2wh
```
Shut down the machine that you want to modify.
Make the relevant changes, such as adding or reducing RAM or the number of CPUs.
Power® on the machine that you modified.
Start the stopped container on the modified node hosts.
```
docker start Db2wh
```
On the head node, start the Db2 Warehouse services.
```
docker exec –it Db2wh start
```

You can see the new memory and processing details by clicking Settings > System Settings in the web console or by issuing the following command:

docker exec -it Db2wh get_system_info