Preparing to install Db2 Data Gate

Installing Db2 Data Gate requires a number of installation and configuration steps be performed on IBM Z® and on IBM Cloud Pak® for Data. Additional steps are required to connect these systems.

Certain installation and configuration tasks might be best performed by people in different roles.

The tasks and steps in the following table should be preformed in the order listed in the table for ease of installing and configuring Db2 Data Gate. However, depending on your environment, some steps might be optional if they are already complete (for example, if the Db2 for z/OS® subsystem is already running with all current maintenance, or if inbound network access to the Db2 for z/OS subsystem is already configured).

Because of the different user roles required and potentially different system environments, consider creating a high-level plan to manage, coordinate, and track all major planning, installation, and configuration activities, using this roadmap as a guide.

Table 1. Db2 Data Gate planning, installation, and configuration roadmap
Type Task User role
Plan Review the Db2 Data Gate system requirements
  • z/OS system administrator or programmer
  • Cloud Pak for Data cluster administrator
  • Cloud Pak for Data instance administrator
  • Db2 Data Gate administrator
Prepare Configure inbound access to Db2 for z/OS:
  1. Define a secure network port
  2. Configure AT-TLS
z/OS system administrator or network administrator
Prepare Encrypt outbound network access from Db2 for z/OS to the Db2 Data Gate service:
  1. Create a key ring that includes the CA certificate
  2. Generate and export a key pair and a certificate for Db2 Data Gate
  3. Configure the Policy Agent on your z/OS client LPARs
Important: Steps 2 and 3 require the OpenShift® route hostname, port, and IP address of the Db2 Data Gate instance and might best be done after you create a Db2 Data Gate instance. However, you can perform the tasks with proper planning of the hostname, port, and IP address.
z/OS system administrator or network administrator
Install Install the Db2 Data Gate PTF on IBM Z
Important: If you have installed IBM Db2 Analytics Accelerator for use with the same Db2 for z/OS system, then this PTF already exists. In this case, skip this step.
z/OS system administrator or programmer
Install Installing Db2 maintenance to enable Db2 Data Gate z/OS system administrator or Db2 installation system operator (Install SYSOPR authority)
Configure Configure Db2 for z/OS to support Db2 Data Gate:
  1. Set Db2 for z/OS subsystem parameters
  2. Create Db2 for z/OS databases and tables for Db2 Data Gate
    Important: If you have installed IBM Db2 Analytics Accelerator for use with the same Db2 for z/OS system, then this database and the required system tables already exist. In this case, skip this step.
  3. Verify the setup of Db2-supplied stored procedures
z/OS system administrator or Db2 installation system operator (Install SYSOPR authority)
Configure Create and set up Db2 Data Gate stored procedures.
Important: If you have installed IBM Db2 Analytics Accelerator for use with the same Db2 for z/OS system, you already have the required stored procedures. Besides, you are not allowed to create another set of stored procedures with the same names. Therefore, you need not create an additional WLM environment, and you need not define performance goals. In that case, skip the following steps.
  1. Create a dedicated WLM environment for Db2 Data Gate stored procedures
  2. Define WLM performance goals for Db2 Data Gate stored procedures
  3. Create the Db2 Data Gate stored procedures
z/OS system administrator or programmer
Configure Create Db2 Data Gate users and grant privileges on Z
  • z/OS system administrator or programmer with Unix service system skills
  • Security administrator
Install and Configure Install, provision, and configure a Db2 instance for Db2 Data Gate on Cloud Pak for Data
  • Cloud Pak for Data instance administrator
  • Db2 administrator
Install Install Db2 Data Gate service on Cloud Pak for Data Cloud Pak for Data instance administrator
Install and configure Post-installation setup for Db2 Data Gate
  • Cloud Pak for Data instance administrator
  • Db2 Data Gate administrator