Skip to main content
The Db2 LUW Source Connector streams inserts, updates and deletes from Db2 for Linux, UNIX and Windows into Popsink in real time. It does not read the Db2 log itself. IBM’s ASN Capture process copies each change of a registered table into a change table, and the connector reads those change tables. So every prerequisite below lives on the Db2 server.
For Db2 for i (AS/400, IBM i), use the IBM i Source instead.

​
Prerequisites

  • Archive logging on the database (LOGARCHMETH1 set to anything but OFF). Capture reads changes from the log, so a circular log loses them.
  • The asncdc UDF installed and ASN Capture running. Start it with:
  • Each table to capture registered in ASN and active:
ADDTABLE also turns DATA CAPTURE CHANGES on for the table. Capture’s first start sets every registration to inactive, so start Capture before activating them. When you pick tables, the table list shows each one that is not ready and the statement that fixes it.

​
Limitations

  • BOOLEAN columns are not supported. ASN Capture cannot write a BOOLEAN into a change table, and it then stops for every registered table. Change the column to SMALLINT, or leave the table out.
  • CLOB and BLOB values arrive as null. ASN Capture does not copy LOB values into its change tables. Such a table can still be replicated, without those values.

​
Configuration

​
Connecting through an SSH Tunnel

If the database is only reachable through a bastion host, enable SSH Tunnel and provide: The Host and Port above stay as the database is addressed from the bastion. For key generation, bastion hardening and the other connectivity options (IPsec VPN, Tailscale), see Tunnels and private connectivity.

​
Topics

Each table is published to its own topic, named <prefix>.<SCHEMA>.<TABLE>, and gets its own data model.