Tivoli Data Warehouse version 1.3 : planning and implementation / [Vasfi Gucer ... et al.].

Format:

Book

Contributor:

Gucer, Vasfi.

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:

xiv, 280 p. : ill.

Edition:

1st ed.

Place of Publication:

Austin, TX : IBM, International Technical Support Organization, c2005.

Language Note:

English

Contents:

Front cover

Contents

Notices

Trademarks

Preface

The team that wrote this Redbook

Become a published author

Comments welcome

Chapter 1. Introducing Tivoli Data Warehouse V1.3

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 V1.3

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 a data warehouse project

2.1 Introduction

2.2 The inception phase

2.2.1 Understanding purpose and scope of data warehouse project

2.2.2 Understanding the impact of the data warehouse

2.2.3 Understanding the duration of a data warehouse project

2.2.4 The business case

2.3 The elaboration phase

2.3.1 Outline the requirements

2.3.2 Outline and present one technical blueprint

2.4 The construction phase

2.5 The transition phase

2.6 The iteration

2.7 The case study

2.7.1 The Construction Limited company

2.7.2 The Web Shop architecture

2.7.3 Individual components

2.7.4 Monitoring environment

2.8 The data warehouse project

2.8.1 The inception phase

2.8.2 The elaboration phase

2.8.3 The construction phase

2.8.4 The transition phase

2.9 Summary

Chapter 3. Tivoli Data Warehouse design considerations

3.1 Hardware and software requirements

3.1.1 Hardware requirements

3.1.2 Software requirements

3.1.3 Database requirements

3.1.4 Crystal Enterprise requirements

3.2 Physical and logical design considerations

3.2.1 Source databases

3.2.2 Control server.

3.2.3 Central data warehouse

3.2.4 Data marts

3.2.5 Single machine installation

3.2.6 Distributed deployment on UNIX and Windows servers

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

3.2.8 Warehouse agents

3.2.9 Considerations about warehouse databases on z/OS

3.2.10 Coexistence with other products

3.2.11 Selecting port numbers

3.3 Database sizing

3.4 Security

3.4.1 Authority required to install and maintain IBM DB2 UDB

3.4.2 Authority required to install Tivoli Data Warehouse

3.4.3 Firewalls

3.4.4 Controlling access to data in the warehouse

3.4.5 Protecting information in Crystal Enterprise Professional for Tivoli

3.4.6 Multicustomer and multicenter support

3.5 Network traffic considerations

3.5.1 Architectural choices

3.5.2 Scheduling

3.6 Integration with other business intelligence tools

3.7 ETL development

3.8 Skills required for a Tivoli Data Warehouse project

3.8.1 Implementation

3.8.2 Data collection

3.8.3 Data manipulation (ETL1 and ETL2)

3.8.4 Reporting

Chapter 4. Sizing Tivoli Data Warehouse V1.3

4.1 CPU recommendations and guidelines

4.1.1 CPUs for a single system installation

4.1.2 CPUs for a distributed installation

4.2 Memory considerations

4.3 Disk storage requirements

4.3.1 Minimum disk setup

4.3.2 Going past the minimum disk installation

4.3.3 Storage size requirements

4.4 A sizing example

4.5 The spreadsheet example tool

4.6 Tivoli Data Warehouse V1.3 sizing summary

Chapter 5. Getting Tivoli Data Warehouse V1.3 up and running

5.1 Overview of the installation

5.2 Crystal Enterprise installation (optional)

5.3 Installing the control server and creating the databases

5.3.1 Quick deployment

5.3.2 Custom or distributed deployment

5.3.3 Finishing the installation.

5.4 Installing warehouse agents (optional)

5.5 Checking the installation

5.6 Installing warehouse packs

Chapter 6. IBM Tivoli NetView warehouse pack

6.1 Case study overview

6.2 IBM Tivoli NetView warehouse pack overview

6.3 Prerequisites

6.3.1 Verifying prerequisites

6.3.2 Gathering installation information

6.4 Preparing NetView for data collection

6.4.1 Enabling NetView to export data for Tivoli Data Warehouse

6.4.2 NetView SmartSets configuration

6.4.3 Configuring NetView data warehouse daemon (tdwdaemon)

6.5 Installing the NetView warehouse packs

6.5.1 Backing up the Tivoli Data Warehouse environment

6.5.2 Establishing ODBC connections

6.5.3 Installing NetView warehouse pack software

6.5.4 Fix Pack 1 for IBM Tivoli NetView warehouse pack

6.6 Testing, scheduling, and promoting the ETLs

6.6.1 Promoting the ETLs to Test mode

6.6.2 Testing the ETLs

6.6.3 Scheduling the ETLs

6.6.4 Promoting the ETLs to Production mode

6.7 Reporting

6.7.1 Accessing the Crystal ePortfolio feature

6.7.2 Example reports

Chapter 7. Performance maximization techniques

7.1 DB2 performance

7.1.1 Introduction

7.1.2 Buffer pools

7.1.3 Tablespaces

7.1.4 Indexes and the Design Advisor

7.1.5 Environment settings and the Configuration Advisor

7.1.6 Snapshot monitoring

7.1.7 Maintenance

7.2 Operating system performance tuning

7.2.1 Windows environments

7.2.2 AIX environments

7.3 Tivoli Data Warehouse performance

Chapter 8. Troubleshooting

8.1 Log files

8.2 Common installation problems

8.2.1 Core installation problems

8.2.2 Warehouse pack installation problems

8.3 Runtime problems

8.4 Miscellaneous problems

8.5 Hints and tips

Chapter 9. IBM DB2 UDB administration for Tivoli Data Warehouse

9.1 DB2 general concepts.

9.2 Installing and configuring the DB2 client and server

9.2.1 Installing the DB2 server on Windows

9.2.2 Installing the DB2 server on AIX

9.2.3 Installing the DB2 client

9.3 Installing IBM DB2 Warehouse Manager

9.3.1 Installing IBM DB2 Warehouse Manager on a Windows platform

9.3.2 Installing IBM DB2 Warehouse Manager on an AIX platform

9.4 Basic database administration

9.4.1 DB2 tools

9.4.2 Basic activities and commands

9.5 Basic DB2 Data Warehouse administration

9.6 Configuring DB2 to work with Tivoli Data Warehouse V1.3

Appendix A. Additional material

Locating the Web material

Using the Web material

System requirements for downloading the Web material

How to use the Web material

Related publications

IBM Redbooks

Other publications

Online resources

How to get IBM Redbooks

Help from IBM

Index

Back cover.

Notes:

"April 2005."

"SG24-6343-00."

Includes bibliographical references and index.

OCLC:

61447428