Checking if a database is installed

IBM WebSphere Business Integration Server Express and Express Plus support IBM DB2 Universal Database v8.1 Express, IBM DB2 Universal Database v8.1 Enterprise, and Microsoft SQL Server 2000 databases. Before checking for installation of or actually installing a database, do the following:

Note:
If you intend to use only the Toolset Express component, a database server is not required.

To invoke the Launchpad to check for an installed database, do the following:

  1. Select the button labeled Database Setup. The Database Setup screen appears and the Launchpad checks your machine for an existing installation of a supported database.
  2. Do one of the following, depending on which software the Launchpad finds on the machine:

Installing and configuring a new installation of IBM DB2 Universal Database v8.1 Express

If no supported database is installed on your machine or if you want to install and configure IBM DB2 Universal Database v8.1 Express regardless of having any other supported databases already installed, follow the instructions in this section.

Before installing DB2 UDB Express, review the following:

To install DB2 UDB Express, from the Launchpad Database Setup screen, select the entry Install IBM DB2 Universal Database v8.1 Express. Selecting this entry installs DB2 UDB Express silently. A dialog will notify you when installation and configuration are complete. The installation and configuration processes do the following:

Configuring an existing installation of IBM DB2 Universal Database v8.1 Express or Enterprise

If IBM DB2 Universal Database v8.1 Express or Enterprise is installed and you want to configure it for use with WebSphere Business Integration Server Express or Express Plus, do the following:

  1. On the Launchpad Database Setup screen, select Continue.
  2. 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.
  3. Select Continue.

After IBM DB2 Universal Database v8.1 is successfully configured, you will see a message that the database configuration is complete. The configuration process does the following:

Configuring an existing installation of Microsoft SQL Server 2000

If Microsoft SQL Server 2000 is installed and you want to configure it for use with WebSphere Business Integration Server Express or Express Plus, do the following:

  1. On the Launchpad Database Setup screen, select Use Microsoft SQL Server 2000, then select Continue.

    The Microsoft SQL Server 2000 Configuration screen appears.

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

After Microsoft SQL Server 2000 is successfully configured, you will see a message that the database configuration is complete. The configuration process does the following:

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

Copyright IBM Corp. 2004