Business Intelligence Tutorial

Lesson 12. Maintaining the data warehouse

In this lesson, you will learn to define indexes, use the RUNSTATS and REORG utilities, and monitor the warehouse database.

The amount of maintenance that is required for a database is directly related to the amount of database activity or workload. Because this tutorial does not generate significant activity, this lesson is primarily a guide to the DB2 tools and utilities that you can use when you are using an actual warehouse database.


[ Top of Page | Previous Page | Next Page | Table of Contents ]