These documents provide a general overview of IBM® InfoSphere®
Announcing Dynamic Warehousing from IBM: This website
provides an overview of a new approach to business insight called
Dynamic Warehousing from IBM.
InfoSphere Warehouse Announcement Letter: This announcement
letter includes introductory and planning information for InfoSphere
Warehouse. It also describes the new features in V9.5.2.
InfoSphere Warehouse brochure: This brochure describes how
InfoSphere Warehouse extends the powerful functions of DB2®
with advanced features for building and working with data
warehouses, data marts, and mixed workload environments.
InfoSphere Warehouse Product page: This website provides an
overview of InfoSphere Warehouse and the following integrated DB2
components: DB2 Enterprise Server Edition, Data Partitioning,
InfoSphere Warehouse Design Studio, SQL Warehousing Tool, InfoSphere
Warehouse OLAP acceleration, InfoSphere Warehouse Administration
Console, InfoSphere Warehouse Data Mining, Text Analysis, and
Visualization, IBM AlphaBlox® analytics, and DB2 Query
These documents provide information about how to install InfoSphere
Tutorials and samples
You can explore InfoSphere Warehouse by following the tutorials. The
tutorials use sample data in sample projects that are ready to run in your
InfoSphere Warehouse Tutorial: Learn how to build and
deploy an end-to-end business intelligence solution that extends the
capabilities of a InfoSphere warehouse. This tutorial is also a part
of the InfoSphere Warehouse Design Studio Help system.
Designing the physical data model for your data warehouse:
Learn how to create, test, and deploy a physical data model by
completing Module 1 of the InfoSphere Warehouse Tutorial.
Designing applications to build a data warehouse: Learn how
to design and run SQL-based data flows that help to populate and
maintain data warehouse tables by completing Module 2 of the
InfoSphere Warehouse Tutorial. Learn how to embed data flows inside
of control flows and deploy data warehouse applications by
completing Module 3 of the InfoSphere Warehouse Tutorial.
Designing OLAP metadata: Learn how to create, test, and
deploy multidimensional metadata and materialized query tables
(MQTs) for online analytical processing (OLAP) by completing Module
4 of the InfoSphere Warehouse Tutorial. Follow-on modules include
Module 5, which explains how to create, test, and deploy web-based
analytics that query OLAP cubes (using AlphaBlox), Module 6, which
teaches you how to create, test, and deploy mining models, and
Module 7, which teaches you how to build IBM AlphaBlox
Data mining tutorials and samples: Learn how to perform
typical mining tasks such as analyzing product affinities and
Use these resources to find information to help you develop the data flows,
control flows, and mining models that make up a data warehouse
Designing a data flow: This topic explains how to design
and create data flows.
Designing control flows: This explains how to design and
create control flows.
Designing cube models and cubes: This provides information
about how to design a complete OLAP model with InfoSphere Warehouse
metadata objects. A complete OLAP model documents the relationships
that exist within your relational data.
Designing mining flows: This provides information about how
to design and create mining flows.
Use these resources to help you deploy data warehouse applications.
Deployment: This topic provides an overview of data
warehouse application deployment and delta deployment, and also
links to detailed information.
Deploying control flows: This provides an overview of data
warehouse application deployment and delta deployment for InfoSphere
Warehouse for DB2 for z/OS.
Importing and exporting OLAP objects using the Design
Studio: This provides information about using the Design
Studio to import and export metadata objects to your data design
project or your InfoSphere database.
Deploying your mining flow: This explains how you can
generate code from your mining flows so that you can deploy them
with your business applications or reporting tool of
These documents provide information about how to best Administer InfoSphere
Warehouse to meet your needs.
Managing data warehouse applications: This topic explains
how to update, enable, disable, and uninstall the data warehouse
applications that you deploy.
Administering control flows: This explains how to update,
enable, disable, and uninstall the data warehouse applications that
you deploy in InfoSphere Warehouse for DB2 for z/OS.
Managing metadata: This explains how to create, modify, and
drop database metadata objects.
Connecting to resources: This explains how to manage
connections to databases and system resources.
Creating database connections: This explains how to define
the database connections for InfoSphere Warehouse for DB2 for
Creating system resources: This explains how to create the
system resources for InfoSphere Warehouse for DB2 for z/OS.
Enabling a database: This explains how to enable a database
to run mining activities.
Managing OLAP and cubing administration tasks: This
explains how to manage cube servers and cubes, import metadata, and
optimize OLAP queries by using the Administration Console.
Managing mining models: This provides information about how
to view, import, export, update, and delete a mining model.
You can use the InfoSphere Warehouse Design Studio to control and manage the
workloads in your warehouse database.
Managing database workloads: The InfoSphere Warehouse
Design Studio supports the ongoing development, refinement,
validation, and monitoring of a workload management solution called
a workload management scheme.
When a problem occurs, you must determine the scope of the problem and which
InfoSphere Warehouse product components are involved. The resources in this
section provide information about identifying and solving problems.
IBM Software Support for InfoSphere Warehouse: This website
provides links to documents that can help you solve problems with
InfoSphere Warehouse. These self-help documents include frequently
asked questions (FAQs), Hints and tips, Technotes, and IBM
Redbooks®. From this website you can submit and track problems,
read the latest product flashes and announcements, and download fix
Software Support for DB2 for Linux®, UNIX®, and
Windows®: This website provides links to documents that
can help you solve problems with DB2. These self-help documents
include frequently ask questions (FAQs), hints and tips, Technotes,
and IBM Redbooks. From this website you can submit and track
problems, read the latest product flashes and announcements, and
download fix packs.