Installing Db2 Warehouse

Information you need to complete this task

Review the following information before you install Db2 Warehouse:

Version requirements

All of the components that are associated with an instance of IBM Software Hub must be installed at the same release. For example, if the IBM Software Hub control plane is installed at Version 5.2.2, you must install Db2 Warehouse at Version 5.2.2.

Environment variables

The commands in this task use environment variables so that you can run the commands exactly as written.

• If you don't have the script that defines the environment variables, see Setting up installation environment variables.
• To use the environment variables from the script, you must source the environment variables before you run the commands in this task. For example, run:

  source ./cpd_vars.sh

Security context constraint

Db2 Warehouse works with the default Red Hat® OpenShift® Container Platform security context constraint, restricted-v2.

Db2 Warehouse requires a custom security context constraint (SCC). For more information, see Creating the custom SCC for Db2 Warehouse.

Storage requirements

You don't need to specify storage information when you install Db2 Warehouse.

Before you begin

This task assumes that the following prerequisites are met:

System requirements

This task assumes that the cluster meets the minimum requirements for Db2 Warehouse.

Where to find more information
If this task is not complete, see System requirements.

Workstation

This task assumes that the workstation from which you will run the installation is set up as a client workstation and has the following command-line interfaces:

• IBM Software Hub CLI: cpd-cli
• OpenShift CLI: oc

Where to find more information
If this task is not complete, see Setting up a client workstation.

Control plane

This task assumes that the IBM Software Hub control plane is installed.

Where to find more information
If this task is not complete, see Installing an instance of IBM Software Hub.

Private container registry

If your environment uses a private container registry (for example, your cluster is air-gapped), this task assumes that the following tasks are complete:

1. The Db2 Warehouse software images are mirrored to the private container registry.

   Where to find more information
   If this task is not complete, see Mirroring images to a private container registry.

2. The cpd-cli is configured to pull the olm-utils-v3 image from the private container registry.

   Where to find more information
   If this task is not complete, see Pulling the olm-utils-v3 image from the private container registry.

Custom SCC

This task assumes that the custom security context constraint (SCC) for Db2 Warehouse exists.

Where to find more information
If this task is not complete, see Creating the custom SCC for Db2 Warehouse.

Load balancer

The load balancer timeout settings are adjusted for Db2 Warehouse.

Where to find more information
If this task is not complete, see Changing load balancer settings.

Process IDs limit

The process IDs limit setting is adjusted for Db2 Warehouse.

Where to find more information
If this task is not complete, see Changing the process IDs limit.

Kernel parameters

The kernel parameter settings are adjusted for Db2 Warehouse.

Where to find more information
If this task is not complete, see Changing kernel parameter settings.

SMT settings

The simultaneous multithreading (SMT) settings for Kernel-based Virtual Machine (KVM) capable systems and big core PowerVM capable systems are adjusted, if applicable.

Where to find more information
If this task is not complete, see Changing Power settings.

Red Hat OpenShift AI

If you plan to use features that require Red Hat OpenShift AI, this task assumes that Red Hat OpenShift AI is installed.

Where to find more information
If this task is not complete, see Installing Red Hat OpenShift AI.

Procedure

Complete the following tasks to install Db2 Warehouse:

1. Installing the service
2. Validating the installation
3. What to do next

Installing the service

To install Db2 Warehouse:

1. Log the cpd-cli in to the Red Hat OpenShift Container Platform cluster:

   ${CPDM_OC_LOGIN}

   Remember: CPDM_OC_LOGIN is an alias for the cpd-cli manage login-to-ocp command.
2. Run the following command to create the required OLM objects for Db2 Warehouse in the operators project for the instance:

   cpd-cli manage apply-olm \
   --release=${VERSION} \
   --cpd_operator_ns=${PROJECT_CPD_INST_OPERATORS} \
   --components=db2wh

   Wait for the cpd-cli to return the following message before you proceed to the next step:

   [SUCCESS]... The apply-olm command ran successfully

   If the apply-olm fails, see Troubleshooting the apply-olm command during installation or upgrade.

3. Create the custom resource for Db2 Warehouse.

   cpd-cli manage apply-cr \
   --components=db2wh \
   --release=${VERSION} \
   --cpd_instance_ns=${PROJECT_CPD_INST_OPERANDS} \
   --license_acceptance=true

Validating the installation

[SUCCESS]... The apply-cr command ran successfully

If you want to confirm that the custom resource status is Completed, you can run the cpd-cli manage get-cr-status command:

cpd-cli manage get-cr-status \
--cpd_instance_ns=${PROJECT_CPD_INST_OPERANDS} \
--components=db2wh

What to do next

You must complete Post-installation setup for the Db2 Warehouse service before users can access the Db2 Warehouse service.

You can also set up Deploying Q Replication for Db2 Warehouse.