Please enable JavaScript to view this site.

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

See the Db2/z Quickstart for a step by step illustration of the Db2/z Capture configuration and operation using the Connect CDC SQData ISPF panels.

 

Db2/z Quickstart - Procedures and screen shots that illustrate a fast and simple method of creating, configuring and

running the components required for Db2/z changed data capture.

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

a.Initial Target Load and Refresh

b.Capture New Db2/z Data

c.Db2/z Straight Replication

d.Db2/z Active/Active replication

•Db2/z Capture Troubleshooting

See the Change Data Capture Guide for an overview of the role capture plays in Precisely's Connect CDC SQData enterprise data integration product, the common features of the capture agents and the transient storage and publishing of captured data to Engines running on all platforms.