Context
Tool mentors explain how a tool can perform tasks, which are part of ITUP processes and activities. The tasks are listed as Related Elements in the Relationships section.
You can see the details of how processes and activities are supported by this tool mentor, by clicking the links next to the icons:
Details
IBM® Tivoli® Data Warehouse keeps track of your systems management data to help you proactively manage and prevent
problems. Vital data is collected and aggregated into Tivoli Data Warehouse from various incident tracking and
monitoring tools. Incident data such as the number and classification of incidents, occurrence time, and incident
resolution information are centrally located and reported to assist in the problem management process. By viewing your
aggregated incident information through Tivoli Data Warehouse, trends are identified and root causes can be determined.
This valuable information will prevent incidents from recurring, and from becoming problems that affect your business'
bottom line.
Tivoli Data Warehouse also collects and reports typical monitoring information such as CPU idle time and NIC send and
receiving rates. Reports can be scheduled to generate automatically, so that a snapshot view of your resources is
always readily available. This view allows you to identify possible issues and take preventive actions before an
incident or problem occurs. With Tivoli Data Warehouse, your IT resources are fully equipped to positively impact your
business through effective problem management.
Figure 1 illustrates how Tivoli Data Warehouse fits into your IT enterprise. The numbers in the figure correspond to
the numbers in the textual description below:
Figure 1: Fitting TDW into an enterprise
-
Your environment contains many products and services that monitor and manage your IT enterprise. This software can
run on a z/OS system or on distributed systems such as Windows, AIX, and other UNIX®-based operating systems. These
products and services generate data that is stored in a variety of formats, including relational databases,
spreadsheet data, log files, and other formats. This data is called operational data, and the databases
and files in which it is stored are referred to as operational data stores. In the Availability Management
Process, these operational data stores contain monitoring data from tools such as ITM.
-
Extract, transform, and load (ETL) programs take the data from these various sources and place it in a central
data warehouse. This action often requires that the data be aggregated and converted into the standard format
for historical data in the central data warehouse. These central data warehouse ETL programs are provided in
applications called warehouse enablement packs, hereinafter called warehouse packs, which come
from various sources:
-
The product that generates the operational data. For example, IBM Tivoli Enterprise Console® provides a
warehouse pack that contains the ETL program to populate the central data warehouse.
-
A product that analyzes data that is captured by other products. For example, an independent software
vendor might write a warehouse pack to extract operational data that is collected by a system management
product that does not provide a warehouse pack.
-
A customer-created warehouse pack. For example, if there are no products that analyze the data that is
important to your enterprise, you can write your own customized ETL program to capture the specific
historical data that you want to analyze.
-
The central data warehouse contains the historical data from all your diverse sources. This data store is optimized
for the efficient storage of large amounts of data and has a documented format, which makes the data accessible to
many analysis solutions.
-
Another set of ETL programs extracts a subset of historical data from the central data warehouse. This subset of
data, called a data mart, contains data that is tailored to and optimized for a specific reporting or
analysis task. Like the ETL programs in step 2, these data mart ETL programs are typically packaged in warehouse
packs, which come from a variety of sources. A data mart ETL program can access any data in the central data
warehouse, including data placed there by the central data warehouse ETL program of another warehouse pack.
-
The data marts, which are subsets of the historical data that satisfy the needs of a specific department, team, or
customer, are optimized for interactive reporting and data analysis.
-
You use a program to analyze a specific aspect of your enterprise, such as availability management, using the data
in one or more data marts. Tivoli Data Warehouse provides Crystal Enterprise, a Web-based tool, for reporting. It
is also possible to use other programs to access TDW data marts and perform OLAP analysis or data mining.
For More Information
For more information about this tool, click on the link for this tool at the top of this page.
|
