Product overview

These documents provide a general overview of IBM® InfoSphere® Warehouse.

  • 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.

Installing

These documents provide information about how to install InfoSphere Warehouse.

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 environment.

  • 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 reports.
  • Data mining tutorials and samples: Learn how to perform typical mining tasks such as analyzing product affinities and customer segments.

Developing

Use these resources to find information to help you develop the data flows, control flows, and mining models that make up a data warehouse application.

  • 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.

Deploying

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 choice.

Administering

These documents provide information about how to best Administer InfoSphere Warehouse to meet your needs.

Workload Management

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.

Troubleshooting

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 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.