Ingres MDB Considerations (CA Technologies MDB r1.0.4) › How to Maintain an Ingres MDB (CA Technologies MDB r1.0.4)

How to Maintain an Ingres MDB (CA Technologies MDB r1.0.4)

The following activities are recommended for an Ingres-based Management Database:

• Monitor file size
• Monitor disk space
• Reorganize tables
• Collect statistics
• Reorganize the system catalog
• Back up the database

Monitoring file size and disk space, reorganizing system catalogs, and backing up the MDB database are generic maintenance activities. These activities need to occur regardless of the number or variety of CA products accessing an instance of the MDB. Table reorganization and statistics gathering are also necessary for performance purposes.

Command line utilities and SQL commands are used to perform these maintenance functions. Using a job scheduler, you can create command files that automate the housekeeping processes.

Note: Ingres provides a Visual DBA utility for administering Ingres databases, including MDBs. Most functions that are available from command line utilities and SQL statements are also available from the Ingres Visual DBA utility. For more information, see your Ingres documentation.