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


Chapter 4. Synchronization Tutorial

After installing the DB2 Everyplace database and the DB2 Everyplace Sync Server and setting up your device, you are ready to synchronize. For more information on installing DB2 Everyplace, see the DB2 Everyplace Installation and User's Guide. This chapter tests synchronization using sample data and sample DataPropagator and JDBC subscriptions, but does not use sample upload subscription types. The source tables specified in a DataPropagator subscription must be on a DB2 UDB database. For a JDBC subscription, the source tables can be on any JDBC-compliant database, including DB2 UDB. For more information on working with different data sources, see Working with data sources.

This tutorial assumes understanding of database administration for DB2 UDB and JDBC-compliant databases. The following steps are covered:

  1. Creating a JDBC subscription to data.
  2. Creating a DataPropagator subscription to data.
    1. Setting up sources for DataPropagator subscriptions.
    2. Creating the DataPropagator subscription.
    3. Binding the tables and starting capture for DataPropagator subscriptions.
  3. Grouping subscriptions into a subscription set.
  4. Creating mobile users.
  5. Creating a data synchronization group and assigning users and a subscription set to the group.
  6. Starting the application server.
  7. Configuring the mobile device.
  8. Synchronizing for the first time.

The DB2 Everyplace Sync Server includes sample databases and configuration for testing JDBC subscriptions and DataPropagator subscriptions. The JDBC sample data can be installed at the end of the installation process. If you installed the JDBC sample data during installation, you only must follow steps 1, 2 and 4. If you did not install sample data during installation, you must install the sample database by following steps 1 to 4.

To install the sample database:

  1. Open a DB2 Command Window
  2. For Windows, change to the \SyncServer\Sample\ directory. For a UNIX operating system, change the directory to $DSYINSTDIR/Sample.
  3. Install the JDBC sample data.
  4. Install the DataPropagator sample data:

    The DB2 user ID and password will be used to create the DataPropagator sample databases.

DB2 Everyplace Sync Server includes a servlet that requires an application server to run. A simple application server is installed by default. DB2 Everyplace Sync Server can be used with many different application servers. For information on how to use the DB2 Everyplace Sync Server with a different application server such as the IBM WebSphere Application Server, see the DB2 Everyplace Web site (http://www.ibm.com/software/data/db2/everyplace/).


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]