Installing the sample database

Prerequisites

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, 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.

Procedure

To install the sample database:

1. Open a DB2 Command Window
2. For Windows, change to the Server\Sample directory. For a UNIX operating system, change the directory to $DSYINSTDIR/Sample.
3. Install the JDBC sample data.
   • For Windows, run dsysample.exe. You will be prompted to provide your DB2 user ID and password, which will be used to create the JDBC sample databases and configuration.
   • For UNIX, run dsysample.sh db2userid db2password.
4. Install the DataPropagator sample data:
   • For Windows, run dsysampleDPropr.bat db2userid db2password. Click Install.
   • For UNIX, run dsysampleDPropr.sh db2userid db2password.

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

Conceptos relacionados

• Configuring synchronization

Tareas relacionadas

• Installing the sample database
• Creating a JDBC subscription to access source data
• Grouping subscriptions into mobile subscription sets
• Creating mobile users
• Creating a data synchronization group
• Starting the application server
• Configuring the Windows Remote Access Service on the Windows workstation