Save time and effort with automatic database maintenance

With automatic maintenance, DB2 enables the automation of RUNSTATS, REORG and BACKUP utilities. Specify an online and offline windows, and DB2 will run these utilities during these periods, should it determines they are required.

Periodic collection of statistics using RUNSTATS, and reclaiming wasted space with REORG can improve query performance, and help prevent critical situations that may occur when access plans are calculated from inaccurate statistics. Automatically running BACKUPs when needed can help you feel secure you can recover your critical data to a given point in time when required.

DB2 makes it easy to configure automatic maintenace with a user-friendly graphical wizard that will walk you through the process. Save time and effort with automatic maintenance!