I am trying to sync data from a DB2 instance. When I create the connector, the sync starts and all the data from the DB2 is read. The problem happens when I add more data into the DB2 afterward. The new data is not being captured. I do not get any errors regarding the connector.
My Connector configuration :
{
"name": "core-banking-DB2-source-v3",
"config": {
"connector.class": "io.debezium.connector.db2.Db2Connector",
"database.hostname": "102.10.12.90",
"database.port": "50000",
"database.user": "db2inst1",
"database.password": "12345@",
"database.server.id": "1",
"database.server.name": "DB2-command",
"database.dbname": "monolith",
"table.include.list": "DB2INST1.BANKING_CORE_USER",
"database.history.kafka.bootstrap.servers": "localhost:9092",
"database.history.kafka.topic": "dbhistory.DB2INST1" ,
"include.schema.changes": "true",
"decimal.handling.mode": "double",
"key.converter":"io.confluent.connect.avro.AvroConverter",
"key.converter.schema.registry.url":"http://localhost:8070",
"value.converter":"io.confluent.connect.avro.AvroConverter",
"value.converter.schema.registry.url":"http://localhost:8070",
"transforms": "unwrap,addTopicPrefix",
"transforms.unwrap.type": "io.debezium.transforms.ExtractNewRecordState",
"transforms.addTopicPrefix.type":"org.apache.kafka.connect.transforms.RegexRouter",
"transforms.addTopicPrefix.regex":"(.*)",
"transforms.addTopicPrefix.replacement":"core-DB2-$1"
}
}
I tried changing configurations according to this answer, but got the same problem. I also tried using the JDBC connector, which gave errors in creating the connector.