Implementing Tivoli Data Warehouse V 1.2

Implementing Tivoli Data Warehouse V 1.2

by Edson Manoel, Cristiano Colantuono, Dr. Hans-Georg Köhne, Devi Raju, Ghufran Shah, Sergio Henrique Soares Monteiro
Released June 2004
Publisher(s): IBM Redbooks
ISBN: None

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

With Tivoli Data Warehouse, you can analyze historical trends from various Tivoli and customer applications. The Tivoli Data Warehouse infrastructure enables a set of extract, transform, and load (ETL) utilities to extract and move data from Tivoli application data stores to a central repository.

The open architecture of Tivoli Data Warehouse also enables data from non-Tivoli applications to be integrated into its central repository. Data from the central repository can be extracted into data marts that pertain to the reporting needs of selected groups. These data marts can also be used to produce cross application reports.

This IBM Redbooks publication focuses on planning, installation, customization, use, maintenance, and troubleshooting topics related to the new features of the Tivoli Data Warehouse version 1.2. This is done using a number of case study scenarios and several warehouse enablement packs.

The instructions given in this book are very detailed and explicit. These instructions are not the only way to install the products and related prerequisites. They are meant to be followed by anyone to successfully install, configure, and set up Tivoli Data Warehouse environments of any size.

Table of contents

  1. Figures (1/2)
  2. Figures (2/2)
  3. Tables
  4. Examples
  5. Notices
    1. Trademarks
  6. Preface
    1. The team that wrote this redbook
    2. Become a published author
    3. Comments welcome
  7. Part 1: Fundamentals
    1. Chapter 1: Introducing Tivoli Data Warehouse 1.2
      1. Data warehousing basics
        1. Data warehouse
        2. Data mart
        3. Business intelligence
        4. Data mining
      2. Tivoli Data Warehouse
      3. What is new in Tivoli Data Warehouse 1.2 (1/2)
      4. What is new in Tivoli Data Warehouse 1.2 (2/2)
        1. Crystal Enterprise™
        2. IBM DB2 UDB for OS/390 and z/OS support
        3. Flexible and extended configuration support
        4. Installation enhancements
        5. Serviceability and scalability improvements
      5. Tivoli Data Warehouse architecture
        1. Tivoli Data Warehouse control center server
        2. Source databases
        3. Central data warehouse
        4. Data marts
        5. Warehouse agents and agent sites
        6. Crystal Enterprise Server
      6. Benefits of using Tivoli Data Warehouse
    2. Chapter 2: Planning for Tivoli Data Warehouse 1.2
      1. Hardware and software requirements (1/2)
      2. Hardware and software requirements (2/2)
        1. Hardware requirements
        2. Software requirements
        3. Database requirements
        4. Crystal Enterprise requirements
      3. Physical and logical design considerations (1/4)
      4. Physical and logical design considerations (2/4)
      5. Physical and logical design considerations (3/4)
      6. Physical and logical design considerations (4/4)
        1. Source databases
        2. Control server
        3. Central data warehouse
        4. Data marts
        5. Single machine installation
        6. Distributed deployment on UNIX and Windows servers
        7. Distributed deployment on z/OS, UNIX, and Windows servers
        8. Warehouse agents
        9. Considerations about warehouse databases on z/OS
        10. Coexistence with other products
        11. Selecting port numbers
      7. Database sizing
      8. Security
        1. Authority required to install and maintain IBM DB2 UDB
        2. Authority required to install Tivoli Data Warehouse
        3. Firewalls
        4. Controlling access to data in the warehouse
        5. Protecting information in Crystal Enterprise Professional for Tivoli
        6. Multicustomer and multicenter support
      9. Network traffic considerations
        1. Architectural choices
        2. Scheduling
      10. Integration with other business intelligence tools
      11. ETL development
      12. Skills required for a Tivoli Data Warehouse project
        1. Implementation
        2. Data collection
        3. Data manipulation (ETL1 and ETL2)
        4. Reporting
    3. Chapter 3: Getting Tivoli Data Warehouse 1.2 up and running
      1. Preparing for the installation (1/4)
      2. Preparing for the installation (2/4)
      3. Preparing for the installation (3/4)
      4. Preparing for the installation (4/4)
        1. Ensuring fully qualified host names
        2. Installing and configuring IBM DB2 client and server
        3. Crystal Enterprise installation
      5. Tivoli Data Warehouse 1.2 installation
      6. Quick start deployment (1/2)
      7. Quick start deployment (2/2)
        1. Quick start deployment: installation and configuration
        2. Configuring the control database
        3. Creating ODBC connections to the data mart databases
      8. Distributed deployment (1/5)
      9. Distributed deployment (2/5)
      10. Distributed deployment (3/5)
      11. Distributed deployment (4/5)
      12. Distributed deployment (5/5)
        1. Distributed deployment installation: Windows and UNIX
        2. Distributed deployment installation: z/OS
        3. Creating ODBC connections to the data mart databases
      13. Installing warehouse agents (1/2)
      14. Installing warehouse agents (2/2)
        1. Installing IBM DB2 Warehouse Manager
        2. Creating the remote agent sites
      15. Verification of the installation (1/2)
      16. Verification of the installation (2/2)
        1. Verifying the remote agent install
      17. Installing warehouse enablement packs
    4. Chapter 4: Performance maximization techniques
      1. DB2 performance
      2. Operating system performance tuning
        1. Windows environments
        2. Primary Windows performance factors
        3. AIX environments
      3. Tivoli Data Warehouse performance
  8. Part 2: Case study scenarios
    1. Chapter 5: IBM Tivoli NetView Warehouse Enablement Pack
      1. Case study overview
      2. IBM Tivoli NetView WEP overview
      3. Prerequisites
        1. Verifying prerequisites
        2. Gathering installation information
      4. Preparing NetView for data collection (1/3)
      5. Preparing NetView for data collection (2/3)
      6. Preparing NetView for data collection (3/3)
        1. Enabling NetView to export data for Tivoli Data Warehouse
        2. NetView SmartSets configuration
        3. Configuring NetView Data Warehouse daemon (tdwdaemon)
        4. Verifying NetView data collection enablement
      7. Installation of the NetView WEPs (1/2)
      8. Installation of the NetView WEPs (2/2)
        1. Backing up the TDW environment
        2. Establishing ODBC connections
        3. Installing NetView Enablement Pack Software
        4. Defining the authority to the warehouse sources and targets
      9. Testing, scheduling, and promoting the ETLs (1/2)
      10. Testing, scheduling, and promoting the ETLs (2/2)
        1. Promoting the ETLs to TEST mode
        2. Testing the ETLs
        3. Scheduling the ETLs
        4. Promoting the ETLs to Production status
      11. Running NetView ETLs on remote agent sites (1/2)
      12. Running NetView ETLs on remote agent sites (2/2)
      13. Reporting (1/4)
      14. Reporting (2/4)
      15. Reporting (3/4)
      16. Reporting (4/4)
        1. Accessing the Crystal ePortfolio feature
    2. Chapter 6: IBM Tivoli Monitoring Warehouse Enablement Pack
      1. Case study overview
      2. IBM Tivoli Monitoring WEP overview
      3. Prerequisites
      4. Installing the ITM WEP data collector component (1/2)
      5. Installing the ITM WEP data collector component (2/2)
        1. Activate data collection
      6. Installing and configuring ITM Generic WEP (1/5)
      7. Installing and configuring ITM Generic WEP (2/5)
      8. Installing and configuring ITM Generic WEP (3/5)
      9. Installing and configuring ITM Generic WEP (4/5)
      10. Installing and configuring ITM Generic WEP (5/5)
        1. Backing up the TWH databases
        2. Establishing an ODBC connection on the Control Center
        3. Installing the ITM 5.1.1 AMX ETL processes
        4. Installing AMX Fix Packs
        5. Defining the authority to the warehouse sources and targets
        6. Modifying the ETL for the source table name to the RIM user
      11. Installing and configuring ITM for OS WEP
        1. Backing up the TWH databases
        2. Installing the ITM 5.1.1 AMY ETL processes
        3. Installing AMY Fix Packs
        4. Defining the authority to the warehouse sources and targets
      12. Testing, scheduling, and promoting the ETLs (1/2)
      13. Testing, scheduling, and promoting the ETLs (2/2)
        1. Testing the ETLs
        2. Checking that data has been collected
        3. Scheduling the ETLs
        4. Promoting the ETL status to Production mode
      14. Reporting (1/3)
      15. Reporting (2/3)
      16. Reporting (3/3)
        1. Available reports
        2. Accessing the Crystal ePortfolio
      17. Troubleshooting of ITM data collection (1/3)
      18. Troubleshooting of ITM data collection (2/3)
      19. Troubleshooting of ITM data collection (3/3)
        1. Using itmchk.sh script
        2. Manual checking of ITM data collection
    3. Chapter 7: IBM Tivoli Storage Manager Warehouse Enablement Pack
      1. Case study overview
      2. IBM Tivoli Storage Manager WEP overview
      3. Prerequisites
      4. Installing and configuring ITSM WEP 5.2 (1/3)
      5. Installing and configuring ITSM WEP 5.2 (2/3)
      6. Installing and configuring ITSM WEP 5.2 (3/3)
        1. Changes required on the IBM Tivoli Storage Manager servers
        2. Installing the IBM Tivoli Storage Manager ODBC
        3. Backing up the TWH databases
        4. IBM Tivoli Storage Manager WEP installation
        5. Defining the authority to the warehouse sources and targets
      7. IBM Tivoli Storage Manager ETL processes (1/2)
      8. IBM Tivoli Storage Manager ETL processes (2/2)
        1. ANR_C05_ETL1_Process
        2. ANR_C10_EXPServer_Process
        3. ANR_M05_ETL2_Process
      9. Testing, scheduling, and promoting the ETLs
        1. ETL data collection verification
      10. Reporting (1/3)
      11. Reporting (2/3)
      12. Reporting (3/3)
        1. Available reports
        2. Accessing the Crystal ePortfolio
  9. Part 3: Appendixes
    1. Appendix A: IBM DB2 UDB administration for other relational DBAs
      1. Common DBA tasks
      2. Creating databases
      3. Creating databases in IBM DB2
      4. Creating databases in Oracle
      5. Creating databases in Sybase
      6. Managing space
      7. DB2 space management
      8. Oracle space management
      9. Sybase space management
      10. Creating objects in the database
      11. Creating tables in DB2
      12. Creating tables in Oracle
      13. Creating tables in Sybase
      14. Additional table control parameters
    2. Appendix B: Tivoli Data Warehouse 1.2 reference
      1. Report listing (1/2)
      2. Report listing (2/2)
      3. Measurement sources
    3. Appendix C: Warehouse Enablement Packs properties file
      1. The twh_install_props.cfg properties file
  10. Related publications
    1. IBM Redbooks
    2. Other publications
    3. Online resources
    4. How to get IBM Redbooks
    5. Help from IBM
  11. Index (1/2)
  12. Index (2/2)
  13. Back cover

Product information

  • Title: Implementing Tivoli Data Warehouse V 1.2
  • Author(s): Edson Manoel, Cristiano Colantuono, Dr. Hans-Georg Köhne, Devi Raju, Ghufran Shah, Sergio Henrique Soares Monteiro
  • Release date: June 2004
  • Publisher(s): IBM Redbooks
  • ISBN: None