Disabling database connection validation for Db2 Warehouse after installation or upgrade

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

About this task

You can disable the connection validation by setting the enableDatabaseConnection parameter to false in the Db2 Warehouse custom resource after installing or upgrading.

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

Procedure

To apply the change before installing or upgrading the service:
1. Run the following command to patch the Db2whService CR to set enableDatabaseConnection=false:
```
oc patch Db2whservice db2wh-cr --namespace=${PROJECT_CPD_INSTANCE} --type=merge --patch '{"spec": {"enableDatabaseConnection": false}}'
```
To apply the change after installing or upgrading the service:
1. Run the following command to check that the service is in Completed state:
```
oc get Db2whService db2wh-cr --namespace=${PROJECT_CPD_INSTANCE} -o jsonpath='{.status.db2whStatus} {"\n"}'
```
2. Restart the zen-database-core pod by deleting the pod.
```
kubectl delete pod --grace-period=0 --force -n PROJECT DB2U-StatefulSet-POD
```