Implementing Tivoli Data Warehouse 1.2 / [Edson Manoel ... et al.].

Format:

Book

Contributor:

Manoel, Edson.

International Business Machines Corporation. International Technical Support Organization.

Series:

IBM redbooks.

IBM redbooks

Language:

English

Subjects (All):

Data warehousing.

IBM software.

Tivoli enterprise data warehouse.

Physical Description:

xxiv, 374 p. : ill.

Edition:

1st ed.

Place of Publication:

White Plains, NY : IBM, International Technical Support Organization, c2004.

Language Note:

English

Contents:

Front cover

Contents

Figures

Tables

Examples

Notices

Trademarks

Preface

The team that wrote this redbook

Become a published author

Comments welcome

Part 1 Fundamentals

Chapter 1. Introducing Tivoli Data Warehouse 1.2

1.1 Data warehousing basics

1.1.1 Data warehouse

1.1.2 Data mart

1.1.3 Business intelligence

1.1.4 Data mining

1.2 Tivoli Data Warehouse

1.3 What is new in Tivoli Data Warehouse 1.2

1.3.1 Crystal Enterprise™

1.3.2 IBM DB2 UDB for OS/390 and z/OS support

1.3.3 Flexible and extended configuration support

1.3.4 Installation enhancements

1.3.5 Serviceability and scalability improvements

1.4 Tivoli Data Warehouse architecture

1.4.1 Tivoli Data Warehouse control center server

1.4.2 Source databases

1.4.3 Central data warehouse

1.4.4 Data marts

1.4.5 Warehouse agents and agent sites

1.4.6 Crystal Enterprise Server

1.5 Benefits of using Tivoli Data Warehouse

Chapter 2. Planning for Tivoli Data Warehouse 1.2

2.1 Hardware and software requirements

2.1.1 Hardware requirements

2.1.2 Software requirements

2.1.3 Database requirements

2.1.4 Crystal Enterprise requirements

2.2 Physical and logical design considerations

2.2.1 Source databases

2.2.2 Control server

2.2.3 Central data warehouse

2.2.4 Data marts

2.2.5 Single machine installation

2.2.6 Distributed deployment on UNIX and Windows servers

2.2.7 Distributed deployment on z/OS, UNIX, and Windows servers

2.2.8 Warehouse agents

2.2.9 Considerations about warehouse databases on z/OS

2.2.10 Coexistence with other products

2.2.11 Selecting port numbers

2.3 Database sizing

2.4 Security

2.4.1 Authority required to install and maintain IBM DB2 UDB

2.4.2 Authority required to install Tivoli Data Warehouse

2.4.3 Firewalls.

2.4.4 Controlling access to data in the warehouse

2.4.5 Protecting information in Crystal Enterprise Professional for Tivoli

2.4.6 Multicustomer and multicenter support

2.5 Network traffic considerations

2.5.1 Architectural choices

2.5.2 Scheduling

2.6 Integration with other business intelligence tools

2.7 ETL development

2.8 Skills required for a Tivoli Data Warehouse project

2.8.1 Implementation

2.8.2 Data collection

2.8.3 Data manipulation (ETL1 and ETL2)

2.8.4 Reporting

Chapter 3. Getting Tivoli Data Warehouse 1.2 up and running

3.1 Preparing for the installation

3.1.1 Ensuring fully qualified host names

3.1.2 Installing and configuring IBM DB2 client and server

3.1.3 Crystal Enterprise installation

3.2 Tivoli Data Warehouse 1.2 installation

3.3 Quick start deployment

3.3.1 Quick start deployment: installation and configuration

3.3.2 Configuring the control database

3.3.3 Creating ODBC connections to the data mart databases

3.4 Distributed deployment

3.4.1 Distributed deployment installation: Windows and UNIX

3.4.2 Distributed deployment installation: z/OS

3.4.3 Creating ODBC connections to the data mart databases

3.5 Installing warehouse agents

3.5.1 Installing IBM DB2 Warehouse Manager

3.5.2 Creating the remote agent sites

3.6 Verification of the installation

3.6.1 Verifying the remote agent install

3.7 Installing warehouse enablement packs

Chapter 4. Performance maximization techniques

4.1 DB2 performance

4.2 Operating system performance tuning

4.2.1 Windows environments

4.2.2 Primary Windows performance factors

4.2.3 AIX environments

4.3 Tivoli Data Warehouse performance

Part 2 Case study scenarios

Chapter 5. IBM Tivoli NetView Warehouse Enablement Pack

5.1 Case study overview

5.2 IBM Tivoli NetView WEP overview.

5.3 Prerequisites

5.3.1 Verifying prerequisites

5.3.2 Gathering installation information

5.4 Preparing NetView for data collection

5.4.1 Enabling NetView to export data for Tivoli Data Warehouse

5.4.2 NetView SmartSets configuration

5.4.3 Configuring NetView Data Warehouse daemon (tdwdaemon)

5.4.4 Verifying NetView data collection enablement

5.5 Installation of the NetView WEPs

5.5.1 Backing up the TDW environment

5.5.2 Establishing ODBC connections

5.5.3 Installing NetView Enablement Pack Software

5.5.4 Defining the authority to the warehouse sources and targets

5.6 Testing, scheduling, and promoting the ETLs

5.6.1 Promoting the ETLs to TEST mode

5.6.2 Testing the ETLs

5.6.3 Scheduling the ETLs

5.6.4 Promoting the ETLs to Production status

5.7 Running NetView ETLs on remote agent sites

5.8 Reporting

5.8.1 Accessing the Crystal ePortfolio feature

Chapter 6. IBM Tivoli Monitoring Warehouse Enablement Pack

6.1 Case study overview

6.2 IBM Tivoli Monitoring WEP overview

6.3 Prerequisites

6.4 Installing the ITM WEP data collector component

6.4.1 Activate data collection

6.5 Installing and configuring ITM Generic WEP

6.5.1 Backing up the TWH databases

6.5.2 Establishing an ODBC connection on the Control Center

6.5.3 Installing the ITM 5.1.1 AMX ETL processes

6.5.4 Installing AMX Fix Packs

6.5.5 Defining the authority to the warehouse sources and targets

6.5.6 Modifying the ETL for the source table name to the RIM user

6.6 Installing and configuring ITM for OS WEP

6.6.1 Backing up the TWH databases

6.6.2 Installing the ITM 5.1.1 AMY ETL processes

6.6.3 Installing AMY Fix Packs

6.6.4 Defining the authority to the warehouse sources and targets

6.7 Testing, scheduling, and promoting the ETLs

6.7.1 Testing the ETLs.

6.7.2 Checking that data has been collected

6.7.3 Scheduling the ETLs

6.7.4 Promoting the ETL status to Production mode

6.8 Reporting

6.8.1 Available reports

6.8.2 Accessing the Crystal ePortfolio

6.9 Troubleshooting of ITM data collection

6.9.1 Using itmchk.sh script

6.9.2 Manual checking of ITM data collection

Chapter 7. IBM Tivoli Storage Manager Warehouse Enablement Pack

7.1 Case study overview

7.2 IBM Tivoli Storage Manager WEP overview

7.3 Prerequisites

7.4 Installing and configuring ITSM WEP 5.2

7.4.1 Changes required on the IBM Tivoli Storage Manager servers

7.4.2 Installing the IBM Tivoli Storage Manager ODBC

7.4.3 Backing up the TWH databases

7.4.4 IBM Tivoli Storage Manager WEP installation

7.4.5 Defining the authority to the warehouse sources and targets

7.5 IBM Tivoli Storage Manager ETL processes

7.5.1 ANR_C05_ETL1_Process

7.5.2 ANR_C10_EXPServer_Process

7.5.3 ANR_M05_ETL2_Process

7.6 Testing, scheduling, and promoting the ETLs

7.6.1 ETL data collection verification

7.7 Reporting

7.7.1 Available reports

7.7.2 Accessing the Crystal ePortfolio

Part 3 Appendixes

Appendix A. IBM DB2 UDB administration for other relational DBAs

Common DBA tasks

Creating databases

Creating databases in IBM DB2

Creating databases in Oracle

Creating databases in Sybase

Managing space

DB2 space management

Oracle space management

Sybase space management

Creating objects in the database

Creating tables in DB2

Creating tables in Oracle

Creating tables in Sybase

Additional table control parameters

Appendix B. Tivoli Data Warehouse 1.2 reference

Report listing

Measurement sources

Appendix C. Warehouse Enablement Packs properties file

The twh_install_props.cfg properties file

Related publications

IBM Redbooks.

Other publications

Online resources

How to get IBM Redbooks

Help from IBM

Index

Back cover.

Notes:

"June 2004."

"SG24-7100-00."

Includes bibliographical references and index.

OCLC:

560101284