Troubleshooting Guide › Troubleshooting and Maintenance Procedures › Rebuild the CA Access Control Database

Rebuild the CA Access Control Database

Because many updates are made to the CA Access Control 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 Access Control 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 Access Control database

1. Stop CA Access Control.
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. 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:
   • (UNIX) /opt/CA/AccessControl
   • (Windows) C:\Program Files\CA\AccessControl\Data
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 Access Control.

More information:

dbmgr Utility