Db2 change selector - Connect_CDC - aws_mainframe_modernization_service - connect_cdc_mimix_share - 6.x

Connect CDC Getting Started Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
6.x
Language
English
Product name
Connect CDC
Title
Connect CDC Getting Started Guide
Copyright
2024
First publish date
2003
Last updated
2024-10-15
Published on
2024-10-15T20:38:41.117981

The Change Selector is a process, a Connect CDC executable, that identifies data that has changed during replication and stores this data in a change queue until it is distributed to the target tables. The changed data includes SQL row operation changes, specifically INSERT, UPDATE, and DELETE in the context of an SQL transaction.

The IBM i Installation Guide specifies how to install the Change Selector on IBM i. The DB2 Change Selector is used for replication on DB2 servers only and differs from the Oracle Change Selector, described in Oracle change selector. A Change Selector for UDB DB2 models is automatically added during installation.

Note the following when using UDB:

  • You must set up UDB with archive logging, not circular logging.

  • Tables must have data change capture enabled.

  • Bringing the database down always forces the Change Selector to stop.