0

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.

OneCricketeer
  • 179,855
  • 19
  • 132
  • 245
DevSathiz
  • 11
  • 2

0 Answers0