About this guide
Who should read this guide
Publications
IBM Tivoli Enterprise Console library
Tivoli Data Warehouse Library
Related Publications
Accessing publications online
Ordering Publications
Contacting IBM Software Support
Determine the business impact of your problem
Describe your problem and gather background information
Submit your problem to IBM Software Support
Searching knowledge bases
Obtaining fixes
Updating support information
Participating in newsgroups
Conventions used in this guide
Terminology
Typeface conventions
Operating system-dependent variables and paths
Command line syntax
Overview
Overview of Tivoli Data Warehouse
Overview of the Tivoli Enterprise Console warehouse pack
Data sources and targets
Reports
General information about reports
Installing and configuring a warehouse pack
Prerequisites
Product notes and limitations
Database-sizing considerations
Preinstallation procedures
Installing the base warehouse pack
Post-installation procedures for the base warehouse pack installation
Installing this warehouse fix pack and creating the extended attribute filter table
Installing this fix pack
Creating the extended attribute filter table
Uninstallation of the warehouse pack
Multiple data centers
Multiple customer environments
Maintenance and problem determination
Backing up and restoring data
Pruning data
Central data warehouse database
Data mart
Extraction control (table Extract_Control)
Reference information
Event Class and Extended Attribute filters
Changing the Tivoli Enterprise Console server ID
Changing the schema name
Configuring database client drivers
Problem determination
ETL Processes
EC2_m05_ETL2_Initialization_Process
EC2_c05_ETL1_Process
EC2_m10_ETL2_Process
Central data warehouse information
Sample scenario
Component configuration
Component Type
Component Extension
Component
Relationship Type
Relationship Rule
Component Relationship
Component Type Keyword
Attribute Type
Attribute Rule
Attribute Domain
Component Attribute
Component Type Relationship
Attribute Type Relation
Component measurement
Measurement Group Type
Measurement Group
Measurement Group Member
Measurement Unit Category
Measurement Unit
Measurement Type Relationship
Time Summary
Measurement Source
Measurement Source History
Measurement Type
Measurement Rule
Measurement
Threshold Measurement Objective
Threshold Measurement Objective Range
Threshold Severity Level
Component events
Event Type
Event
Event Attribute
Event Attribute Type
Event Group
Event Group Member
Event Group Type
Event Type Relationship
Event Relationship
Component-Event Relationship
Event Rule Relationship
Component-Event Rule Relationship
Helper tables
Exception tables
Incremental extraction
Data mart schema information
EC2 Event data mart
Star schema
Event star schema
EC2.F_EVENT_PIT fact table
EC2.F_Event_MSG fact table
EC2.F_Event_ACL fact table
EC2.F_EVENT_EXTSLOT fact table
EC2.F_EVENT_EXTS_NM fact table
Metric dimension table
Dimension tables
EC2.D_STATUS dimension table
EC2.D_SEVERITY dimension table
Appendix. Notices
Trademarks
Index