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