Try OpenEdge Now
skip to main content
Database Essentials
Database Administration : Periodic monitoring tasks
 

Periodic monitoring tasks

There are tasks that you must perform on a periodic basis to promote monitoring of your system. Some of these tasks, like database analysis, should be done monthly. Other tasks, such as a compacting an index, should only be done as needed.
Periodic OpenEdge maintenance tasks include:
*Database analysis
*Rebuilding indexes
*Compacting indexes
*Fixing indexes
*Moving tables
*Moving indexes
*Truncating and growing BI files
*Dumping and loading
* Database analysis
* Rebuilding indexes
* Compacting indexes
* Fixing indexes
* Moving tables
* Moving indexes
* Truncating and growing BI files
* Dumping and loading