Troubleshooting Guide › Troubleshooting and Maintenance Procedures › Reindex the CA ControlMinder Database

Reindex the CA ControlMinder Database

Because many updates are made to the CA ControlMinder database, the database files may become fragmented. Reindexing and rebuilding the database helps ensure database optimization for speed and reliability. Reindex the database during your routine maintenance procedures every three to six months, and whenever you have a performance problem.

Note: In this procedure the CA ControlMinder database is installed in the default location, /opt/CA/AccessControl/seosdb (UNIX) and C:\Program Files\CA\AccessControl\Data\seosdb (Windows). To perform this procedure, you must log in as a root user (UNIX) or as an administrator (Windows).

To reindex the CA ControlMinder database

1. Stop CA ControlMinder.
2. Navigate to the following directory:
   • (UNIX) /opt/CA/AccessControl/seosdb
   • (Windows) C:\Program Files\CA\AccessControl\Data\seosdb
3. Back up the database:

   dbmgr -backup backup_directory
   

4. Index the database:

   dbmgr -util -build seos_cdf.dat
   dbmgr -util -build seos_odf.dat
   dbmgr -util -build seos_pdf.dat
   dbmgr -util -build seos_pvf.dat
   

Note: To further reduce the size of the database on UNIX computers, you can use the sepurgdb utility to delete references to undefined records from the database. For more information about the sepurgdb utility, see the Reference Guide.

More information:

dbmgr -util Function—Manage Existing Database

sepurgdb Utility—Purge Database References to Undefined Records