Uninstalling Db2 Warehouse

An instance administrator can uninstall Db2 Warehouse.

Who needs to complete this task?

Instance administrator To uninstall Db2 Warehouse, you must be an instance administrator. An instance administrator has permission to manage software in the following projects:

The operators project for the instance: The operators for this instance of IBM Software Hub are installed in the operators project. In the uninstall commands, the ${PROJECT_CPD_INST_OPERATORS} environment variable refers to the operators project.
The operands project for the instance: The IBM Software Hub control plane and the services for this instance of IBM Software Hub are installed in the operands project. In the uninstall commands, the ${PROJECT_CPD_INST_OPERANDS} environment variable refers to the operands project.

When do you need to complete this task?

Complete this task if you want to remove Db2 Warehouse from an instance of IBM Software Hub.

Repeat as needed If you are responsible for multiple instances of IBM Software Hub, you can repeat this task to remove other instances of Db2 Warehouse on the cluster.

Information you need to complete this task

Review the following information before you uninstall Db2 Warehouse:

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
```

Procedure

Complete the following tasks to uninstall Db2 Warehouse:

Deleting service instances

Before you uninstall Db2 Warehouse, you must delete any service instances that are associated with Db2 Warehouse to ensure that each instance releases the resources that it reserved.

Who needs to complete this task?: A user with the Manage service instances permission must complete this task.

When do you need to complete this task?: Complete this task before you uninstall Db2 Warehouse.

From the IBM Software Hub web client:

Log in to the web client as a user with sufficient permissions to complete the task.
From the menu, select Services > Instances.
Filter the list to show the db2wh type.
Delete each db2wh instance in the list.

Uninstalling the service

To uninstall Db2 Warehouse:

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.

Delete the custom resource and operator for Db2 Warehouse.

cpd-cli manage uninstall-components \
--instance_ns=${PROJECT_CPD_INST_OPERANDS} \
--components=db2wh \
--include_dependency=true

Wait for the cpd-cli to return the following message:

[SUCCESS]... The uninstall-components command ran successfully