|
|
|
Regardless of database implementation, regular maintenance activities are required to ensure optimal performance and responsiveness for an MDB.
Maintenance activities such as database backup, system catalog reorganization, and file and disk space monitoring for optimization are essential for best performance. These activities must occur regardless of the number or variety of CA products that access an instance of the MDB. In addition, table reorganization and statistics are also useful for performance purposes.
Most databases provide for maintenance using command line utilities and SQL commands. These features allow sites to use command files and a job scheduler to automate the maintenance process.
More Information
For more information about specific maintenance utilities and commands, consult your database documentation.
The MDB schema is upgraded when patches are applied or when an MDB is already installed and a newer MDB release is installed by another CA product.
Prior to any action that will upgrade the MDB schema, the database should be backed up by a database administrator. The backup provides the ability to restore in case an error occurs during the upgrade process.
| Copyright © 2008 CA. All rights reserved. | Tell Technical Publications how we can improve this information |