Creating a JDBC subscription to access source data

The Mobile Devices Administration Center used to manage the Sync Server subscriptions and mobile users.

This task is part of the greater task of Setting up Synchronization. When you have completed the steps below, return to Setting up Synchronization

Procedure

  1. Open the Mobile Devices Administration Center and DB2 Control Center:
  2. Right-click on the Subscriptions folder in the Mobile Devices Administration Center. Select Create --> Table subscription --> JDBC Subscription.
  3. Type a name for the JDBC subscription in the Name field. This example uses SCHEDULE.
  4. Optional: Type a description for the JDBC subscription in the Description field. This example uses VNSchedule test subscription
  5. Select the encryption level for the JDBC subscription in the Encryption level field. This example uses None
  6. On the Source page, identify the name of the source database from which data is to be synchronized.
  7. Type the source database URL in the Database URL field. This example uses jdbc:db2:vnurse
  8. Type a valid source database user ID and password in the User ID, Password, and Verify password fields. It is required that the same user ID and password is used for each Sync Server subscription that connects to a single source database if multiple subscriptions are connecting to the same database.
  9. Click the Test Connection push button to test the connection to the JDBC source database.
    Poznámka:
    If you testing the connection to a Lotus Domino data source and the connection fails, you must exit the Mobile Devices Administration Center and restart.
  10. Click Close.
  11. On the Mirror page, identify the mirror database that the Sync Server will use to cache data.
  12. Click the dots push button next to the Database URL field and select M_VN2 in the Select Mirror Database window. Click OK.
  13. Type a valid mirror database user ID and password in the User ID, Password, and Verify password fields. This example uses user ID db2admin.
  14. Click the Test Connection push button to test the connection to the JDBC mirror database. Click Close on the DB2 Message.
  15. Click the Identification tab.
  16. Select the Define Subscription push button. The Define Replication Subscription window opens.
  17. In the Define Replication Subscription window, click Add. The Add Table window opens.
  18. Identify the tables in the source database whose content will be synchronized. From the Table list of the Add Table window, select the replication source to add to this subscription. To change the source filter used to limit the available tables in the table list, click Filter.
  19. Select DSYSAMPLE.VNSCHEDULE from the Table list. The Target schema and Target table fields are automatically completed.
    Poznámka:
    If you are accessing a Lotus Domino data source, you must enter a schema name in the Target schema field. DSYSAMPLE.VNSCHEDULE is an example only. The Target schema field is not automatically complete.
  20. Optional: If you want to include the constraints and indexes from the source tables, select Use Constraints defined in DB2 source and Use indexes defined in DB2 source.
  21. Click Add. Click Close. Return to the Define Replication Subscription window.
  22. Optional: To add a primary key:
  23. Click the Timing push button in the Define Replication Rubscription window.
  24. In the Batch Window field, specify the amount of time, in seconds, to wait before starting replication. For example, if you type 60, changes will be replicated to the source database after with intervening intervals of 60 seconds. Click OK.
  25. Click OK to close the Define Replication Subscription window.
  26. Click OK to close the Create JDBC Subscription notebook. If the OK button is grayed out, all of the fields have not been filled in correctly.

DB2 Everyplace Sync Server is now configured to synchronize the data in this table using JDBC. Next you will create a DataPropagator subscription.

Související koncepce

Související úlohy