This article describes the following:
- How to install and configure DB2 on a local Solaris SPARC machine
- How to apply a FixPak to the installation
These instructions assume the following:
- You do not have a previous version of DB2 already installed on your machine.
If a previous version of DB2 is installed, you might need to migrate servers and instances, depending on
the version installed. In this case, do not follow these instructions. Instead, refer to 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 default settings documented in these instructions
are appropriate only for development and very small production environments. For larger environments where
it is preferable to configure the DB2 server on a remote server, 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.
For information on this more complicated scenario, refer to the IBM Redbook WebSphere V3.5 Handbook at
www.redbooks.ibm.com/redbooks/SG246161.html.
- 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-4.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v7pubs.d2w/en_main for the necessary requirements.
Note: Install DB2 before installing WebSphere Application Server.
Installing DB2 UDB
The DB2 software CD-ROM contains the files necessary to install and configure
DB2 on a local Solaris SPARC machine.
Perform the following steps to install DB2:
- Ensure that you are logged into the machine with superuser (root) privileges.
- Ensure that you have set the following UNIX kernel, shared memory, and
semaphore parameters properly:
- MSGMAX
- MSGMNB
- MSGMAP
- MSGMNI
- MSGSSZ
- MSGTQL
- MSGSEG
- SHMMAX
- SHMSEG
- SHMMNI
- SEMMNI
- SEMMAP
- SEMMNS
- SEMMNU
- SEMUME
Refer to the DB2 Quick Beginnings for UNIX and related DB2 UDB documentation on the
DB2 Online Support Web site at
www.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v7pubs.d2w/en_main
to obtain information on the proper values for these parameters. It is recommended that you review these settings with your system
administrator to ensure that they do not conflict with settings necessary for other
software programs on your system.
You can use the following sample files to update the settings for these parameters. The files are located in the
/db2/install/samples directory on the DB2 software CD-ROM or in the /opt/IBMdb2/V7.1/cfg
directory in the installed DB2 product:
- kernel.param.64MB for systems with 64 - 128 MB physical memory
- kernel.param.128MB for systems with 128 - 256 MB physical memory
- kernel.param.256MB for systems with 256 - 512 MB physical memory
- kernel.param.512MB for systems with 512 MB to 1 GB physical memory
Choose the file appropriate for your system, append it to the /etc/system file, make any changes
to the SHMMAX parameter if needed as outlined in the DB2 product documentation,
enter the command # touch /reconfigure
, and restart your machine.
- Insert the DB2 UDB V7.1 CD-ROM and, if necessary, mount the
CD-ROM drive. (On most Solaris systems, the Volume Management daemon
(vold) mounts the CD-ROM automatically and immediately, as well
as each time the machine is restarted. If the vold process is
not running on the local machine, see your Solaris system
documentation for instructions on how to mount the CD-ROM drive.) The
following steps assume that the CD-ROM drive is mounted at /cdrom.
- Navigate to the correct directory on the DB2 UDB V7.1 CD-ROM
by entering the following command:
# cd /cdrom/cdrom0
- Enter the following command to start the DB2 Setup Utility:
# ./db2setup
Note: The DB2 Setup Utility works with only the bash, Bourne, and Korn shells.
- In the Install DB2 V7 window, select the products that you want to install
by performing the following steps. (Press the Tab key to move among and highlight
options and press Return to select or deselect options.)
- Select DB2 Administration Client, DB2 UDB Enterprise Edition,
and DB2 Application Development Client
by highlighting each option and pressing Return.
- Highlight the Customize option beside the DB2 Product Library
option and press Return.
- In the DB2 Product Library section, highlight the option
appropriate for your locale (en_US for U.S. English) and press Return.
- In the DB2 Product Library window, highlight OK and press Return.
- In the Install DB2 V7 window, highlight OK and press Return.
- In the Create DB2 Services window, accept the default values Do not create
a DB2 Instance and Do not create the Administration Server by ensuring
that OK is highlighted and pressing Return. (You will create a DB2 Instance
and the Administration Server after the installation of any needed FixPak.
Installation of FixPaks is discussed in the section
"Upgrading DB2 UDB with a FixPak.")
- A warning window informs you that you are not creating a DB2 Instance. Ensure that
OK is highlighted and press Return to exit from the warning window.
- A warning window informs you that you are not creating an Administration Server.
Ensure that OK is highlighted and press Return to exit from the warning window.
- The Summary Report window lists the products that you have elected to install. DB2
software is installed into the directory /opt/IBMdb2/V7.1. Ensure that Continue
is highlighted and press Return.
- A warning window gives you a final chance to cancel the installation. Ensure
that OK is highlighted and press Return to continue with the installation.
- A notice window informs you whether the installation has been successful. Ensure
that OK is highlighted and press Return to exit from this window.
- The Status Report window verifies which software packages are installed.
Ensure that OK is highlighted and press Return.
- Ensure that Close is highlighted and press Return.
- A warning window informs you that you are not creating a DB2 Instance. Ensure
that OK is highlighted and press Return to exit from the warning window.
- A warning window informs you that you are not creating an Administration Server.
Ensure that OK is highlighted and press Return to exit from the warning window.
- A notice window asks whether you want to exit from the DB2 Setup Utility. Ensure that
OK is highlighted and press Return.
- Unmount the CD-ROM before removing it from the CD-ROM drive by entering the following command:
# umount cdrom/cdrom0
- Determine whether you need to install a DB2 FixPak for your version of WebSphere Application Server by reviewing
the information on the WebSphere Application Server Supported Hardware, Software, and APIs Web site at
www.ibm.com/software/webservers/appserv/doc/latest/prereq.html.
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." If you do not have to update your DB2 UDB
installation with a FixPak, proceed to the steps in
"Configuring DB2 Universal Database (UDB) 7.1 for use with WebSphere Application Server."
To upgrade DB2 with a FixPak, do the following:
- If you have not already done so, see the WebSphere Application Server Supported Hardware, Software, and APIs Web site at
www.ibm.com/software/webservers/appserv/doc/latest/prereq.html
to learn whether you need to install a
DB2 FixPak for your level of WebSphere Application Server. Note the required FixPak level.
- Go to the DB2 Online Support Web site at
www-4.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/download.d2w/report,
navigate to the download page
for the needed FixPak, and download the appropriate file. Read the accompanying README file for installation suggestions.
- Ensure that you are logged into the machine with superuser (root) privileges.
- Navigate to the directory containing the downloaded file.
- Uncompress and untar the file to extract the DB2 files.
- Ensure that the group root exists on the machine. If it does not, add it by
entering the following command:
# groupadd root
- Move to the directory containing the installallpatch script by entering the
following command:
# cd delta_install
- Install the FixPak by using the installallpatch script, as follows:
# ./installallpatch
- After you install the FixPak, complete the steps in
"Configuring DB2 Universal Database (UDB) 7.1 for use with WebSphere Application Server."