Uninstalling Db2 Big SQL

An instance administrator can uninstall Db2 Big SQL.

Who needs to complete this task?

Instance administrator To uninstall Db2 Big SQL, 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 Big SQL 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 Big SQL on the cluster.

Information you need to complete this task

Review the following information before you uninstall Db2 Big SQL:

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 Big SQL:

Deleting service instances
Uninstalling the service

Deleting service instances

Before you uninstall Db2 Big SQL, you must delete any service instances that are associated with Db2 Big SQL 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 Big SQL.

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 bigsql type.
Delete each bigsql instance in the list.

Uninstalling the service

To uninstall Db2 Big SQL:

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 for Db2 Big SQL.

cpd-cli manage delete-cr \
--cpd_instance_ns=${PROJECT_CPD_INST_OPERANDS} \
--components=bigsql \
--include_dependency=true

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

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

Delete the OLM objects for Db2 Big SQL:

cpd-cli manage delete-olm-artifacts \
--cpd_operator_ns=${PROJECT_CPD_INST_OPERATORS} \
--components=bigsql

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

[SUCCESS]... The delete-olm-artifacts command ran successfully