0 / 0
Replicating IBM Db2 Warehouse data

Replicating IBM Db2 Warehouse data

You can replicate data from other databases to IBM Db2 Warehouse with Data Replication.

IBM Db2 Warehouse is an analytics data warehouse that gives you a high level of control over your data and applications.

Restriction

You can use this connection only as a target for Data Replication. You cannot use this connection as a source connection.

Before you begin

Create a database user for Data Replication. Ask your Db2 Warehouse administrator to add a user for Data Replication in the Db2 Warehouse console. The administrator must add you by clicking Add user with user privilege User selected, not Add IBMid user (Administrator is not required). Request the Db2 hostname, port number, and database name.

Connecting to Db2 Warehouse in a project

To connect to Db2 Warehouse in a project in Cloud Pak for Data as a Service, see IBM Db2 Warehouse connection.

After you select a target, the schema mappings are displayed. The target schema is set to the default, which creates a schema with the same name as the source schema. If you change the value, Data Replication replicates to a schema with the name you specified. If no such schema exists, replication fails to start.

Next step

Starting Data Replication

Parent topic: Supported Data Replication connections

Generative AI search and answer
These answers are generated by a large language model in watsonx.ai based on content from the product documentation. Learn more