Installing DB2 Universal Database (UDB) 7.2 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:

  • Is defined locally
  • Belongs to the local Administrator's group
  • Act as part of the operating system
  • Create a token object
  • Increase quotas
  • Replace a process level token

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.2

To install DB2 UDB 7.2, follow these steps:

  1. Log in using a user ID that has the appropriate user rights as shown in the preceding section.
  2. On the product CD for DB2 UDB, 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. These instructions assume that you choose the Enterprise Edition.
  5. The Select Installation Type window is displayed. Select Typical, and click Next.
  6. If a window pertaining to the DB2 OLAP Starter Kit is displayed, click OK and continue with the installation.
  7. If a window pertaining to the OLE DB Support component is displayed, click OK and continue with the installation.
  8. The Choose Destination Location window is displayed. Specify an installation directory for DB2, and click Next.
  9. The Enter Username and Password for Control Center Source 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.

  10. On the Start Copying Files window, click Next.
  11. The setup.exe program performs the default configuration for users, groups, and an instance to be used by DB2. The installation program reboots your system and starts the DB2 services.

    Stop the DB2 services and run the usejdbc2.bat file in the \SQLLIB\java12 directory to upgrade the JDBC providers.

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 (go to ftp://ftp.software.ibm.com/ps/products/db2/fixes/, select a language, select the WAS4 fixpack such as WAS4 FP3/, select windows, and download the fixpack file) 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:

    • The DB2-DB2 service is Started.
    • The startup type for the DB2-DB2 service is Automatic.
    • The hardware profile is Enabled.

    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.