installation, planning and application of Infosphere Warehouse 10.1

Overview of installing Infosphere Warehouse 10.1 components

Infosphere Warehouse is a product suite that combines the advantages of DB2 with IBM's Data warehouse infrastructure. You can use Infosphere Warehouse to build a complete enterprise-class data Warehouse solution. The following components are available in the Infosphere Warehouse:

Table 1. Infosphere Warehouse Components

TD style= "BORDER:0;PADDING:0;" >infosphere Warehouse Data Server TD style= "BORDER:0;PADDING:0;" >infosphere Warehouse Client

Infosphere Warehouse component	infosphere Warehouse Component Overview
db2 Enterprise server Edition Intelligent miner< /p> Infosphere Federation Server Relational Wrapper
infosphere Warehouse Application Server	Management console SQW administration Cubing Services management Smart Mining management Unstructured text analysis IBM data Server client WebSphere Application Server cubing Services cube server
design Studio Sqw tool Cubing Servic Es modeling Intelligent Mining tools Unstructured text analysis tools IBM data Server client Intelligent Miner Visualization cubing Services Client Admin System console command line client

Infosphere Warehouse server components contain data servers and application servers, this article describes how to install a data server, and leverages the DB2 database partitioning feature (DB Partition Feature, DPF) constructs the environment of partitioned database as the base platform of data warehouse, and realizes data integration and business intelligence through DataStage and Cognos. The operating system and software versions used in this article are:

Red Hat Enterprise Linux 5.6

Infosphere Warehouse Enterprise Edition 10.1

DataStage Enterprise Server Edition 8.5

Cognos Enterprise Edition 10.2

Data Server Installation Requirements

The following are the operating systems and required updates that support the Infosphere Warehouse Data server component:

Table 2. Data Server Installation Requirements

Operating System	Required Updates
AIX 6.1 Power System	At least for SP5 TL6, and at least need To the following C + + runtime file set: Xlc.rte 11.1.0.1 or newer version XLC AIX RTE 11.1.0.1 or newer version
AIX 7.1 Power System	At least the following C + + runtime file sets are required: Xlc.rte 11.1.0.1 or newer version XLC AIX RTE 11.1.0.1 or newer version
HP-UX 11i v3 IA64	phkl_41481, phkl_42035, phkl_42335, phkl_41588 or installation Infosphere Warehouse Fix Pack 2
Red Hat Enterprise Linux (RHEL) Server 5 x86-64	5.6 or later
Red Hat Enterprise Linux (RHEL) Server 6 x86-64
SUSE Linux Enterprise Server (SLES) x86-64	SP3 or later
SUSE Linux Enterprise Server (SLES) x86-64	SP1 or later
Solaris SPARC
Windows Server 2003 ( Standard Edition, Enterprise Edition, Datacenter Edition) x86-32	SP2 or later
Windows Server 2003 ( Standard Edition, Enterprise Edition, Datacenter Edition) x86-64	SP2 or later
Windows Server 2003 R2 ( Standard Edition, Enterprise Edition, Datacenter Edition) x86-32	SP2 or later
Windows Server 2008 ( Standard Edition, Enterprise Edition, Datacenter Edition) x86-32	SP2 or later
Windows Server 2008 ( Standard Edition, Enterprise Edition, Datacenter Edition) x86-64	SP2 or later
Windows Server 2008 R2 ( Standard Edition, Enterprise Edition, Datacenter Edition) x86-64

The following are the requirements for hardware, disk space, and memory for the Infosphere Warehouse component:

Data server component: At least 1GB memory, 4.7G disk space.

Application Server component: At least 1GB memory, 4.7G disk space.

For more information on installation requirements, please refer to http://www.ibm.com/support/docview.wss?uid=swg21616399