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.
These documents provide information about how to install InfoSphere Warehouse.
- Installing InfoSphere Warehouse: This topic is the starting point for installing and configuring InfoSphere Warehouse.
- "Install and configure InfoSphere Warehouse on System z:" This page takes you through an installation of InfoSphere Warehouse for DB2 for z/OS®.
- Installing InfoSphere Warehouse: This topic is the starting point for installing and configuring InfoSphere Warehouse for DB2 for z/OS.
- InfoSphere Warehouse installation requirements: This page links to the hardware and software requirements for the installation launchpads, data warehouse server, application server, and InfoSphere Warehouse clients.
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.
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.
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.
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 z/OS.
- 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 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.