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.