Changes have been made on how Data Gate updates the necessary target Db2 or Db2
Warehouse configuration changes.
About this task
Starting from the Data Gate 5.1.3
release, changes have been made on how Data Gate for z/OS updates the necessary target Db2 or
Db2 Warehouse configuration changes. Data Gate controls the Db2 variables.
Note: If a Db2/Db2 Warehouse change is needed in one of the variables (see variables
here), it must be applied to the
dg-{{
zenServiceInstanceId }}-target-db2-variables-cm as described below. If the change in a
Db2/Db2 variable that is owned by
Data Gate is
not applied to the
dg-{{ zenServiceInstanceId }}-target-db2-variables-cm then it
might be lost.
Procedure
-
When Db2 for z/OS Data-Gate is installed, a new configmap
named
dg-{{ zenServiceInstanceId }}-target-db2-variables-cm is created in the
cluster. This configmap has the Db2 or Db2 Warehouse variables on CP4D (Software Hub) that can be
changed. During installation all settings have as value: data_gate_default_value_for_db2.
- To change a configuration setting in Db2 or Db2 Warehouse on CP4D (Software Hub), you
should replace inside the
configmap dg-{{ zenServiceInstanceId
}}-target-db2-variables-cm the default value of the variable you need to change
(data_gate_default_value_for_db2), with your desired value, and save the configmap
dg-{{ zenServiceInstanceId }}-target-db2-variables-cm. To perform this task:
source ./cpd_vars.sh
oc project ${PROJECT_CPD_INST_OPERANDS}
oc get cm | grep target-db2-variables-cm
oc edit cm dg-{{ zenServiceInstanceId }}-target-db2-variables-cm
- Finish editing
dg-{{ zenServiceInstanceId }}-target-db2-variables-cm and
save the file
- For the changes to be applied to Db2 or Db2 Warehouse on CP4D (Software Hub), you need to
manually delete the Data Gate pod and let the
pod restart. To delete the Data Gate pod:
source ./cpd_vars.sh
oc project ${PROJECT_CPD_INST_OPERANDS}
oc get po | grep dg-{{ zenServiceInstanceId }}-data-gate
oc delete po dg-{{ zenServiceInstanceId }}-data-gate-xxx
Important:To apply the new Db2 or Db2 Warehouse on CP4D (Software Hub)
changes, the database (Db2 or Db2 Warehouse) on CP4D will be restarted when the Data Gate pod is restarted. Plan this restart
accordingly.