Installing DB2Added by IBM on June 11, 2010 | Version 1 (Original)
|This section provides information on how to install DB2® for use with Lotus® Quickr™.
This section provides information on how to install DB2® for use with Lotus® Quickr™.
Before you begin, do the following:
- You should have completed reviewing the Planning for DB2 section.
- If using a remote database, the following prerequisites must be completed separately from the Lotus Quickr installation.
- Configure your DB2 that is installed with Lotus Quickr with the following commands:
- db2 update dbm cfg using tp_mon_name WAS
- db2 update dbm cfg using spm_name hostname, where hostname is the host name of Lotus Quickr.
Note: Because the default for spm_name is the host name itself, specifying the hostname parameter is optional. If your hostname is more than eight (8) characters, use empty double quotes (" "). For example, db2 update dbm cfg using spm_name " ".
- Make sure DB2 is set up with updated kernel parameters according to the recommendations in the DB2 Quick Beginnings guide at DB2 Technical Support.
To install, review the following:
- If you install DB2 using the DB2 installation program, it will automatically create a DB2 administrative user with the correct operating system rights.
- Before installing DB2, you must log in with a user ID that has administrative authority.
This user should have the following specifications:
- Belong to the local Administrator group
- Act as part of the operating system
- Have permissions to create a token object
- 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.
The system user ID and password must match the database user ID and password for the Lotus Quickr databases. If you do not use the default DB2 database user ID, or if you must access a remote database, you must create the system user ID before installing DB2. To set up the environment for the database access, the initialization script for this user (for example, user-home/.profile
) must contain a call to the db2profile
script in the db-home/sqllib
directory. After you create the system user ID and password for the DB2 installation, add the user ID to the DB2 administration group (such as db2adm) for that system. To ensure that the user is set up correctly, login with this user ID, and start the DB2 command line processor by executing the command: db2
. If the command line processor for is displayed, the user ID is set up correctly.
- To install DB2, follow the instructions that are provided with the DB2 documentation to install DB2 and the required fix pack.
Because Lotus Quickr does not use the OLAP Starter Kit, you do not need to install the OLAP Starter Kit. If you have an existing DB2 installation with OLAP Starter Kit, it will not affect the Lotus Quickr installation or operation.
You have completed this step. Continue to the next step.
Parent topic: Setting up DB2: qp85
Setting up a remote DB2 database topic in the WebSphere Portal information center