IBM DB2 Everyplace Sync Server Administration Guide Version 7 Release 2 Modification 1
The Mobile Devices Administration Center is used to manage the Sync Server
subscriptions and mobile users. To create a JDBC subscription:
- Open the Mobile Devices Administration Center and DB2 Control
Center:
- For Windows, select Start --> Programs --> IBM DB2
Everyplace--> Start Mobile Devices Administration Center.
- For UNIX, change the directory to $DSYINSTDIR/Server, then run
dsyadmin.sh.
- Right-click on the Subscriptions folder in the Mobile Devices
Administration Center. Select Create --> Table subscription
--> JDBC Subscription.
- Type a name for the JDBC subscription in the Name field.
This example uses SCHEDULE.
- Type a description for the JDBC subscription in the Description
field. This example uses VNSchedule test subscription
- Select the encryption level for the JDBC subscription in the
Encryption level field. This example uses None
- On the Source page, identify the name of the source database from
which data is to be synchronized.
- Type the source database URL in the Database URL field.
This example uses jdbc:db2:vnurse
- Type a valid source database user ID and password in the User
ID, Password, and Verify password fields.
This example uses user ID db2admin. 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.
- Click the Test Connection push button to test the connection to
the JDBC source database.
- Click Close.
- On the Mirror page, identify the mirror database that the Sync
Server will use to temporarily cache data.
- Click the
push button next to the Database URL field and select
M_VN2 in the Select Mirror Database window. Click
OK.
- Type a valid mirror database user ID and password in the User
ID, Password, and Verify password fields.
This example uses user ID db2admin.
- Click the Test Connection push button to test the connection to
the JDBC mirror database. Click Close on the DB2
Message.
- Click the Identification tab.
- Select the Define Subscription push button. The Define
Replication Subscription window opens.
- In the Define Replication Subscription window, click
Add. The Add Table window opens.
- 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.
- Type the % symbol in the Source schema and Source table fields. The
% symbol is a wildcard symbol that displays all available tables in the table
list. Click OK.
- Select DSYSAMPLE.VNSCHEDULE from the Table list.
The Target schema and Target table fields are
automatically completed.
- 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.
- Click Add. Click Close.
- Click the Timing push button in the Define replication
subscription window.
- 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 60
seconds. Click OK.
- Click OK to close the Define Replication Subscription
window.
- 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.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]