Questions tagged [ibm-data-replication]
28 questions
1
vote
1 answer
IBM Data Replication - How do I retrieve and replicate a column from another table?
Site: Oracle Exadata as Source and Netezza as Target
Scenario: Records of Table A are being replicated to the Target, during replication, these records are to be tagged with a specific date (a.k.a rundate) from Table B.
Table A (contains many…
Sarah Orvis
- 71
- 6
1
vote
1 answer
CDC log retention for Informix
Actual Situation:
We use IBM Data Replication (11.4) to replicate Data from an Informix Database to an SQL Server Database.
Now we have an instance with 45 different subscriptions. On the informix side, we have 30 different log files.
The…
Sarah Orvis
- 71
- 6
1
vote
1 answer
Supported table types: Replication engine for DB2 LUW
While browsing through the IBM Data Replication documentation for CDC 11.4.0, I stumbled upon the following page which describes the supported table types for DB2…
Sarah Orvis
- 71
- 6
1
vote
1 answer
Using Data Replication's Kafka transactionally consistent consumer - how to configure? Is staging in Kafka better than writing to WebHDFS?
We have established working subscription on IBM Data Replication CDC Replication Engine for Kafka. Messages (replicated transactions) started to appear on target kafka topics.
Our goal is to create a program which reads these messages from kafka and…
Sarah Orvis
- 71
- 6
1
vote
1 answer
Can CDC technology replicate changes into Kafka?
We need to capture and share changes from our DB2 z/OS environment into a Kafka based information hub. We have tried ETL tools to do similar but we are concerned about the impact of ETL on our source DB2 z/OS environment.
Kevin Wei
- 165
- 11
0
votes
0 answers
About the control processing method of the apply application when using the IIDR Event Publishing
I am considering Db2 replication using IIDR (IBM's DB replication product) 11.4.0.
I am thinking of adopting the event publishing method instead of the Q replication method.
In the Q replication method, if LOAD processing is performed on the source…
xmaverick
- 23
- 5
0
votes
1 answer
Schema Registry URL for IIDR CDC Kafka subscription
I have created a cluster Amazon MSK. Also, created an EC2 instance and installed Kafka on it to create a topic in Amazon MSK. I am able to produce/consume messages on the topic using Kafka scripts.
I have also installed the IIDR Replication agent on…
dossani
- 1,892
- 3
- 14
- 23
0
votes
1 answer
How to input source and target database parameters in IBM Data Replication 11.4.0.4?
Though IBM states it supports Oracle, there is no clear cut documentation on how to provide the input parameters like the TNS names inside either the IIDR configuration tool or the Management Console.
IIDR Configuration not allowing Oracle…
0
votes
2 answers
IBM CDC Table should already have been refreshed. Transformation Server will terminate
I have a table with both source and target as IBM DB2 iSeries. The replication method is Mirror. After refresh before mirroring, the message Table / should already have been refreshed. Transformation Server will terminate. occurs and…
