Disabling database connection validation for Db2 after installation or upgrade

You can disable the validation check for all Db2 database connections.

About this task

If NodePort services are disabled, an error prompt appears each time the validation check runs. You can bypass this issue by setting the enableDatabaseConnection parameter to false in the database's custom resource.

When this change is made, the new setting takes effect for every new database deployment.

Procedure

  1. Run the following command to patch the Db2oltpService CR to set enableDatabaseConnection=false:
    oc patch Db2oltpService db2oltp-cr --namespace=${PROJECT_CPD_INSTANCE} 
    --type=merge --patch '{"spec": {"enableDatabaseConnection": false}}'
  2. Run the following command to check that the service is in Completed state:
    oc get Db2oltpService db2oltp-cr --namespace=${PROJECT_CPD_INSTANCE} -o jsonpath='{.status.db2oltpStatus} {"\n"}'
  3. Restart the zen-database-core pod by deleting the pod.
    oc delete $(oc get po -n ${PROJECT_CPD_INSTANCE} -oname | grep zen-database-core) -n ${PROJECT_CPD_INSTANCE}