This chapter is from the book

Although the DB2 documentation covers the installation and configuration of
DB2 servers and clients, today provides more detailed instructions on installing
the server. (Day 6, "Installing and Configuring DB2 Clients," shows
how to install the DB2 clients.) I also explain each decision you'll be
faced with when installing.

As you know from Day 1, "What DB2 Can Do for You," the DB2 server
runs on many different operating systems. Because this book focuses primarily
on the Windows platform, however, the examples are specific to that interface,
as are the installation instructions in this lesson.

Today you see how to perform an interactive Typical, Custom, or Compact install
of the DB2 server product. Typical and Compact installs require fewer questions
to answer, but to see exactly what the install program adds to your system,
you'll also look at the Custom install.

NOTE

If you're migrating from previous versions of DB2, you must complete
certain procedures before installing DB2 UDB Version 8. The instructions for
migrating from a previous version are beyond the scope of this book.

Preparing for the Install

Go through the steps in this section before you begin installing to ensure
that you have the required items and information.

Hardware and Software Requirements

Before installing the DB2 product, check to see that you have the proper
hardware and software components available on your system:

Disk spaceThe amount of disk space required to install DB2 depends
on the options that you choose to install. Typically, you should have between
260600 MB of free disk space to install DB2. You also need additional disk
space to store the applications and databases that you'll use with DB2
(this amount depends on the amount and type of data you store in your
databases).

ProcessorYou can run DB2 on a Pentium-based computer. For 64-bit
DB2 products, an Itanium-based computer is required.

MemoryTo run the DB2 graphical tools, you need at least 128 MB of
memory installed. The more memory you have, the faster the tools will run.
Additional memory is required for any clients connecting to your system and to
run other programs on your computer.

Operating systemsDB2 can be installed on Windows NT Version 4 with
Service Pack 6a or higher, Windows 2000 with Service Pack 2, Windows XP
(32-bit), and Windows Server 2003 (32-bit and 64-bit).

NOTE

The DB2 Personal Edition product runs on all Windows operating systems. It
has the same function as the DB2 server, but it can't accept requests from
remote clients.

SoftwareYou will need Java Runtime Environment (JRE) Version 1.3.1
to run DB2's Java-based tools such as the Control Center. During
installation, the correct level of the JRE is installed if it is not already. An
Internet browser is required to view the online help.

User accountsYou must have one user account to install DB2, and two
user accounts for setup. The user accounts can be created before you install
DB2, or you can have the DB2 Setup Wizard create them for you.

CommunicationsYou need communications software only if you want to
access remote databases or have remote clients access your databases. Regardless
of the operation, you have several communication protocols to choose from:
TCP/IP, NetBIOS, and Named Pipes. All these protocols are installable options in
Windows operating systems. You don't need to purchase separate products to
provide this support. Make sure that you've installed and configured the
protocol support that you intend to use.

NOTE

Lightweight Directory Access Protocol (LDAP) is supported for DB2, but the
use of LDAP is beyond the scope of this book.

Creating a User Account for Installing DB2 Products

You need a local or domain user account to install DB2. The user account must
belong to the Administrators group on your computer, and it must adhere to DB2
naming rules and have the Act as Part of the Operating System advanced user
right.

To create a user account on a Windows 2000 system, choose Start | Settings |
Control Panel | Administrative Tools | Computer Management. Expand Local Users
and Groups, right-click on Users, and choose New User. Create a new user by
filling in the details in the New User dialog box.

To grant advanced user rights on Windows, you must be logged on as a local
administrator. On a Windows 2000 system, choose Start | Settings | Control Panel
| Administrative Tools | Local Security Policy. Expand the Local Policies object
and select User Rights Assignment. In the right window pane, select the Act as
Part of the Operating System policy to open the Local Security Policy Setting
dialog box. Click Add to open the Select User or Groups dialog box. Click the
user account that you will use for the install procedure and click Add. Click OK
to finish.

A valid DB2 user account can contain up to 30 characters and complies with
DB2's naming rules:

The username must begin with A through Z, @,
#, or $.

It cannot contain accented characters.

It can contain alphanumeric characters, in lowercase, uppercase, or mixed
case, and special characters @, #, $, or
_.

You can't use these special words: USERS, ADMINS,
GUESTS, PUBLIC, or LOCAL or any SQL reserved
word.

You can't begin the username with IBM, SQL, or
SYS.

TIP

Windows Server 2003, Windows 2000, and Windows XP currently have a practical
limit of 20 characters.