Replicating from Multi-Member Tables

If you plan to replicate data from a Db2 multi-member table running on i (iSeries/AS400), you have the following options available:

  • Replicate the entire table (default members) by setting up a replication to the main table. Follow the Steps for Replicating a Table Using Refresh Mode, or the Steps for One-Way Mirroring Between Tables.
    Note: in most cases replication is successful from a table using a name that matches the default member name.However, when the names do not match, the replication works some operations, such as the table REORG and TRUNCATE are not detected. In such cases, set the Filter By Member Name property in the Connection Properties to True, refresh the table schema and verify that the ‘Base Member’ property of the table is correctly set with the default member name. If the property is set to true, when reading the Journal a filter will be used with the default member of the table. This will prevent "journal entries not found" errors caused by operations executed on non-default members of the table.

  • Replicate one or more member tables by creating aliases for each of the member tables you plan to use, then setting up replications using the aliases. The steps below provide more information.

Replicating Member Tables

  1. On your System i, create a table alias for each member table from which you want to replicate. The SQL syntax for creating a table alias is as follows:
    CREATE ALIAS EMPLOYEE_EUROPE FOR EMPLOYEE(EMPEUROPE)
    where EMPLOYEE_EUROPE is the alias created for member EMPEUROPE of multi-member table EMPLOYEE.

  2. Follow the Steps for Replicating a Table Using Refresh Mode, or the Steps for One-Way Mirroring Between Tables to set up a replication using the alias you have created on the Db2 system and the target table.
    If you are replicating from several member tables, you can set up multiple replications using the Multiple Replications wizard.