IBM Db2 target

TwinCommit applies changes to IBM Db2 LUW with array-bound MERGE statements. The checkpoint is updated in the same unit of work, so a restart never loses or repeats a transaction.

Supported: Db2 LUW 11.5 and 12.1 · Db2 Warehouse (row-organized tables).

Configuration

target:
  type: db2
  database: REPLDB
  host: db2-target.internal
  port: 50000
  user: twincommit
  password: ${DB2_TARGET_PASSWORD}
  schema: REPLICA

How apply works

Inserts and updates use MERGE INTO ... USING (VALUES (?, ?, ...)) with array input.
Deletes are array-bound DELETE.
The checkpoint row is updated in the same unit of work before COMMIT.

Grants

GRANT CONNECT ON DATABASE TO USER twincommit;
GRANT CREATETAB ON DATABASE TO USER twincommit;
GRANT CREATEIN, ALTERIN ON SCHEMA REPLICA TO USER twincommit;
GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE REPLICA.ORDERS TO USER twincommit;