Installing DB2 Universal Database (UDB) 7.2

This article describes how to do the following:

  • Install DB2 on a local AIX machine.
  • Apply a FixPak to the installation.

These instructions assume the following:

  • Your machine has enough memory and disk space for your installation. See the DB2 product documentation on the DB2 Online Support Web site at www.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v7pubs.d2w/en_main for the requirements.
  • You do not have a previous version of DB2 already installed on the machine. If a previous version of DB2 is installed, you can need to migrate servers and instances, depending on the version installed. In this case, do not follow these instructions. Instead, refer to the DB2 product documentation on the DB2 Online Support Web site at www.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v7pubs.d2w/en_main.
  • Your DB2 database server will reside on the same machine as WebSphere Application Server. This configuration and the use of the default settings documented in these instructions are appropriate only for development and small production environments. For larger environments where it is preferable to configure the DB2 server on a remote machine, you must install and configure a DB2 client on the same machine on which you install WebSphere Application Server and verify the remote database connectivity. See the IBM Redbook, WebSphere V3.5 Handbook, on the IBM Redbooks Web site at www.redbooks.ibm.com/redbooks/SG246161.html for more information about implementing this configuration.

Note: Install DB2 before installing WebSphere Application Server.

Installing DB2 UDB

The DB2 software CD-ROM contains the packages necessary to install and configure DB2 on a local AIX machine.

Perform the following steps to install DB2:

  1. Ensure that you are logged into the machine with superuser (root) privileges.
  2. Ensure that a CD-ROM drive is installed and configured on the machine. If a CD-ROM drive is not installed or configured on the machine, install and configure one according to the instructions provided with the drive.
  3. Insert the DB2 UDB V7.2 CD-ROM into the CD-ROM drive.
  4. If necessary, use the mkdir command to create a mount point for the CD-ROM. The following command creates a mount point at the directory /cdrom; you can mount the CD-ROM at any location on the machine's local file system.
    # mkdir /cdrom

    The commands in these steps assume the CD-ROM is mounted at /cdrom. If you mount the CD-ROM at a different location, use that location when issuing commands.

  5. Mount the CD-ROM drive by entering the following command:
    # mount -o ro -v cdrfs /dev/cdnumber /cdrom

    In this command, number is the CD-ROM number for your system, usually 0 (zero). Note that this command assumes that the CD-ROM is mounted at /cdrom.

  6. Navigate to the /cdrom directory.
  7. Start the DB2 Setup Utility by using the db2setup command, as follows:
    # ./db2setup
  8. The Install DB2 V7 window opens. Press Tab to move between available options and fields. Press Return to select or deselect an option. Perform the following steps to select the appropriate products and components for installation:
    1. Highlight and press Return for the following products:
      • DB2 Administration Client
      • DB2 UDB Enterprise Edition
      • DB2 Connect Enterprise Edition
      • DB2 Application Development Client
    2. Highlight the Customize option for the DB2 Product Library option and press Return.
    3. The DB2 Product Library dialog box opens. In the DB2 Product Library (HTML) section, highlight the appropriate option for your locale (en_US for U.S. English) and press Return.
    4. On the DB2 Product Library dialog, highlight OK and press Return.
    5. On the Install DB2 V7 dialog, highlight OK and press Return.
  9. On the Create DB2 Services dialog, accept the default values Do not create DB2 Instance and Do not create the Administration Server, ensure that OK is highlighted, and press Return. You will create a DB2 instance and Administration Server after installing the required FixPak. Installing a FixPak is discussed in the section Upgrading DB2 UDB with a FixPak.
  10. A Warning dialog informs you that you are not creating a DB2 instance. Ensure that OK is highlighted, and press Return to exit from the Warning dialog.
  11. A Warning dialog informs you that you are not creating an Administration Server. Ensure that OK is highlighted, and press Return to exit from the Warning dialog.
  12. The Summary Report dialog box opens. Ensure that Continue is highlighted, and press Return to continue with the installation.
  13. A Warning dialog informs you that it is your last chance to stop the installation. Ensure that OK is highlighted, and press Return to continue with the installation. When installation is complete, DB2 software is installed in the /usr/lpp/db2_07_02 directory.
  14. A Notice dialog informs you when the installation process has completed successfully. Ensure that OK is highlighted, and press Return.
  15. You can be prompted to register the DB2 software. Enter the information required to register DB2, or exit from the registration window by clicking Exit.
  16. The Status Report dialog displays the status of each component you selected for installation. You can choose to view the contents of the installation log file by highlighting View Log and pressing Return, or highlight OK and press Return to continue.
  17. The DB2 Setup Utility dialog box opens. Highlight Close and press Return to exit from the DB2 Setup Utility.
  18. A Warning dialog informs you that a DB2 instance has not been created. Ensure that OK is highlighted, and press Return.
  19. A Warning dialog informs you that the Administration Server has not been created. Ensure that OK is highlighted, and press Return.
  20. A Notice dialog prompts you to exit from the DB2 Installer. Ensure that OK is highlighted and press Return.
  21. Unmount the CD-ROM before removing it from the CD-ROM drive by using the umount command, as follows:
    # umount /cdrom
  22. See the WebSphere Application Server Supported Software and APIs Web site at www.ibm.com/software/webservers/appserv/doc/latest/prereq.html to determine if it is necessary to install a DB2 FixPak for your version of WebSphere Application Server. If you need to update your DB2 UDB installation with a FixPak, note the FixPak level and proceed to the section Upgrading DB2 UDB with a FixPak.

Upgrading DB2 UDB with a FixPak

Perform the following steps to install a FixPak for DB2:

  1. See the WebSphere Application Server Supported Software and APIs Web site at www.ibm.com/software/webservers/appserv/doc/latest/prereq.html to determine the required FixPak level for your version of WebSphere Application Server.
  2. Go to the DB2 Universal Database and DB2 Connect Online Support Web site at www.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/download.d2w/report, navigate to the download page for the required FixPak, and download the appropriate file. Read the accompanying README file for installation suggestions.
  3. Ensure that you are logged into the machine with superuser (root) privileges.
  4. Navigate to the directory containing the downloaded tar file.
  5. Untar the file you downloaded to extract the DB2 packages by using the tar command, as follows:
    # tar -xvf file_name.tar

    In this command, file_name is the name of the tar file you downloaded.

  6. Remove the .toc file from the download directory. The AIX Software Management Interface Tool (SMIT) creates a new table of contents file that matches the contents of the download directory.
  7. Ensure that all DB2 processes are stopped.
  8. Invoke SMIT to update all files by entering the following command:
    # smit update_all
  9. In the INPUT device / directory for software field, specify the full pathname of the directory containing the uncompressed and untarred FixPak files, and click OK.
  10. Accept the SMIT default choices for updating DB2, and click OK.
  11. Click OK to install the FixPak.
  12. When this process is complete, exit from SMIT.
  13. Proceed to the article Configuring and testing DB2 UDB 7.2 to verify your DB2 installation.