Maintenance & Utilities

Db2 environments are becoming more complex to manage and the traditional housekeeping methods can no longer handle the growing number of objects and the increased availability demands. Many shops use in house solutions to automate backups, statistics collection and reorg. However, there is an increasing need to use intelligent housekeeping and avoid unnecessary work. Exploiting Real Time Statistics allows you to identify the rate of changes and trigger maintenance only when tables reach a certain threshold. You can save resources and minimize costs by assuring that only the utilities that really need to be done are triggered for execution. At the same time it is important to make sure that all the objects are covered and recoverable. Automation may help in saving resources and cutting down expensive maintenance tasks while ensuring full recoverability and availability.