Installation and configuration of DB2 Warehouse Enterprise Edition V9.5, part 1th

Brief introduction

DB2 Warehouse combines the powerful data support of IBM DB2 and a set of IBM Business Intelligence (Business Intelligence) products to provide a comprehensive business intelligence platform and its application tools, These components enable organizations to build and deploy analysis solutions for next-generation data warehouses.

The article will detail the graphical installation of DB2 Warehouse Enterprise Edition Version 9.5 and a brief description of the related components, as well as answers to common questions that may be encountered during the installation process.

DB2 Warehouse Overview

DB2 Warehouse V9.5 provides different product components for different versions, the following components are included in the Enterprise and Development editions (other versions include some of these components):

DB2 Warehouse design Studio, including IBM Data Server Developer Workbench, and a series of child parts of IBM Rational Architect.

DB2 Warehouse SQL Warehousing tool.

DB2 Warehouse Administration Console, which is part of the integrated scenario console.

DB2 Enterprise Server Edition V9.5, which supports Linux, Unix, windows;v9.5 is the only version supported by DB2 Warehouse.

DB2 Warehouse cubing Services.

DB2 Query patroller V9.5.

DB2 Warehouse Intelligent Miner 9.5.

IBM Alphablox V9.5 and its related documentation.

DB2 Warehouse V9.5 documentation, and DB2 V9.5 documents are integrated into an information center.

WebSphere application Server V6.1.0.9.

In addition to the Enterprise version, DB2 Warehouse has other versions, such as: Starter edition,intermediate Edition, Advanced Edition, Base Edition.

Pre-Installation Preparation

To set the necessary permissions for Windows Non-administrator users

When a non-administrator user installs DB2 Warehouse, the necessary permissions need to be elevated, as follows:

Run Gpedit.msc to open Windows Group Policy.

Click Computer Configuration-> Administrative Templates->windows components-> Windows Installer.

Enable the following options in turn:

Enable:always Install with elevated privileges (required).

Enable:enable User control over installs (required).

Enable:disable Windows Installer. Then set Disable Windows Installer to Never (Windows 2003 and XP) (optional).

enable:enable user to patch elevated products (optional).

Enable:enable user to use media source while elevated (optional).

Enable:enable user to browse for source while elevated (optional).

Continue clicking the User Configuration-> administrative Templates->windows components-> Windows installer,enable The following options:

Enable:always Install with elevated privileges (mandatory).

Write permission to the non-admin account target disk and file.

Run Gpupdate.exe to make the changes take effect.

Turn on the Vista UDP feature

As Vista has upgraded user Rights management, the current DB2 Warehouse v9.5 installation requires Vista UAC control, as follows:

Run Msconfig and select the Tools option on the System Configuration interface.

To locate the Enable UAC item, click the Launch button below to restart the computer.

The whole logical structure of DB2 Warehouse

DB2 Warehouse can be divided into three components: Data server,application Server and Client. The Data Server can be installed on the DB2 of a single partition, DB2 or multiple-machine environments. DB2 Warehouse supports incremental installation, where users can install product components in batches under the same installation path, so that all components are installed under a Warehouse copy, and users can choose different installation paths for installation, so that multiple Warehouse replicas coexist.

Figure 1. DB2 Warehouse Logical Structure