Db2 z/OS - connect_cdc_sqdata - Latest

Connect CDC (SQData) Change Data Capture

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
Latest
Language
English
Product name
Connect CDC (SQData)
Title
Connect CDC (SQData) Change Data Capture
Copyright
2024
First publish date
2000
Last updated
2024-11-25
Published on
2024-11-25T15:05:48.570404

The Connect CDC (SQData) Db2/z Log Reader Capture utilizes the LogMiner API to gain access to log data.

Attribute Db2/z Log Reader
Data Capture Latency Near-Real-Time or Asynchronous
Capture Method Log Miner
Unit-of-Work Integrity Committed Only
Output Datastore Options TCP/IP
Runtime Parameter Method SQDCONF
Auto-Disable Feature Yes
Auto-Commit Feature Yes
Multi-Target Assignment Yes
Include/Exclude Filters Correlation ID, Db2 Plan, Authorization ID
Transaction Include/Exclude Yes
DDL Change Tracking Optional support for Replicator Schema Evolution

The following sections provide a detail level reference to installation, configuration and operation of the Connect CDC (SQData) Capture Agent for Db2:

  • Db2/z Log Reader Capture
  • Operation
  • Operating Scenarios including
    • initial target load and refresh
    • capture new Db2/z data
    • Db2/z straight replication
    • Db2/z active/active replication