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.