Handle specific sideload errors after backup and restore of Watson Query

Important: IBM Cloud Pak® for Data Version 4.6 will reach end of support (EOS) on 31 July, 2025. For more information, see the Discontinuance of service announcement for IBM Cloud Pak for Data Version 4.X.

Upgrade to IBM Software Hub Version 5.1 before IBM Cloud Pak for Data Version 4.6 reaches end of support. For more information, see Upgrading IBM Software Hub in the IBM Software Hub Version 5.1 documentation.

After you run a backup and restore, you might encounter errors in which sideloading fails to validate.

Symptoms

When you run oc logs c-db2u-dv-db2u, you see the following error messages.
+ sudo -E db2uctl sideload load --validate
Error: setup fail

Resolving the problem

Log in to the hurricane pod and delete the db2sched log file by running the following commands.

  1. Change to the project where Watson Query pods are installed.
    oc project ${PROJECT_CPD_INSTANCE}
  2. Log in to the hurricane pod.
    oc -n rsh $(oc -n get pods | grep -i c-db2u-dv-hurricane | cut -d' ' -f 1) bash
  3. Switch to the Watson Query database instance owner db2inst1.
    su - db2inst1
  4. Delete the db2sched log file.
    rm -rf /var/ibm/bigsql/logs/db2sched.log