The actions performed by an Apply Engine are described by an Engine Script. In this example the script might define the simple mapping and data transformation required for replication of the changes captured from DB2 on z/OS to the target Kafka Cluster. The script must contain a section similar to the one below, which describes the content and source of the CDC records for two employee related tables:
...
-- -------------------------------------------------------------
-- DATA DEFINITION SECTION
-- -------------------------------------------------------------
DESCRIPTION SQLDDL ~\sqdata\DB2DDL\emp_table.ddl AS empddl;
DESCRIPTION SQLDDL ~\sqdata\DB2DDL\dept_table.ddl AS deptddl;
--
DATASTORE cdc://zos_host_name/Capture_publisher_agent_name/engine_name
OF UTSCDC
AS CDCIN
DESCRIBED BY
empddl
,deptddl
;
...Notes:
- zos_host_name will contain the actual host name of the z/OS system where the DB2 database Capture Agent and its Controller Daemon run.
- Capture_publisher_agent_name will contain the alias name assigned to the CDC Store in the Agent Configuration File which is also specified in the Capture Agent Configuration file, not discussed in this document. See the DB2 Capture Reference Manual for more information about the configuration of that Capture Agent.
- If the Engine will use a TLS connection the remote Publisher running under IBM's (AT-TLS), the "cdcs://" URL syntax type must be specified.