Overview

Replicate Preview streamlines data replication for IBM Db2 environments by supporting Db2 LUW as both a source and target endpoint. Users can rapidly configure replication pipelines by selecting source datasets and target mappings, enabling efficient data transfer with reduced setup and maintenance overhead. The platform manages replication execution while ensuring reliable and scalable data movement across distributed Db2 environments.

Note

IBM Db2 LUW is currently supported as both a source and target endpoint in Replicate Preview, limited to Snapshot (full load) replication mode, with Change Data Capture (CDC) and streaming replication not yet supported.

Supported Versions

IBM Db2 LUW versions 11.5 and 12.1 are supported.

User Permissions

The user configured for Snapshot extraction from IBM Db2 LUW should have permissions to:

• Connect to the database

• Access the required schemas

• Read source table data

• Read metadata definitions for tables and columns

At a minimum, the user should have:

• CONNECT privilege on the database

• USAGE privilege on the required schemas

• SELECT privilege on source tables/views

• Access to system catalog views for metadata discovery

GRANT CONNECT ON DATABASE TO USER REPLUSER;
GRANT USAGE ON SCHEMA MYSCHEMA TO USER REPLUSER;
GRANT SELECT ON TABLE MYSCHEMA.MYTABLE TO USER REPLUSER;
GRANT SELECT ON ALL TABLES IN SCHEMA MYSCHEMA TO USER REPLUSER;

Metadata Discovery Considerations

If you do not have a connection configured, refer to Connecting to IBM Db2 LUW for more information.

The Syniti Knowledge Platform uses Db2 catalog views to discover schemas, tables, and column definitions. Ensure the user can access catalog objects such as:

• SYSCAT.TABLES

• SYSCAT.COLUMNS

• SYSCAT.SCHEMATA

In most Db2 LUW environments, catalog access is available by default to users with CONNECT privilege.

Related Articles

• Create a Connection

• Configure Workspace: Datastores

• Connecting to IBM Db2 LUW