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 an instance administrator: 
    oc login OpenShift_URL:port
  2. Change to the project where OpenPages 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