To install DB2 Common Database Enterprise Edition under Windows system

On the control server and each Windows system that you will install a central data warehouse, data mart, or proxy site, complete the following steps to install the DB2 common database:

Please use the DB2 installation media provided with the Tivoli Data Warehouse. This ensures that you can get the correct version.

Log on to the computer as a user with sufficient permissions. On Windows systems, the account you use to log on must:

Locally defined, belonging to the local Administrators group.

Has the following advanced user rights:

operate in operating system mode;

Create a token object;

Increase the limit;

Replaces a process-level token.

Insert the DB2 installation media into the CD-ROM drive. If the program does not start automatically when you insert the DB2 installation CD, run the Setup.exe program in the root directory of the CD. Click Install, and then provide the following information when prompted:

Select DB2 Enterprise Edition products.

Select a typical installation.

You can change the default destination folder. The DB2 installation directory name cannot contain spaces, making it unnecessary to use workarounds later to correct the problem. For the remaining items, accept the default values.

For DB2 user names, specify a user that does not already exist on your system. When the DB2 Installation Wizard creates a user for you, it ensures that the user has the correct roles and privileges. If the user already exists, consider removing it, and then let the DB2 setup process recreate it.

The user name must follow the DB2 naming convention as described in the DB2 user name, user ID, group name, and instance name rule.

Please accept the option to use the same value for all DB2 username and password settings.

Record the DB2 username and password you specified for each DB2 installation in a secure location. You need to have DB2 user information to install Tivoli data Warehouse.

In a distributed installation, you do not need to use the same username and password for each DB2 common database installation. Choose not to install the OLAP Starter Kit. Tivoli Data Warehouse does not require the use of OLAP Starter kits.

Test the connection by completing the following steps:

Start the DB2 command line Processing (CLP) window by entering the following command at a command prompt: Db2cmd.

To list the local database, enter the following command: DB2 list database directory.

In most cases, the command lists at least one database, even in a new installation.