Adding a replication source

This task is part of the larger task of creating a DataPropagator subscription. When you have completed these steps, return to Creating a DataPropagator subscription.

Procedure

  1. Ensure that you defined the table as a DB2 DataPropagator replication source. You can use the Centro de control de DB2 to define the replication source. For more information, see the DB2 Universal Database Replication Guide and Reference.

    Because replication sources can be used and managed by tools other than the DB2 Everyplace Sync Server, when you define the source ensure that you control access to the data in a way that all applications can take advantage of.

  2. On the Identification page of the Create DataPropagator subscription notebook, click the

    push button to choose a source database from a list.
  3. 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 represents a unique qualifier that the Sync Server 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 program runs, DataPropagator replicates data for all subscriptions with the same Apply qualifier. The Apply qualifier defaults to the name of the mirror database.

  4. In the Define Replication Subscription window, click Add. The Add window opens.
  5. In the Replication source list, select the replication sources to add to this subscription.
  6. In the Access privileges field, 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 training nurses are allowed only to view the data, you need to create two different subscriptions to handle this difference in access privileges. These subscriptions must use separate mirror tables. For more information about SQL access privileges, see the DB2 Universal Database Consulta de SQL.

    After you add a replication source to the subscription, you can change only the SQL access privileges defined for the source.

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

    Within the same subscription, a source table can be mapped to more than one target table name. However, DB2 DataPropagator uses a single change data table to replicate changes to and from both target tables.

  8. Click Add to add the replication source to the subscription.

Conceptos relacionados

Tareas relacionadas