Valid target database unavailable

Creating a Data Gate instance does not show a valid target database.

Symptoms

When creating a Data Gate instance, even if there is a valid target database instance, it does not show from the data gate provisioned UI.

Causes

Db2 increased the version to 11.5.9.0 in Cloud Pak for Data TBD, but Data Gate did not update the support Db2 version list, so the Db2 instance was filtered out from the UI.

Resolving the problem

Run the following command to add 11.5.9.0 into the support list temporally, then refresh the data gate provision UI:

oc patch configmap datagate-definition-cm -n ${PROJECT_CPD_INST_OPERANDS} -p '{"data":{"supported-db2-version":"{\"db2oltp\":[\"11.5.8.*\",\"11.5.9.*\"],\"db2wh\":[\"11.5.8.*\",\"11.5.9.*\"]}"}}'