Installing DB2 Universal Database (UDB) 7.1 on a Windows system

The instructions in this section cover the following tasks:

For the most recent information on installing DB2 UDB or a fixpack, consult DB2 documentation.

Checking the user rights for your ID

To install DB2, you must be logged in using a user ID that has the following set of basic and advanced user rights:

To later install WebSphere Application Server, the user ID must also have the advanced user right "Log on as a service."

Use the Windows User Manager utility to ensure that the user ID has the appropriate rights. To activate this utility on Windows NT, click Start -> Programs -> Admininstrative Tools (Common) -> User Manager. On Windows 2000, click Control Panel -> Users and Password. See Windows documentation for information on how to use this tool. Note that you might need to restart your system in order for any changes made to the user account to take effect.

Installing DB2 UDB 7.1

To install DB2 UDB 7.1, follow these steps:

  1. Log in using a user ID that has the appropriate user rights as shown in the preceding section.
  2. If you have the product CD for DB2 UDB, run setup.exe. If you downloaded DB2 UDB, unzip the DB2 zip file to a temporary directory, using an option that re-creates the directory structure. Then, run setup.exe. The Welcome to DB2 window is displayed.
  3. On the Welcome to DB2 window, read the information as needed under the Installation Prerequisites, Release Notes, and Quick Tour options. Click Install to begin the installation process.
  4. The Select Products window is displayed. Choose the Enterprise Edition or the Workgroup Edition, and click Next.
  5. The Setup Type window is displayed. Select Typical, and click Next.
  6. The Choose Destination Location window is displayed. Specify an installation directory for DB2, and click Next.
  7. The Choose Destination Location window is displayed. Specify an installation directory for DB2, and click Next.
  8. The Select Username and Password window is displayed, and default values show in the Username and Password fields.

    To simplify administration, consider configuring DB2 administration to use the same user ID and password as those that are used by the Web server installation. In the Username and Password fields, overwrite the default values in the Username and Password fields with your own choices for user ID and password. Note that DB2 requires a password of eight or fewer characters. Click Next, and continue with the installation.

  9. The setup.exe program performs the default configuration for users, groups, and an instance to be used by DB2. On Windows NT, you are prompted to restart your system after the installation is complete.

Installing any needed DB2 UDB fixpack

See "Software Prerequisites" to learn whether you need to install a DB2 UDB fixpack for your level of WebSphere Application Server. If you need a DB2 UDB fixpack, download the fixpack or obtain a CD that holds the fixpack. Follow the instructions in the README file that accompanies the fixpack.

Verifying the installation

To verify that your installation has completed successfully, create the database SAMPLE used by the WebSphere Application Server samples. To create the database SAMPLE, follow these steps:

  1. Click Start -> Programs -> IBM DB2 -> First Steps. The First Steps window is displayed.
  2. Click Create Sample Databases. The First Steps - Create Sample Databases window is displayed.
  3. Click DB2 UDB Sample and click OK. The SAMPLE database is added to the default instance that was created by the setup.exe program.

    If you receive an error message stating that the database was not created, go to the Services dialog box accessible from the Control Panel and ensure that the DB2 parameters are set as follows:

    After you set the parameters, try creating the database SAMPLE again.

  4. To ensure that the database SAMPLE was created, go to the DB2 Control Center (Start > Programs > IBM DB2 > Control Center) and ensure that the name of the DB2 database SAMPLE is shown in the tree.
  5. After you finish, close the DB2 dialog box.