Preparing Data Gate instance provisioning for a remote Db2 target database

You can create a Data Gate instance that connects to a remote Db2 target database from the provisioning UI or by submitting an API call.

Before you begin

Make sure that the required secure network connection exists. See step 1 in Connecting to a remote Db2 instance.

About this task

Data Gate supports connecting to a remote Db2 instance which can reside in a different Cloud Pak for Data cluster or on a remote external Db2 instance. For more information, see Connecting to a remote Db2 instance.

Procedure

To create a Data Gate service instance with a remote Db2 target database from the provisioning UI, you must first enable remote Data Gate target support by patching the Data Gate service custom resource.
  1. To do this, run the following command before provisioning, which exposes the Use a remote Db2 database option in the UI.
    export INSTANCE_NAMESPACE=''
    oc patch datagateservice datagateservice-cr \
      -n "${INSTANCE_NAMESPACE}" \
      --type json \
      --patch '[{"op":"replace","path":"/spec/enableRemoteDb2Target","value":true}]'

    The Use a remote Db2 database option becomes visible in the provisioning UI after you've patched the custom resource.