Enabling a source database for replication

To set up your IBM® Integrated Analytics System or standalone Db2 Warehouse for replication, you first enable a source database.

Before you begin

  • Use the web console to create unique replication user IDs on both the source and target databases while logged in as an administrator:
    • Grant DBADM authority to both of these user IDs.
    • Do not use the replication user IDs to perform any database operations that need to be replicated.
  • When launching the data replication feature to enable it as a source and for subsequent use, ensure that you access the user interface by using a permanent hostname in the URL. For example, on the IAS platform, launch the user interface by using the floating hostname and not a node-specific hostname.
  • Ensure that all Db2 partitions are running before you enable the source for replication.

About this task

You perform this step after activating the license for IBM Data Replication for Availability.

Procedure

  1. While logged in as the replication user, go to the Data Replication screen, look for the card that says Enable a source database to begin, and click Enable source as shown in Figure 1
    Figure 1. Enable source database button
    Enable button below graphic with text "Enable source database to begin"
  2. Provide the source IP address (private or public), port, user name, and password.
    Note: You must use secure port 50,001, not the unsecured port 50,000.
  3. Provide permission to make changes to the source database and click OK.
    A series of messages show the configuration steps as they occur.

Results

After confirmation that the database is enabled, you return to the Data Replication screen, where you can add new targets and new replication sets.

To enable a source database, the console:

  • Sets the logarchmeth1 parameter to LOGRETAIN so that Db2 recovery logs that are needed for replication are saved.
  • Sets the dft_schemas_dcc parameter to YES to set DATA CAPTURE CHANGES on all newly created schemas.
  • Sets the log_ddl_stmts parameter to YES so that additional logging information is added for Data Definition Language (DDL) changes.
  • Sets the log_appl_info parameter to YES to add an application information log record to each updated transaction.
  • Creates IBM MQ objects at the source system to transport replicated data.
  • Creates control tables on the source database that are used to save configuration information about the replication environment and monitoring data.