Configuring Sync Server to use with IBM WebSphere Application Server

This section describes how to configure the DB2 Everyplace Sync Server so you can use it with the IBM WebSphere Application Server 4.0 Advanced Edition and Advanced Single Server edition. The following topics are covered in this section:

Configuring Sync Server to use with WebSphere Application Server 4.0 Advanced Edition
Configuring Sync Server to use with WebSphere Application Server 4.0 Advanced Single Server Edition

Prerequisites

Before you start, make sure that you have WebSphere Application Server 4.0, FixPak 2 or higher installed on your workstation. You can download the FixPak from the IBM Web site. You will also need the following information:

The directory in which WebSphere Application Server is installed
The WebSphere Application Server node name under which you plan to install DB2 Everyplace (Sync Server)
The Sync Server instance name (UNIX only)

The WebSphere Application Server Administration Server must use the default port number 900. If not, configure the WebSphere Application Server Administration Server to use 900 now. After you finish configuring the Sync Server, you can change it back.

For Windows 2000, Windows NT, and Windows XP, if you are using DB2 UDB Version 7, you must first configure WebSphere Application Server to use JDBC 2.0. To configure WebSphere Application Server to use JDBC 2.0:

Stop the DB2 Universal Database JDBC Applet Server service.
Stop WebSphere Application Server if it is running.
Open a Command Prompt window.
Change the directory to %DSYSQLLIBINSTDIR%\java12.
Type usejdbc2.bat. If errors messages appear, you need to verify that the DB2 Universal Database JDBC Applet Server service has stopped.
Start the DB2 Universal Database JDBC Applet Server service.
Start the WebSphere Application Server.

You must also have the DB2 Universal Database administrator's authority for Windows NT, Windows 2000, or Windows XP operating systems; or the root user authority for the UNIX operating system.

Procedure

To configure Sync Server to use with WAS 4.0 Advanced Edition

Start the IBM HTTP Server.
Start the Administration Server for WAS 4.0.
When you start the Administration Server, you must log in as a DB2 Universal Database administrator on a Windows NT, Windows 2000, or Windows XP operating system, or as root user on the UNIX operating system. The administration server must use the default port number 900 now, but you can change the server to use another port at a later time.
Run the dsy_was40_install script. This script will create an application server under your WebSphere node, install the IBM DB2 Everyplace Enterprise Application, and regenerate the Web server plug-in. To start the script:
- For Windows 2000, Windows NT, and Windows XP:
  1. Open a Command Prompt window.
  2. Change the directory to %DSYINSTDIR%\installableApps\NT.
  3. Enter the following command:
```
dsy_was40_install.bat "WAS_installation_directory" "WAS_node_name"
"%DSYINSTDIR%" "%DSYSQLLIBINSTDIR%" "UDB Version number" dsyusername
 
```
    where:
    - WAS_installation_directory is the directory in which the WebSphere Application Server is installed
    - WAS_node_name is the node name of the WebSphere Application Server
    - UDB Version Number is "7" or "8"
- For UNIX operating systems:
  1. Open a terminal window.
  2. Enter the following command:
```
dsy_was40_install.sh "WAS_installation_directory" "WAS_node_name"
"$DSYINSTDIR" "$DSYSQLLIBINSTDIR" "UDB Version number" dsyusername
```
    where
    - WAS_installation_directory is the directory in which the WebSphere Application Server is installed
    - WAS_node_name is the node name of the WebSphere Application Server
    - UDB Version Number is "7" or "8"
  3. You will be prompted to provide a node under which to install the Sync Server application, and the name of the DB2 Everyplace instance that you created.

To configure Sync Server to use with WAS 4.0 Advanced Single Server Edition

This section describes how to configure Sync so you can use it with WAS 4.0 Advanced Single Server Edition. There are two parts to configuring the Sync Server so you can use it with WAS 4.0 Advanced Single Server Edition. You need to update the classpath for the default application server and install the IBM_DB2_Everyplace.ear file on the WebSphere Application Server.

To update the classpath for the IBM DB2 Everyplace Server

In the WebSphere Administration Domain tree, expand the components Nodes -> Node name -> Application Server -> IBM DB2 Everyplace Server -> Process Definition -> JVM Settings. The JVM Settings page opens.
In the Properties panel, type a classpath for the default application server and click OK.
In the JVM Settings page, click the Configuration needs to be saved link.
Click OK to save the configuration.
Stop the WebSphere Application Server.
Restart the WebSphere Application Server. When the WebSphere Application Server is restarted, the new JVM classpath is effective.
Restart the WebSphere Application Server Administrative Console.

Related tasks