Upgrading from IBM Cloud Pak for Data Version 4.5 to Version 4.6

Specifically, ensure that you review the System requirements. Your cluster must have sufficient resources.

oc get installplan

• If the install plan approval is Automatic, you can proceed to the next step.
• If the install plan approval is Manual, review the following options:

  Option	Details
  Change the install plan to Automatic (recommended)	It is strongly recommended that you change the install plan for the IBM Cloud Pak foundational services operators and Cloud Pak for Data operators to Automatic. This enables the cpd-cli manage commands to seamlessly update the operators. To update the install plan for the operators: For the IBM Cloud Pak foundational services operators, see the Changing approval strategy from Manual to Automatic in the IBM Cloud Pak foundational services documentation. For the Cloud Pak for Data operators, update the install plans for each operator through the Red Hat OpenShift Container Platform console. Open each subscription, view the subscription details, and edit the Update approval setting. For a list of the Cloud Pak for Data operators, see Creating operator subscriptions in the IBM Cloud Pak for Data Version 4.0 documentation. Important: Ensure that the install plan of all the operators in the ${PROJECT_CPFS_OPS} project and ${PROJECT_CPD_OPS} project are set to Automatic. If any of the install plans are set to Manual, Operator Lifecycle Manager (OLM) will automatically update the install plans to Manual when you run the cpd-cli manage apply-olm command.
  Leave the install plan as Manual	You can optionally leave the install plan for the IBM Cloud Pak foundational services operators and Cloud Pak for Data operators Manual. Important: If you choose this option, you must watch the install plans and manually approve them during the upgrade to ensure that the cpd-cli manage apply-olm commands complete successfully. Additionally, you must repeat this process each time that you upgrade the operators to a newer release. Run the appropriate commands based on where your operators are installed: The IBM Cloud Pak foundational services operators and Cloud Pak for Data operators are installed in the same project (express installation) After you run the cpd-cli manage apply-olm command, open a new terminal window. Run the following command to watch the project where the operators are installed: watch oc get installplan -n ${PROJECT_CPFS_OPS} Manually approve each install plan as it is created. The IBM Cloud Pak foundational services operators and Cloud Pak for Data operators are installed in different projects (specialized installation) After you run the cpd-cli manage apply-olm command, open two new terminal windows. In the first terminal window, run the following command to watch the project where the IBM Cloud Pak foundational services operators are installed: watch oc get installplan -n ${PROJECT_CPFS_OPS} In the second terminal window, run the following command to watch the project where the Cloud Pak for Data operators are installed: watch oc get installplan -n ${PROJECT_CPD_OPS} Manually approve each install plan as it is created by setting spec.approved to true.

• Watson Knowledge Studio

For upgrades to 4.6.3 or 4.6.4 only: You must make a backup of your data.

1. Open a remote shell in the zen-metastoredb-0 pod and copy the certificate that's required to connect to the database:

   oc exec -it zen-metastoredb-0 \
   --namespace=${PROJECT_CPD_INSTANCE} \
   -- bash \
   -c "cp -r /certs/ /tmp/;cd /tmp/ && chmod -R  0700 certs/;cd /cockroach"

2. Query the database for any apostrophes:

   oc exec -it zen-metastoredb-0 \
   --namespace=${PROJECT_CPD_INSTANCE} \
   -- /cockroach/cockroach sql \
   --certs-dir=/tmp/certs/ \
   --host=zen-metastoredb-0.zen-metastoredb  \
   --database=zen \
   --execute="SELECT uid, username, \"displayName\" FROM platform_users WHERE username LIKE '%'||chr(39)||'%' OR \"displayName\" LIKE '%'||chr(39)||'%';SELECT uid, vault_name, description FROM vaults where description LIKE '%'||chr(39)||'%' OR vault_name LIKE '%'||chr(39)||'%';SELECT group_id, description, name FROM user_groups where description LIKE '%'||chr(39)||'%' OR name LIKE '%'||chr(39)||'%';SELECT uid, secret_name, description FROM secrets where description LIKE '%'||chr(39)||'%' OR secret_name LIKE '%'||chr(39)||'%';SELECT id, display_name, description FROM connections where description LIKE '%'||chr(39)||'%' OR display_name LIKE '%'||chr(39)||'%';SELECT id, extension_name FROM custom_extensions where extension_name LIKE '%'||chr(39)||'%';"

   The query returns output with the following format:

     uid | username | displayName
   ------+----------+--------------
   (N rows)
   
     uid | vault_name | description
   ------+------------+--------------
   (N rows)
   
     group_id | description | name
   -----------+-------------+-------
   (N rows)
   
     uid | secret_name | description
   ------+-------------+--------------
   (N rows)
   
     id | display_name | description
   -----+--------------+--------------
   (N rows)
   
     id | extension_name
   -----+-----------------
   (N rows)

   • If all the entries in the output return (0 rows), proceed with the upgrade.
   • If any entries in the output include a value other than (0 rows), contact IBM Software Support

In the event of an unrecoverable failure, you can use the backup to recover your existing installation. For details, see Backing up and restoring Cloud Pak for Data.