Destination IBM Db2 #
The extracted replicant-cli
will be referred to as the $REPLICANT_HOME
directory in the proceeding steps.
I. Setup Connection Configuration #
-
From
$REPLICANT_HOME
, navigate to the sample connection configuration file:vi conf/conn/db2.yaml
-
If you store your connection credentials in AWS Secrets Manager, you can tell Replicant to retrieve them. For more information, see Retrieve credentials from AWS Secrets Manager.
Otherwise, you can put your credentials like usernames and passwords in plain form like the sample below:
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 #
-
From
$REPLICANT_HOME
, navigate to the applier configuration file:vi conf/dst/db2.yaml
-
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.