Setting member identifiers

IBM® i environments supports a table concept known as multi-member files, in which one table can possess several different members. Each member is part of the same table and shares the same schema, but the members are uniquely named and have unique data. 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. CDC Replication requires an identifier so that it does not truncate rows when it applies a refresh to a single-member target table.

If you do not specify an identifier for your multi-member source table, then each time CDC Replication applies a refresh to the single-member target, the member data on the target is overwritten by data from another member.