Installing DB2

This section provides information on how to install DB2 for use with WebSphere Portal Express.

Before you begin:

You should have completed reviewing the Planning for DB2 topic.
Review Preparing your Windows machine before continuing.

Make sure DB2 is set up with updated kernel parameters according to the recommendations in the DB2 Quick Beginnings guide at DB2 Technical Support.
DB2 Connect, part of IBM^® DB2 Universal Database™ Enterprise Server Edition, must be installed on the same machine as WebSphere Portal Express.

When you install DB2 using the DB2 installation program, it automatically creates a DB2 administrative user with the correct operating system rights.
If you are using a type 2 connection, before you begin installing WebSphere Portal Express, you must also install the client software, DB2 Connect, on the same machine as WebSphere Portal Express and WebSphere
Application Server. Installing DB2 Connect enables the WebSphere Portal Express to use the required JDBC drivers. You must also ensure that the DB2 Connect installation is the same name as the server profile name. Refer to the DB2 information
center.

If you are using a type 2 driver, configure your DB2 Connect client with the following commands. If you are using a remote database, complete this step separately from the WebSphere Portal Express installation.
- db2 update dbm cfg using tp_mon_name WAS
- db2 update dbm cfg using spm_name hostname, where hostname is the host name of WebSphere Portal Express.
Because the default for spm_name is the hostname itself, specifying the hostname parameter is optional. If your hostname is more than eight characters, use empty double quotes (" "). For example, db2 update dbm cfg using spm_name " ".
Before installing DB2, log in with a user ID that has administrative authority. This user should have the following specifications:
- Be defined locally
- Belong to the local Administrator group
- Act as part of the operating system
- Have permissions to create a token object
- Windows 2000 only: Have permissions to increase quotas
- Windows 2003 only: Have permissions to adjust memory quotas for a process
- Have permissions to replace a process level token
To edit user rights:
- For the first two specifications: Click Start > Programs > Administrative Tools > Computer Management > Local Users and Groups.
- For the last four specifications: Click Start > Programs > Administrative Tools > Local Security Policy. Then, click Local Policies > User Rights Assignment.
To install DB2, follow the instructions that are provided with the DB2 documentation to install DB2 and the required fix pack.