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:
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:
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/).