Chapter 17. Historical reporting with TEDW 533
17.2 Installation and configuration for data warehouse
In this section, we describe the necessary steps to configure the data-gathering
process in your environment. The basic steps are:
1. Have the environment with the IBM Tivoli Business Systems Manager
installed and working properly. Set up the Business System View objects as
discussed in Chapter 12, Automatic Business System View creation on
page 395.
2. Have the Tivoli Enterprise Data Warehouse server or servers installed
properly with the necessary patches as specified in 17.2.1, Warehouse
integration pre-installation steps on page 533.
3. Install and configure the IBM Tivoli Business Systems Manager Warehouse
component as in 17.2.2, Setting up the source ETL on page 534.
4. Define the ODBC data source for the Microsoft SQL Server used by IBM
Tivoli Business Systems Manager, and run the ETL process. This step is
discussed in 17.3, Activating collection on page 538.
5. Evaluate the result.
Before going into the details of each step, we present the environment used in
our lab. This can be used as a starting point for setting up the data-gathering
process. We assume that no preexisting components will be used and describe
the steps of a brand new installation. We install most of the data warehouse
components in a single machine; however, for a production environment, you
may want to have the following separate machines:
򐂰 Tivoli Enterprise Data Warehouse Server machine hosting the Central
Warehouse and the Warehouse data mart databases; this should have the
largest disk capacity and the fastest processor.
򐂰 Tivoli Enterprise Data Warehouse Control Center machine hosting the
Warehouse metadata database and handling all ETL scheduling.
򐂰 Tivoli Enterprise Data Warehouse Reporting Interface machine allowing end
users to obtain reports from data stored in the IBM Tivoli Monitoring data
marts.
17.2.1 Warehouse integration pre-installation steps
It is assumed that your Tivoli Enterprise Data Warehouse Environment Version
1.1 is already installed and up and running. Details for that can be found in
Introduction to Tivoli Enterprise Data Warehouse
, SG24-6607.
534 Tivoli Business Systems Manager Version 2.1: End-to-End Business Impact Management
Prior to the installation of the Warehouse packs programs, the following tasks
must be completed:
򐂰 Upgrade IBM DB2 Universal Database Enterprise Edition Version 7.2 to at
least FixPack 6 level on your Tivoli Enterprise Data Warehouse environment.
FixPack6 for IBM DB2 Universal Database Enterprise Edition can be
downloaded from the official IBM DB2 technical support Web site at:
http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v7fphis
t.d2w/report
򐂰 Apply the following fixes for the Tivoli Enterprise Data Warehouse:
1.1-TDW-0002
1.1-TDW-0005E
1.1-TDW-FP01a
These can be downloaded from the IBM Tivoli Software support Web site,
under the Tivoli Enterprise Data Warehouse category, at:
http://www.ibm.com/software/sysmgmt/products/support/
The documentation that accompanies the FixPacks shows the installation steps
in great detail.
17.2.2 Setting up the source ETL
This section describes the installation procedures needed to install and configure
the source ETL, which is provided on the
IBM Tivoli Business Systems Manager
Version 2.1 Distributed CD. IBM Tivoli Business Systems Manager warehouse
ETL extracts data regarding business systems objects from the Microsoft SQL
Server Object database and loads it into the Tivoli Enterprise Data Warehouse
CDW database (TWH_CDW), therefore acting as a source ETL. The
measurement source code for the IBM Tivoli Business Systems Manager ETL is
GTM.
Installation can be performed using the Tivoli Enterprise Data Warehouse CLI or
the GUI installation program. Here we describe the process using the GUI
method. The following steps should be performed in the Tivoli Enterprise Data
Warehouse Control Center server.
Important:
Introduction to Tivoli Enterprise Data Warehouse,
SG24-6607,
mentions that the Windows Services Warehouse Server and Warehouse
Logger must be reconfigured to run as the db2admin user. If you have not
made this change, you will see failures when trying import data into the
TWH_CDW database. Be sure that you have reconfigured these services and
restarted them.

Get Tivoli Business Systems Manager V2.1 End-to-end Business Impact Management now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.