IBM DB2 Everyplace Sync Server Administration Guide Version 7 Release 2 Modification 1
When using DataPropagator subscriptions, DB2 Everyplace Sync Server
uses DB2 DataPropagator to replicate data between Sync Server and DB2
Universal Database. The sample that you installed includes a complete
DataPropagator sample database and Sync Server configuration. This
tutorial walks you through the steps to manually create a DataPropagator
subscription.
Before creating DataPropagator subscriptions, the database table
must be defined as a replication source in DB2. In this example, we
will define the VNURSE sample table as a replication source:
- Open the DB2 Control Center and Mobile Devices Administration
Center.
- For Windows, select Start --> Programs --> IBM DB2
Everyplace--> Start Mobile Devices Administration Center.
- For UNIX, change to $DSYINSTDIR/Server, then run
dsyadmin.sh.
- From the DB2 Control Center, expand the object tree until you see the
VNURSE database. Select the VNURSE database Tables folder to
show the VNURSE tables.
- Locate the VNCONTACT table and right-click
it.
- Select Define as replication source --> DB2 Everyplace Sync
Server.
- Select Run now.
- Click OK.
The VNCONTACT table of the VNURSE database is now a replication
source. You can verify this by looking in the replication sources
folder of the VNURSE database.
The Mobile Devices Administration Center is used to manage the Sync Server
subscriptions and mobile users. To create a DataPropagator
subscription:
- Select DB2 Everyplace Mobile Devices Administration Center from
the Tools menu at the top of the Control Center window. The DB2
Everyplace Mobile Devices Administration Center opens.
- Right-click on the Subscriptions folder. Select Create
--> Table subscription --> DataPropagator Subscription.
- Type a name for the DataPropagator subscription in the Name
field. This example uses CONTACT.
- Type a description for the DataPropagator subscription in the
Description field. This example uses VNCONTACT test
subscription.
- Select the encryption level for the DataPropagator subscription in the
Encryption level field. This example uses
None.
- Click the
push button next to the Source Database field and select
VNURSE in the Database list of the Database
Selection window. Click OK.
- Click the
push button next to the Mirror database field. Select
M_VNURSE from the list in the Select Mirror database
window. If a mirror database does not exist for your database, click
the Create push button to launch the Create Database Wizard.
- Click the Define Subscription push button to open the Define
replication subscription window.
- Click the Add push button to open the Add window.
- Select DSYSAMPLE.VNCONTACT from the Replication
Source list and click Add. Then 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 to close the Define replication subscription
window.
- Click the Authentication tab.
- Enter a username and password in the User ID,
Password, and Verify password fields. This must
be a valid DB2 UDB user ID with DBADM authority.
- Click OK to close the Create Table Subscription
notebook. If all of the fields are filled in correctly, OK
should not be grayed out.
DB2 Everyplace Sync Server is now configured to synchronize the data in
this table. Next you will bind the tables and start capture for the
DataPropagator subscriptions.
DB2 Everyplace Sync Server uses DB2 DataPropagator to replicate data
between Sync Server and DB2 Universal Database. Before you can
synchronize data using DataPropagator subscriptions, you must configure the
databases you are synchronizing. To configure the databases:
- Exit the DB2 Control Center and the Mobile Devices Administration
Center.
- For Windows, open a DB2 Command window by selecting Start -->
Programs --> IBM DB2--> Command Window. For UNIX, open
a window and ensure that you have started the DB2 database manager. If
not, issue a db2start command.
- Change directories to \SQLLIBDIR\bnd, where
SQLLIBDIR is the directory in which DB2 Universal Database
is installed.
- Type bindcap vnurse to configure the source database.
vnurse is the name of the database used in this example.
- Type bindcap m_vnurse to configure the mirror database.
m_vnurse is the name of the mirror database used in this
example.
- Close the DB2 Command Window.
After configuring the DataPropagator subscription databases, you must start
the DataPropagator capture program for the source database. To start
the DataPropagator capture program:
- On the source database server, open a DB2 command
window.
- Start the Capture process by typing the following command:
ASNCCP vnurse
Leave this command window open. The capture process will run
continuously in the background. If the capture process stops, repeat
these steps.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]