Perform database maintenance - Intergraph Smart 3D - Administration & Configuration - Hexagon

Intergraph Smart 3D Project Management

Language
English
Product
Intergraph Smart 3D
Subproduct
Project Management
Search by Category
Administration & Configuration
Smart 3D Version
13.1

In order to keep consistent performance and report accurate data over time, it is important to perform some basic maintenance operations on your project databases. Failure to do so will result in performance degradation over time. The following Project Management commands help you manage your project databases to better maintain optimal performance.

Database Maintenance

Database > Maintenance Command provides a tool to purge temporary data that might cause performance issues. For example, you can delete temporary symbol variations (or flavors) in the database. The software uses these temporary symbol variations during creation or placement of certain symbols.

You can use this command to delete records of objects that users have deleted from the model. The command also enables you to rebuild and reorganize selected indexes.

Database Integrity

Database > Integrity Command verifies the consistency of model objects. The process runs directly on a database (site, catalog, model, or reports) and creates records for objects that need to be cleaned. Objects with database integrity problems can interfere with modeling activities or impact the accuracy of project deliverables, such as drawings or reports. A typical example of a database integrity issue is an object that exists without a mandatory relation to another object in the model.

The workflow to address database integrity issues has three steps:

  1. Run the Integrity Command. Hexagon recommends that you check your databases regularly and promptly report any unknown problems to customer support.

  2. Generate a report to review found issues. Database integrity errors are not expected. However, if they do occur, you can correct them by performing the workflow outlined for the database integrity error in the Database Integrity Reference documentation. If you receive a database integrity error that is not listed in the documentation, contact customer support.

  3. Use the Clean Database Command to address problems.

Clean Database

Database > Clean Database Command cleans the catalog or model database objects to address issues found by running Database > Integrity Command.

Database Backup

Tools > Backup Command saves backup copies of the selected model databases and their associated site and catalog databases to a single folder. An established backup plan is mandatory for your databases for performance and as a means of disaster recovery. If the databases are never backed up, the log file will continue to grow until no more drive space is available, thus causing the database to come to a halt.

What do you want to do?