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:
- Run the following command to patch the Db2whService CR to set
enableDatabaseConnection=false:
oc patch Db2whservice db2wh-cr --namespace=${PROJECT_CPD_INST_OPERANDS} --type=merge --patch '{"spec": {"enableDatabaseConnection": false}}'
- To apply the change after installing or upgrading the service:
- Run the following command to check that the service is in
Completed
state:
oc get Db2whService db2wh-cr --namespace=${PROJECT_CPD_INST_OPERANDS} -o jsonpath='{.status.db2whStatus} {"\n"}'
- Restart the
zen-database-core pod by deleting the pod.
oc delete pod $(oc get po -n ${PROJECT_CPD_INST_OPERANDS} -oname | grep zen-database-core) -n ${PROJECT_CPD_INST_OPERANDS}