Clean Up a Database
As you develop your Vision applications, you can destroy database objects--frames, forms, or entire applications--that you no longer need. When you destroy these objects, you no longer can use them.
However, these objects still exist in the Ingres system catalogs in the database and take up space on your disk. Vision provides a Cleanup utility that checks the system catalogs for database objects that you have destroyed. It removes the catalog entries for these objects to create space for new objects.
You must be the database administrator for the database to use the Cleanup utility. It is good practice to run the Cleanup utility periodically and after a number of database objects have been destroyed.
However, be aware that the utility cleans up the entire database and, therefore, can tie up your system for a considerable amount of time. Run the utility when no one needs access to the database.
To run the Cleanup utility
1. Select Utilities from the menu on the Applications Catalog window or Application Flow Diagram Editor.
Because the utility affects the entire database, you can run it from any application.
2. Select Cleanup from the submenu.
(This menu item appears only if you are the database administrator for the database in which you are working.)
Vision displays a warning that the utility takes a while to run and asks you to confirm that you want to run it.
3. Confirm that you want to run the Cleanup utility.
Vision runs the utility; when it finishes, it displays the number of rows deleted.
4. Select End to return to the window from which you called the Cleanup utility.
You also can clean up a database with the sysmod utility that releases the recovered disk space back to the operating system.
Note: Visual DBA provides an alternative way to clean up the database. Detailed steps for performing this procedure can be found in the Dropping Objects section of the online help for Visual DBA.