Upgrading Watson Query from Version 4.6 to Version 4.7

Information you need to complete this task

Review the following information before you upgrade Watson Query:

Version requirements

All the components that are associated with an instance of Cloud Pak for Data must be installed at the same release. For example, if the Cloud Pak for Data control plane is at Version 4.7.4, you must upgrade Watson Query to Version 4.7.4.

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

Common core services

Watson Query requires the Cloud Pak for Data common core services.

If the common core services are not at the correct version in the operands project for the instance, the common core services are automatically upgraded when you upgrade Watson Query. The common core services upgrade increases the amount of time the upgrade takes to complete.

Storage requirements

You don't need to specify storage when you upgrade Watson Query.

Before you begin

This task assumes that the following prerequisites are met:

Prerequisite services

Before you upgrade Watson Query, ensure that the following services are upgraded and running:

• Db2® Data Management Console: If you do not manually upgrade Db2 Data Management Console, Watson Query upgrades it for you. If you have already upgraded Db2 Data Management Console, make sure that a Db2 Data Management Console instance has been provisioned. For more information, see Upgrading Db2 Data Management Console.

Procedure

Complete the following tasks to upgrade Watson Query:

1. Upgrading the service
2. Validating the upgrade
3. Upgrading the service instance
4. Upgrading remote connectors
5. What to do next

Upgrading the service

To upgrade Watson Query:

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.
2. Update the custom resource for Watson Query.

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

Validating the upgrade

[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=dv

Upgrading the service instance

After you upgrade Watson Query, you must upgrade the service instance that is associated with Watson Query.

To upgrade the service instance:

1. Log in to the cluster as a user with sufficient permissions to complete the task.

   oc login ${OCP_URL}

2. Change to the project where Watson Query pods are installed.

   oc project ${PROJECT_CPD_INST_OPERANDS}

3. Get the name of the Watson Query service instance:

   cpd-cli service-instance list --service-type=dv

4. Set the WQ_INSTANCE_NAME environment variable to the name of the instance that you want to upgrade:

   export WQ_INSTANCE_NAME=<instance-name>

5. Run the following command to upgrade the instance:

   cpd-cli service-instance upgrade 
   --instance-name=${WQ_INSTANCE_NAME} \
   --service-type=dv \
   --profile=${CPD_PROFILE_NAME} \
   

6. Run one of the following commands to verify that the version now reads 2.1.3:

   • cpd-cli service-instance list

   • oc get bigsql db2u-dv -o jsonpath='{.status.version}{"\n"}'

   You must wait until the instance upgrade completes before you proceed to the next step.

Upgrading remote connectors

You can upgrade remote connectors by using the UPDATEREMOTECONNECTOR stored procedure. You can run this procedure by using the SQL editor or the Db2 console on the cluster.

• To update all remote connectors, run the following stored procedure.

  call dvsys.updateremoteconnector('',?,?)

• If you need to upgrade a set of remote connectors, pass in a comma-separated list.

  call dvsys.updateremoteconnector('<REMOTE_CONNECTOR_NODES>',?,?)

  You can obtain the <REMOTE_CONNECTOR_NODES> by running the following command.

  select node_name from dvsys.listnodes where AGENT_CLASS='R'

What to do next

1. After you upgrade, all active or inactive caches with refresh schedules are reset. You must edit the active caches and set the refresh rate again. For more information, see Adding data caches in Watson Query.

When you upgrade to Watson Query on Cloud Pak for Data version 4.7.3, the old .jar files remain in the directory $IBM_DB_HOME/function/jar/DVSYS. This does not affect any of the Watson Query functionality and no workaround is necessary.

Watson Query is ready to use. For more information, see Virtualizing data with Watson Query.