--- title: "IBM Db2 LUW" slug: "ibm-db2-luw-overview-replicate-cloud" updated: 2026-06-11T14:14:00Z published: 2026-06-11T14:14:00Z canonical: "skthelp.syniti.com/ibm-db2-luw-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 LUW ## 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] > 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 ```plaintext 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; ``` ## Catalog Access Requirements If you do not have a connection configured, refer to [Connecting to IBM Db2 LUW](/v1/docs/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. 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 LUW](/v1/docs/connecting-to-ibm-db2-luw)