Previous Topic: Reindex the CA ControlMinder Database

Next Topic: Change Port Number for CA ControlMinder Agent Communication

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

Rebuild the CA ControlMinder Database

Because many updates are made to the CA ControlMinder database, the database files become fragmented. Reindexing and rebuilding the database helps ensure database optimization for speed and reliability. Rebuild the database during your routine maintenance procedures every three to six months.

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 rebuild the CA ControlMinder database

  1. Stop CA ControlMinder.
  2. Navigate to the following directory:
  3. Back up the database: 
    dbmgr -backup backup_directory
  4. Export the existing rules and the user-related data from the database: 
    dbmgr -export -l -f exported_filename
dbmgr -migrate -r migrated_filename
  5. Navigate to the following directory and create a directory in it named seosdb_new:
  6. Create a database in the seosdb_new directory: 
    dbmgr -create -cq
  7. Copy the exported_filename and migrated_filename files to the seosdb_new directory.
  8. Import into the new database the existing rules and user-related data that you exported from the old database: 
    selang -l -f exported_filename
dbmgr -migrate -w migrated_filename
  9. Rename the seosdb directory to seosdb_old.
  10. Rename the seosdb_new directory to seosdb.
  11. Start CA ControlMinder.

More information:

dbmgr Utility