Synchronization Server Help


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

You must define at least one replication source for every JDBC or Upload subscription.

These steps are part of the larger task of creating a JDBC or Upload subscription or editing a JDBC or Upload 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. On the Identification page of the JDBC or Upload Subscription notebook, click Define subscription. The Define Replication Subscription window opens.

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

  3. In the Add Table window, use the Table list to select the replication source to add to this subscription.

    Click Filter to change the source filter used to limit the available tables in the table list. The Filter window opens.

    The % symbol is a wildcard. Typing % in the Source schema and Source table fields displays all available tables in the table list.

  4. In the Target schema field, specify the schema that the table will have on the mobile device. If you do not specify a schema, the system uses the schema of the source table by default.

  5. 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.

  6. 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.

  7. Optional: Select the Use Constraints defined in selected DB2 source checkbox. This enables the constraints from the selected DB2 source table for the the target table.

  8. Optional: Select the Use Indexes defined in selected DB2 source checkbox. This enables the indexes from the selected DB2 source table for the the target table.

  9. Click Add to add the replication source to the subscription. Click Close to close the Add Table window.

Return to Creating a JDBC subscription or Editing a JDBC subscription, or Creating an Upload subscription or Editing an Upload subscription.


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