Synchronization Server Help
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.

To add a replication source to the subscription:
- On the Identification page of the JDBC
or Upload Subscription notebook, click Define subscription.
The Define Replication Subscription window opens.
- In the Define Replication Subscription window, click
Add. The Add Table window opens.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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 ]