Overview

Replicate Preview enables structured and reliable data replication between IBM Db2 for z/OS and other supported platforms. By supporting both source and target configurations, users can define replication pipelines that move data efficiently across mainframe and distributed environments. The platform reduces operational complexity while ensuring controlled and consistent data delivery for Db2 for z/OS workloads.

Note

IBM Db2 for z/OS is currently supported only as source 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 for z/OS versions 12 and 13 are supported.

User Permissions

The user configured for Snapshot extraction from IBM Db2 for z/OS should have permissions to:

• CONNECT privilege to the Db2 subsystem

• SELECT privilege on source tables/views

• USE privilege on required table spaces

• Access to Db2 catalog tables for metadata discovery

GRANT CONNECT TO REPLUSER;
GRANT SELECT ON TABLE MYSCHEMA.MYTABLE TO REPLUSER;

Grant SELECT on All Tables in a Schema

Depending on security policies, permissions may need to be granted individually or through roles/groups.

Example using a role:

GRANT SELECT ON TABLE MYSCHEMA.MYTABLE TO ROLE REPLROLE;
GRANT ROLE REPLROLE TO REPLUSER;

Catalog Access Requirements

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

Syniti Knowledge Platform uses Db2 catalog tables to discover schemas, tables, and columns. Ensure the user can query catalog objects such as:

• SYSIBM.SYSTABLES

• SYSIBM.SYSCOLUMNS

• SYSIBM.SYSINDEXES

In many environments, catalog read access is available by default, but some installations restrict it through RACF or security exits.

Related Articles

• Create a Connection

• Configure Workspace: Datastores

• Connecting to IBM Db2 for z/OS