IBM DB2 Everyplace Sync Server Administration Guide Version 7 Release 2 Modification 1


Creating a DataPropagator subscription to data

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.

Setting up sources for DataPropagator subscriptions

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:

  1. Open the DB2 Control Center and Mobile Devices Administration Center.
  2. 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.
  3. Locate the VNCONTACT table and right-click it.
  4. Select Define as replication source --> DB2 Everyplace Sync Server.
  5. Select Run now.
  6. 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.

Creating the DataPropagator subscription

The Mobile Devices Administration Center is used to manage the Sync Server subscriptions and mobile users. To create a DataPropagator subscription:

  1. 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.
  2. Right-click on the Subscriptions folder. Select Create --> Table subscription --> DataPropagator Subscription.
  3. Type a name for the DataPropagator subscription in the Name field. This example uses CONTACT.
  4. Type a description for the DataPropagator subscription in the Description field. This example uses VNCONTACT test subscription.
  5. Select the encryption level for the DataPropagator subscription in the Encryption level field. This example uses None.
  6. Click the dots push button next to the Source Database field and select VNURSE in the Database list of the Database Selection window. Click OK.
  7. Click the dots 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.
  8. Click the Define Subscription push button to open the Define replication subscription window.
  9. Click the Add push button to open the Add window.
  10. Select DSYSAMPLE.VNCONTACT from the Replication Source list and click Add. Then click Close.
  11. Click the Timing push button in the Define replication subscription window.
  12. 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.
  13. Click OK to close the Define replication subscription window.
  14. Click the Authentication tab.
  15. 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.
  16. 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.

Configuring the databases and starting capture for 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:

  1. Exit the DB2 Control Center and the Mobile Devices Administration Center.
  2. 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.
  3. Change directories to \SQLLIBDIR\bnd, where SQLLIBDIR is the directory in which DB2 Universal Database is installed.
  4. Type bindcap vnurse to configure the source database. vnurse is the name of the database used in this example.
  5. Type bindcap m_vnurse to configure the mirror database. m_vnurse is the name of the mirror database used in this example.
  6. 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:

  1. On the source database server, open a DB2 command window.
  2. 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 ]