Implementing Tivoli Data Warehouse 1.2
| Autor Corporativo: | |
|---|---|
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
White Plains, NY :
IBM, International Technical Support Organization
c2004.
|
| Edición: | 1st ed |
| Colección: | IBM redbooks.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009644289206719 |
Tabla de Contenidos:
- 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.
