Destination IBM Db2 #

The extracted replicant-cli will be referred to as the $REPLICANT_HOME directory in the proceeding steps.

I. Setup Connection Configuration #

1. From $REPLICANT_HOME, navigate to the sample connection configuration file:

   vi conf/conn/db2.yaml
   

2. Make the necessary changes as follows:

   type: DB2
   
   database: tpch
   host: localhost
   port: 50002
   
   username: replicant
   password: "Replicant#123"
   
   #ssl:
   #  trust-store:
   #    path: '/path/to/truststore'
   #    password: 'Replicant#123'
   
   max-connections: 30
   
   max-retries: 10
   retry-wait-duration-ms: 1000
   
   #proxy-source: false
   

II. Setup Applier Configuration #

1. From $REPLICANT_HOME, navigate to the applier configuration file:

   vi conf/dst/db2.yaml
   

2. Make the necessary changes as follows:

   snapshot:
     threads: 16
   
   #  batch-size-rows: 10_000
   #  txn-size-rows: 1_000_000
   
   #  bulk-load:
   #    enable: true
   #    type: FILE
   #    save-file-on-error: true
   #    serialize: true
   
     #deferred-delete: true
     #optimized-upsert: true
     #use-quoted-identifiers: false
   

For a detailed explanation of configuration parameters in the applier file, read Applier Reference.