IBM Db2 for i

Overview

Replicate Preview supports efficient data replication to and from IBM Db2 for i, enabling it to be configured as both a source and target endpoint. Users can quickly create replication pipelines by selecting source objects and defining target destinations, allowing reliable data movement across IBM i environments with minimal configuration effort. The platform simplifies replication management while maintaining consistent and scalable data delivery for enterprise workloads.

Note
IBM Db2 for i 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 i versions 7.4 through 7.6 are supported.

User Permissions

Using IBM Db2 for i as source connection

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

The following are the user permissions required using IBM Db2 for i as source in Snapshot mode:

*USE authority on the source libraries
*OBJOPR authority on source tables/files
SELECT privilege on the source tables

Library-Level Authority

Grant the user access to the source libraries:

GRTOBJAUT OBJ(MYLIB) OBJTYPE(*LIB) USER(REPLUSER) AUT(*USE)

Table/File-Level Authority

Grant read access to all physical files/tables:

GRTOBJAUT OBJ(MYLIB/*ALL) OBJTYPE(*FILE) USER(REPLUSER) AUT(*USE)

SQL SELECT Access

If SQL security is enforced, grant explicit SELECT permissions:

GRANT SELECT ON TABLE MYLIB.MYTABLE TO USER REPLUSER;

Or at schema/library level:

GRANT SELECT ON ALL TABLES IN SCHEMA MYLIB TO USER REPLUSER;

Additional Considerations