Previous Topic: Reindex the CA ControlMinder DatabaseNext Topic: Change Port Number for CA ControlMinder Agent Communication


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 using the following command:
    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 -d “absolute path for seosdb_new” -f exported_filename
    dbmgr -migrate -w migrated_filename
    

    Note: Selang does not use -d option. If you run the "selang -l -f exported_filename" command after stopping the CA ControlMinderservice and move to seosdb_new directory, the exported rules are stored in $SEOSDIR/seosd.

  9. Rename the seosdb directory to seosdb_old.
  10. Rename the seosdb_new directory to seosdb.
  11. Start CA ControlMinder.

More information:

dbmgr Utility