Installing and Configuring DB2 Server
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.
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 spaceThe amount of disk space required to install DB2 depends on the options that you choose to install. Typically, you should have between 260600 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).
ProcessorYou can run DB2 on a Pentium-based computer. For 64-bit DB2 products, an Itanium-based computer is required.
MemoryTo 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 systemsDB2 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).
SoftwareYou 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 accountsYou 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.
CommunicationsYou 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.
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.
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.
Windows Server 2003, Windows 2000, and Windows XP currently have a practical limit of 20 characters.