Please enable JavaScript to view this site.

Navigation: Change Data Capture

UDB (DB2/LUW)

Scroll

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

Attribute

UDB 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

Plan, User ID

Transaction Include/Exclude

Yes

 

While the configuration and operation of the Connect CDC SQData Engine is virtually identical on all platforms, the capture agents operate under constraints that vary from one platform to another.

UDB (Db2/LUW) is essentially no different in this respect from other database managers with only a few exceptions:

UDB Recovery Log

Unit-of-Work Integrity

Storage and Publishing