Database setup

IBM WebSphere Business Integration Express for Item Synchronization supports both IBM DB2 Universal Database v8.1 Express and Microsoft SQL Server 2000. In order to use IBM WebSphere Business Integration Express for Item Synchronization, you must have one of the supported databases installed on your machine. You must also have administrator privileges to create a new database and add new users. If you do not have one of the supported databases on your machine, you can use Launchpad to install IBM DB2 Universal Database v8.1 Express.

DB2 Express

Installing IBM DB2 Universal Database v8.1 Express

To install IBM DB2 Universal Database v8.1 Express, do the following:

  1. From Launchpad, click Database Setup.

    The Database Setup screen appears.

  2. Click Install IBM DB2 Universal Database v8.1 Express to start the silent installation.
  3. After IBM DB2 Universal Database v8.1 Express is successfully installed, you should see a message that the database setup is complete. See Installing WebSphere Business Integration Express for Item Synchronization for instructions on how to install WebSphere Business Integration Express for Item Synchronization.

Existing IBM DB2 Universal Database v8.1

To configure an already existing IBM DB2 Universal Database v8.1 database:

  1. From Launchpad, click Database Setup.

    A screen appears indicating that IBM DB2 Universal Database v8.1 was found on the computer.

  2. Click Continue.
  3. Do the following at the "Setup DB2 SQL Procedures Environment" screen:
    1. Type the name and path of the batch file that sets the environment variables for the compiler that DB2 uses to compile stored procedures in the Compiler Path field.
    2. Either leave the Use the default value for DB2_SQLROUTINE_COMPILE_COMMAND box selected to use the default compiler command or clear the box and type the desired compiler command in the Compile Command field.
  4. Click Continue.

    After IBM Install IBM DB2 Universal Database v8.1 is successfully configured, you should see a message that the database configuration is complete. See Installing WebSphere Business Integration Express for Item Synchronization for instructions on how to install WebSphere Business Integration Express for Item Synchronization.

Microsoft SQL Server 2000

This guide does not provide installation instructions for Microsoft SQL Server 2000. For a description of the installation process, see Microsoft's Web site.

If Microsoft SQL Server 2000 is currently installed on your machine, follow the instructions in this section to configure your database.

To configure an already existing Microsoft SQL Server 2000 database:

  1. From Launchpad, click Database Setup.

    The Currently Installed Databases screen appears.

  2. Select Use Microsoft SQL Server 2000, then click Continue.

    The Microsoft SQL Server 2000 Configuration screen appears.

  3. Type the name of a login that belongs to the "System Administrators" server role in the User name field.
  4. Type the password for the user name specified in step 3 in the Password field.
  5. Type the password for the user name specified in step 3 in the Confirm password field.
  6. Click Create repository database.

    After Microsoft SQL Server 2000 is successfully configured, you should see a message that the database configuration is complete. See Installing WebSphere Business Integration Express for Item Synchronization for instructions on how to install WebSphere Business Integration Express for Item Synchronization.

Copyright IBM Corp. 1997, 2003