--- title: "IBM Db2 for i" slug: "ibm-db2-for-i-overview-replicate-cloud" updated: 2026-06-11T14:11:04Z published: 2026-06-11T14:11:04Z canonical: "skthelp.syniti.com/ibm-db2-for-i-overview-replicate-cloud" --- > ## Documentation Index > Fetch the complete documentation index at: https://skthelp.syniti.com/llms.txt > Use this file to discover all available pages before exploring further. # 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] > 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 If you do not have a connection configured, refer to [Connecting to IBM Db2 for i](/v1/docs/connecting-to-ibm-db2-for-i) for more information. #### Using IBM Db2 for i as source connection 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: ```plaintext GRTOBJAUT OBJ(MYLIB) OBJTYPE(*LIB) USER(REPLUSER) AUT(*USE) ``` **Table/File-Level Authority** Grant read access to all physical files/tables: ```plaintext GRTOBJAUT OBJ(MYLIB/*ALL) OBJTYPE(*FILE) USER(REPLUSER) AUT(*USE) ``` **SQL SELECT Access** If SQL security is enforced, grant explicit SELECT permissions: ```plaintext GRANT SELECT ON TABLE MYLIB.MYTABLE TO USER REPLUSER; ``` Or at schema/library level: ```plaintext GRANT SELECT ON ALL TABLES IN SCHEMA MYLIB TO USER REPLUSER; ``` #### **Additional Considerations** - The user does **not** require `*ALLOBJ` authority for Snapshot extraction - The user does **not** require change-management or administrative privileges - Access to IBM i catalog views (`QSYS2`, `SYSIBM`) may be required for metadata discovery - If journals or CDC features are not being used, no journaling permissions are necessary In Replicate Preview, configure your workspace using this system datastore and start replicating data. Refer to [Configure Workspace: Datastores](/v1/docs/configure-workspace-datastores) for more information. ## Related Articles - [Create a Connection](/v1/docs/create-a-connection) - [Configure Workspace: Datastores](/v1/docs/configure-workspace-datastores) - [Connecting to IBM Db2 for i](/v1/docs/connecting-to-ibm-db2-for-i)