Scaling the OpenPages database server pod

You can scale the Db2® database server pod.

Before you begin

Review the minimum system requirements before you make changes. See System requirements.

About this task

Note: If you are using a database that is outside of IBM Cloud Pak® for Data, this task does not apply.
For the Db2 database server pod, you can:
  • Increase or decrease the number of vCPUs.
  • Increase or decrease the memory.
Tip: To check the current vCPUs and memory of the database server, run the following command:
oc describe sts/c-db2oltp-<*>-db2u-sts
For example,
oc describe sts/c-db2oltp-1601355983782494-db2u-sts
Note: Run scaling operations when the cluster is quiet.

Procedure

  1. Log in to your Red Hat® OpenShift® cluster as a project administrator: 
    oc login OpenShift_URL:port
  2. Change to the project where the IBM Cloud Pak for Data control plane is installed: 
    oc project <Project>
  3. Back up your OpenPages® environment.
    For more information, see Backing up, restoring, and migrating OpenPages.
  4. To increase or decrease the number of vCPUs and the memory for the database server, run the following command: 
    oc set resources sts <StatefulSet_name> --limits=cpu=<cpu_count>,memory=<memory_size>  --requests=cpu=<cpu_count>,memory=<memory_size>

    Replace the following values:

    Variable Value
    <StatefulSet_name> Specify the name of the StatefulSet for the database.

    To find the name of the StatefulSet, run oc get sts and look for a name with the pattern c-db2oltp-*-db2u.

    For example, c-db2oltp-1601355983782494-db2u
    <cpu_count> Specify the number of vCPUs to use.
    <memory_size> Specify the RAM to use.
    For example,
    oc set resources sts c-db2oltp-1601355983782494-db2u --limits=cpu=4,memory=12Gi --requests=cpu=4,memory=12Gi