Configuring Db2 Warehouse to disable automatic setting of kernel parameters

You can override the default, automatic setting of interprocess communication (IPC) kernel parameters that normally takes place when the Db2 Warehouse service is initialized and set the kernel parameters manually.

About this task

When you configure Db2 Warehouse for isolated deployment, a limited privileged SCC is automatically deployed.

Procedure

  1. Patch the Db2whservice CR with the privileged setting by running the following command:
    oc patch Db2whservice db2wh-cr --type merge -p '{"spec":{"privileged":false}}'
  2. If you have the Db2oltpservice CR or the Db2aaservice CR running in your cluster, patch those services by running the following commands:
    oc patch Db2oltpservice db2oltp-cr --type merge -p '{"spec":{"privileged":false}}'
    oc patch Db2aaserviceservice db2aaservice-cr --type merge -p '{"spec":{"privileged":false}}'
  3. Wait for the Db2 Warehouse service to be in Completed state.
    To get the state value, run the following command:
    oc get Db2whservice db2wh-cr -o jsonpath='{.status.db2whStatus} {"\n"}'
  4. Deploy the Db2 Warehouse instance.

What to do next

Configure your OpenShift® Container Platform environment to deploy with limited privileges. See Changing kernel parameter settings for more information.