IBM Db2

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.