Synchronization Server Help


Specifying source tables, target tables, and privileges for the subscription

You must define at least one replication source for every DataPropagator subscription.

These steps are part of the larger task of creating a DataPropagator subscription or editing a DataPropagator subscription. When you complete the steps for specifying source tables, target tables, and privileges for a subscription, return to the main task.


Figure dsyh016 not displayed.

To add a replication source to the subscription:

  1. Ensure that you defined the table as a DB2 DataPropagator replication source. You can use the DB2 Control Center to define the replication source. For more information, see the DB2 Universal Database Replication Guide and Reference or the Control Center online help. Replication sources can be used and managed by tools other than the DB2 Everyplace Sync Server, so when you define the source, ensure that you control access to the data in a way that all subscription sets can take advantage of.

  2. On the Identification page of the DataPropagator Subscription notebook, click Define subscription. The Define Replication Subscription window opens.

    The Subscription name field reflects the name of the subscription that you entered on the Identification page; the Apply qualifier field shows a unique qualifier that the Mobile Devices Administration Center uses for all subscriptions defined for this database.

    The Apply qualifier streamlines the process of synchronizing the mid-tier mirror database with its master database on the enterprise system; when the Apply process runs under the control server, DataPropagator replicates data for all subscriptions with the same Apply qualifier. The Apply qualifier defaults to the name of the mirror database, and can be changed.

  3. In the Define Replication Subscription window, click Add. The Add window opens.

  4. In the Add window, use the Replication source list to select the replication sources to add to this subscription.

  5. Under Access privileges, select the SQL access privileges that you want users of this subscription to have for this replication source. For example, if some of your visiting nurses are allowed to insert, update, or delete data, but trainee nurses are allowed only to view the data, you need to create two different subscriptions to handle the difference in access privileges. For more information about SQL access privileges, see the DB2 Universal Database Administration Guide: Design and Implementation.

  6. In the Target table field, specify the name that the table will have on the mobile device. If you do not specify a name, the system uses the name of the source table by default. The Create target table check box is always disabled.

  7. Click Add to add the replication source to the subscription. The Add window closes.

[Return to creating a DataPropagator subscription or editing a DataPropagator subscription]


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]