For incremental replication from multimember files on Db2 for i, perform the following tasks:
The default for the multiMember configuration parameter is true. Examine the agent configuration to verify that either the parameter is not present, or is set to true. If it is present and set to false, change it to true or remove it and save the configuration. This will cause the agent to restart and will flag all existing subscriptions for that agent as needing a new baseline. If you later set multiMember back to false, existing subscriptions will again be flagged for new baselines.
The database file must be journaled, either with autoJournal or other methods. See Journaling.
To replicate a member other than the first member of the file, do one of the following:
Enable the AS/400 Multi Member File Access checkbox in Advanced Properties of the Source in StarQuest Data Replicator Manager. This causes the Subscription Wizard to display a dropdown field for member selection in the Select the Source dialog. See the StarQuest Data Replicator Manager help for details on using Multimember support in Replicator Manager.
Use SQL to create an ALIAS for each member that you wish to replicate, and use StarQuest Replication Manager to create and manage incremental subscriptions based on the ALIAS objects.
CREATE ALIAS MYLIB.MYFILE_MYMBR FOR MYLIB.MYFILE(MYMBR)