Completing the installation and configuring CDC

Read how to complete the installation and configure IBM InfoSphere® Change Data Capture for z/OS (CDC) for an optimal performance of the incremental update function.

1. Check and make sure that you meet the system requirements for CDC at:
   System requirements for InfoSphere CDC for z/OS. This includes the following steps (among others):
   1. Creating a z/OS user ID for running the CDC started task.
      Because it makes the maintenance process easier, it is recommended that you use the same ID as the security identifier <CHCMetaID>, which is the owner of the CDC metadata tables (see steps 4.b and 4.c). However, if your organization's security policy demands that you use different IDs, you can do so.

      Important:

      • If the ID for running the CDC started task and the security identifier <CHCMetaID> are the same, make sure that the password of this user ID is at least 4 characters long. It is possible to define a shorter password, but that will cause problems when you try to update IBM Db2 Analytics Accelerator in the future. If the IDs are different, the one for the CDC started task does not require a password, but the security identifier does.
      • Set the password of this user ID so that it never expires. This prevents unwanted interruptions of the incremental update process.
   2. Defining an OMVS segment for this user ID because the ID needs to access TCP/IP services.
   This user ID requires SYSCTRL authorization in addition to other authorizations, including SELECT authorization for all tables to be processed by the incremental update function.
2. Complete the necessary preinstallation steps as described in Before you install InfoSphere CDC for z/OS.
   In one of the steps, you define a port number for the CDC address space used for communication between the CDC agents on z/OS and the accelerator. The default port is 5999.
3. Using the SMP/E Apply function, add required program temporary fixes (PTFs) for the CDC capture engine to your base installation.
   (You installed the CDC base as you completed step 1). The recommended PTFs are listed in:

   IBM Db2 Analytics Accelerator for z/OS - Incremental Update Function using IBM InfoSphere Data Replication

   You find all available PTFs for the CDC capture engine here:

   Release Notes for IDR Db2 for z/OS

4. Complete the steps in section Completing the installation using the distributed sample jobs of the CDC information center.
   Basically, this task comprises the following steps:
   1. Creating the configuration control data set and copying members into this data set.
      The settings in this control data set are read and processed during the initialization of the CDC address space.
   2. Defining a security identifier for use of the CDC address space to ensure a controlled access to the relevant Db2 subsystems and the CDC metadata tables.
   3. Customizing and running a number of jobs to prepare your Db2 subsystems for CDC.
      For example, the CHCMDMUT job creates the metadata tables for CDC. You must customize this job and specify the security identifier (<CHCMetaID>) as the owner of these tables. The security identifier becomes the schema name of the metadata tables.