Upgrading Db2 Data Management Console from Version 4.0 to Version 4.6

Information you need to complete this task

Review the following information before you upgrade Db2 Data Management Console:

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:

  source ./cpd_vars.sh

Installation location

Db2 Data Management Console is installed in the same project (namespace) as the Cloud Pak for Data control plane. This project is identified by the ${PROJECT_CPD_INSTANCE} environment variable.

Storage requirements

You don't need to specify storage when you upgrade Db2 Data Management Console.

Before you begin

This task assumes that the following prerequisites are met:

Procedure

Complete the following tasks to upgrade Db2 Data Management Console:

1. Logging in to the cluster
2. Updating the operator
3. Upgrading the service
4. Validating the upgrade
5. Upgrading the service instance
6. What to do next

Logging in to the cluster

To run cpd-cli manage commands, you must log in to the cluster.

To log in to the cluster:

1. Run the cpd-cli manage login-to-ocp command to log in to the cluster as a user with sufficient permissions to complete this task. For example:

   cpd-cli manage login-to-ocp \
   --username=${OCP_USERNAME} \
   --password=${OCP_PASSWORD} \
   --server=${OCP_URL}

   Tip: The login-to-ocp command takes the same input as the oc login command. Run oc login --help for details.

Updating the operator

The Db2 Data Management Console operator simplifies the process of managing the Db2 Data Management Console service on Red Hat® OpenShift Container Platform.

To upgrade Db2 Data Management Console, ensure that all of the Operator Lifecycle Manager (OLM) objects in the ${PROJECT_CPD_OPS} project, such as the catalog sources and subscriptions, are upgraded to the appropriate release. All of the OLM objects must be at the same release.

Who needs to complete this task?

You must be a cluster administrator (or a user with the appropriate permissions to install operators) to create the OLM objects.

When do you need to complete this task?

Complete this task only if the OLM artifacts have not been updated for the current release using the cpd-cli manage apply-olm command with the --upgrade=true option.

It is not necessary to run this command multiple times for each service that you plan to upgrade. If you complete this task and the OLM artifacts already exist on the cluster, the cpd-cli will recreate the OLM objects for all of the existing components in the ${PROJECT_CPD_OPS} project.

To update the operator:

1. Update the OLM objects:

   cpd-cli manage apply-olm \
   --release=${VERSION} \
   --cpd_operator_ns=${PROJECT_CPD_OPS} \
   --upgrade=true

   • If the command succeeds, it returns [SUCCESS]... The apply-olm command ran successfully.
   • If the command fails, it returns [ERROR] and includes information about the cause of the failure.

What to do next: Upgrade the Db2 Data Management Console service.

Upgrading the service

After the Db2 Data Management Console operator is updated, you can upgrade Db2 Data Management Console.

Who needs to complete this task?

You must be an administrator of the project where Db2 Data Management Console is installed.

When do you need to complete this task?

Complete this task for each instance of Db2 Data Management Console that is associated with an instance of Cloud Pak for Data Version 4.6.

To upgrade the service:

1. Update the custom resource for Db2 Data Management Console.

   cpd-cli manage apply-cr \
   --components=dmc \
   --release=${VERSION} \
   --cpd_instance_ns=${PROJECT_CPD_INSTANCE} \
   --license_acceptance=true \
   --upgrade=true

Validating the upgrade

Db2 Data Management Console is upgraded when the apply-cr command returns [SUCCESS]... The apply-cr command ran successfully.

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

cpd-cli manage get-cr-status \
--cpd_instance_ns=${PROJECT_CPD_INSTANCE} \
--components=dmc

Upgrading the service instance

After you upgrade Db2 Data Management Console, you must upgrade the service instance that is associated with Db2 Data Management Console.

To upgrade the service instance:

1. Get the Db2® Data Management Console instance name.

   oc get dmc -n ${PROJECT_CPD_INSTANCE}

2. Edit the Db2 Data Management Console instance.

   oc edit dmc {instance-name} -n ${PROJECT_CPD_INSTANCE}

3. Change the version to 4.6.4.

   cat << EOF | oc apply -f -
   apiVersion: dmc.databases.ibm.com/v1
   kind: Dmc
   spec:
     arch: x86_64
     version: 4.6.4
     description: "Data Management Console"
     scaleConfig: small
     storageClass: "YOUR_STORAGECLASS"
     storageSize: 10Gi   
     license:
       accept: true 
       license: Standard   
   EOF

4. Save your changes and exit.

What to do next