Creating a DataPropagator subscription

A DataPropagator subscription provides specifications for how data in a source table is to be synchronized to a table on the mobile device. Each subscription that you create can reference one or more tables.

Restrictions

For DataPropagator subscriptions, the mirror database must be located on the same server as the replication engine. The DataPropagator Capture program is not able to capture any remote databases.

Prerequisites

Ensure that the table is defined in DB2 Universal Database as a replication source, and that you defined at least one NOT nullable, primary key column for the table. (For information on defining replication sources, see DB2 Universal Database Replication Guide and Reference).

Procedure

To create a DataPropagator subscription:

  1. Open the Create DataPropagator subscription notebook in the Mobile Devices Administration Center.
  2. Identify the subscription.
  3. Specify the encryption level.
  4. Map the source database on the enterprise system to its target database on the mobile device.
  5. Identify the mirror database. If you set up synchronization in a three-tier structure, the mirror is on the mid-tier system.
  6. Add source tables to the subscription and provide information about what SQL privileges you will allow for those tables.
  7. Optional: Specify how to filter the data in the source table.

    For example, do you want all data in the source table to be replicated in every synchronization? Only certain rows? The data filtering you specify for the subscription applies to all groups that use the subscription.

  8. Specify how you want to batch synchronization requests by defining a period of time to elapse between replication processes.
  9. Provide the user ID and password that will be used to access the source system on the group's behalf.
  10. Click OK.

Related concepts