DB2 Warehouse V9.5

Information roadmap for all users

Administrators of DB2 Warehouse should be familiar with relational database management systems and understand how the DB2 Warehouse product components work. These topics provide an overview of the DB2 Warehouse product components.

	Announcing Dynamic Warehousing from IBM® (Web site) This Web site provides an overview of a new approach to business insight called Dynamic Warehousing from IBM.
	DB2 Warehouse Announcement Letter (Marketing, pdf) This announcement letter includes introductory and planning information for DB2 Warehouse. It also describes the new features in Version 9.5.
	DB2 Warehouse brochure (Product description, pdf) This brochure describes how DB2 Warehouse extends the powerful functions of DB2 with advanced features for building and working with data warehouses, data marts, and mixed workload environments.
	DB2 Warehouse Product page (Product description) This Web site provides an overview of DB2 Warehouse and the following integrated DB2 components: DB2 Enterprise Server Edition, Data Partitioning, DB2 Warehouse Design Studio, SQL Warehousing Tool, DB2 Warehouse OLAP acceleration, DB2 Warehouse Administration Console, DB2 Warehouse Data Mining, Text Analysis, and Visualization, IBM Alphablox® analytics, and DB2 Query Patroller.

The following resources help you to install and configure DB2 Warehouse and its components.

	DB2 Warehouse Installation Guide (Manual, pdf) This publication tells you how to install and configure DB2 Warehouse.
	DB2 Warehouse installation requirements (Web site) This Web page links to the hardware and software requirements for the installation launchpads, data warehouse server, application server, and DB2 Warehouse clients.

You can explore DB2 Warehouse by following the tutorials. The tutorials use sample data in sample projects that are ready to run in your environment.

	DB2 Warehouse Tutorial (Tutorial) Learn how to build and deploy an end-to-end business intelligence solution that extends the capabilities of a DB2 data warehouse. This tutorial is also a part of the DB2 Warehouse Design Studio Help system.
	Designing the physical data model for your data warehouse (Tutorial) Learn how to create, test, and deploy a physical data model by completing Module 1 of the DB2 Warehouse Tutorial.
	Designing applications to build a data warehouse (Tutorial) 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 DB2 Warehouse Tutorial. Learn how to embed data flows inside of control flows and deploy data warehouse applications by completing Module 3 of the DB2 Warehouse Tutorial.
	Designing OLAP metadata (Tutorial) 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 DB2 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 (Tutorial) 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.

	Creating a data flow (Information Center topic) This topic explains how to design and create data flows.
	Creating a control flow (Information Center topic) This topic explains how to design and create control flows.
	Designing cube models and cubes (Information Center topic) This topic provides information about how to design a complete OLAP model with DB2 Warehouse metadata objects. A complete OLAP model documents the relationships that exist within your relational data.
	Designing mining flows (Information Center topic) This topic provides information about how to design and create mining flows.

Use these resources to help you deploy data warehouse applications.

	Deployment (Information Center topic) This topic provides an overview of data warehouse application deployment and delta deployment, and also links to detailed information.
	Importing and exporting OLAP objects using the Design Studio (Information Center topic) This topic provides information about using the Design Studio to import and export metadata objects to your data design project or your DB2 database.
	Deploying your mining flow (Information Center topic) This topic 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.

After DB2 Warehouse is installed and running, you must perform administrative tasks. Use these resources to help you manage DB2 Warehouse and its components.

	Managing data warehouse applications (Information Center topic) This topic explains how to update, enable, disable, and uninstall the data warehouse applications that you deploy.
	Managing metadata (Information Center topic) This topic explains how to create, modify, and drop database metadata objects.
	Connecting to resources (Information Center topic) This topic explains how to to manage connections to databases and system resources.
	Managing OLAP and cubing administration tasks (Information Center topic) This topic explains how to manage cube servers and cubes, import metadata, and optimize OLAP queries by using the Administration Console.
	Managing mining models (Information Center topic) This topic provides information about how to view, import, export, update, and delete a mining model.

You can use the DB2 Warehouse Design Studio to control and manage the workloads in your warehouse database.

Managing database workloads (Information Center topic) The DB2 Warehouse Design Studio supports the ongoing development, refinement, validation, and monitoring of a workload management solution called a workload management scheme.

IBM offers education that is specifically tailored to help you to learn, install, and use DB2 Warehouse.

DB2 Business intelligence training (Web site) IBM offers a comprehensive portfolio of technical training and education services that are designed for individuals, companies, and public organizations to acquire, maintain, and optimize their Business Intelligence skills. From this Web site, you can search for courses about DB2 Warehouse product components.

When a problem occurs, you must determine the scope of the problem and which DB2 Warehouse product components are involved. The resources in this section provide information about identifying and solving problems.

	IBM Software Support for DB2 Warehouse (Web site) This Web site provides links to documents that can help you solve problems with DB2 Warehouse. These self-help documents include frequently asked questions (FAQs), Hints and tips, Technotes, and IBM Redbooks. From this Web site you can submit and track problems, read the latest product flashes and announcements, and download fix packs.
	IBM Software Support for DB2 for Linux, UNIX, and Windows (Web site) This Web site 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 Web site you can submit and track problems, read the latest product flashes and announcements, and download fix packs.