Adding a member identifier

If you have installed the CDC Replication Engine for Db2® for i on your source system and want to replicate a multi-member source table to a single-member target table, then you need to identify each member in the source table.

Before you begin

Before adding a member identifier, you need to create a column on the target table that can maintain the identifiers for the members in your source table. After creating the target column, map the journal control field &MEMBER to this column.

About this task

1. Ensure that you have mapped a CDC Replication Engine for Db2 for i multi-member source table to a single-member target table on any platform
2. Click Configuration > Subscriptions.
3. Select the subscription.
4. Click the Table Mappings view and select the table mapping from the Source Table column.
5. Right-click and select Open Details....
6. Click the Operation tab.
7. Click Member Identifiers.
8. Click Add.
9. Enter the name of the member for which you want to add an identifier in the Member Name box.
10. Expand the Target Columns tree and double-click to select the target column you want to include in the member identifier WHERE clause.
11. Click Verify to make sure the expression is valid and click OK.

    You can continue adding identifiers for each member in your source table.

12. Click OK.
13. Click Save.