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.