78 Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition
images, as is common for many demos and examples. In our lab environment,
we had three VMware images in an ESX server:
System One
This “main” system VMware image is based on the standard IBM Smart
Analytics System 5710 that IBM offers as a method of purchasing a solution
for data warehousing that is ready for immediate use. This VMware image
makes a perfect starting base for those in need of a rapid implementation for
development and testing, or even as a small company solution.
The integrated solution for our lab included the following software:
– Novell SUSE Linux Enterprise Server 11 (SLES) SP2 64-bit operating
system
– InfoSphere Warehouse Departmental Edition, 10.1
– DB2 for Linux, UNIX, and Windows, Version 10.1
– Cognos10 BI 10.1.1.0 and Cognos Mobile 10.1
– WebSphere Application Sever 8.0.0.2
Our DB2 database had two database partitions in two physical nodes.
System One was the coordinate node of the partitioned DB2 database.
WebSphere Application Server hosted our InfoSphere Warehouse Instance.
This system was also the IBM Cognos 10 BI server. During the initial
configuration, we selected the option to install the “Cognos Live Demo”
example set. The Cognos Live Demo provides a preconfigured and populated
execution database containing a defined table and schema structure along
with a retail product and client data set.
This example set also contained a populated Cognos metadata database in
support of the already created Cognos reports. We used these reports in the
demonstration provided in 3.2, “Warehouse Live! Demo” on page 71 in
support of our scenario.
This system was configured with 5 GB of RAM and 1 processor.
System Two
The second VMware image was also based on IBM Smart Analytics System
5710 with the same software installed as in System One. This was the
second DB2 database physical node. Both the InfoSphere warehouse and
Cognos BI servers were deactivated.
Note: When installing and configuring the Cognos Live Demo VMware
image, select the option Cogos Live Demo to include the demo database
and reports.