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:
- Ensure that you have administrator privileges to create a new database and
add new users.
- Review the minimum requirements for particular databases in the section Checking minimum database requirements.
- 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:
- 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.
- Do one of the following, depending on which software the Launchpad finds
on the machine:
- If no supported database is installed, the Database Setup screen states so
and offers a button to launch installation of IBM DB2 Universal Database
v8.1 Express. In this case, follow the instructions in the
section Installing and configuring a new installation of IBM DB2 Universal Database v8.1 Express.
- If IBM DB2 Universal Database v8.1 Express or Enterprise is
installed, the Database Setup screen states so and offers a button to launch
configuration of the existing installation. In this case, follow the
instructions in the section Configuring an existing installation of IBM DB2 Universal Database v8.1 Express or Enterprise.
- If Microsoft SQL Server 2000 is installed, the Database Setup screen
states so and offers a choice of having the Launchpad configure the existing
Microsoft SQL Server 2000 installation, or to instead install and configure
IBM DB2 Universal Database v8.1 Express. Do one of the
following:
- If IBM DB2 Universal Database v8.1 Express or Enterprise
and Microsoft SQL Server 2000 are installed, the Database Setup
screen states so and offers a choice of having the Launchpad configure either
database. Do one of the following:
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:
- Ensure that your Windows machine user ID and your Windows domain ID (if
you are using one) are identical. If your Windows machine user ID and
your Windows domain ID are not identical, the DB2 installation process will
fail.
- The installation instructions in this section assume that this is the
first time you are installing DB2 UDB Express on your machine. If you
have previously installed DB2 UDB Express through the Launchpad, uninstalled
it following standard DB2 uninstallation procedures, and are now reinstalling
it through the Launchpad, you must first do the following before you use the
Launchpad to reinstall DB2 UDB Express:
- Manually delete two residual user IDs that the Launchpad automatically
created when it performed the first DB2 UDB Express installation. To
remove these IDs, do the following:
- Select Start > Settings > Control Panel > Users and
Passwords.
- On the User and Passwords screen, under the User Name column, select the
db2admin user ID and the smbadmin user ID.
- Click Remove.
- Click Apply and OK to exit the User and Passwords
screen.
- Manually delete copies of the files serverexp,
OptionFile_DB2.txt, or
OptionFile_MSSQL2000.txt that might exist in the directory
specified by %TEMP%.
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:
- Create a DB2 Administration Server user db2admin with a
password of smbP4$$word.
- Configure a C compiler for DB2 Express.
- Create a database named SMB_DB.
- Create a user named smbadmin with a password of
smbP4$$word.
- Grant the appropriate authorities to the smbadmin user in the
SMB_DB table.
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:
- On the Launchpad Database Setup screen, select Continue.
- Do the following at the Setup DB2 SQL Procedures Environment screen:
- 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.
- 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.
- 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:
- Configures a C compiler for DB2.
- Creates a database named SMB_DB.
- Creates a user named smbadmin, with a password of
smbP4$$word.
- Grants the appropriate authorities to the smbadmin user in the
SMB_DB table.
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:
- On the Launchpad Database Setup screen, select Use Microsoft SQL
Server 2000, then select Continue.
The Microsoft SQL Server 2000 Configuration screen appears.
- Type the name of a login that belongs to the "System
Administrators" server role in the User name field.
- Type the password for the user name specified in step 2 in the
Password field.
- Type the password for the user name specified in step 2 in the
Confirm password field.
- 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:
- Creates a database named SMB_DB.
- Creates a user named smbadmin, with a password of
smbP4$$word.
- Grants the appropriate authorities to the smbadmin user in the
SMB_DB table.
- 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.
