How to rebuild your database.

Document ID : KB000053157
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

Steps to rebuild the indices of your seosdb database.

Solution:

The procedure will be the following in your UNIX / LINUX environment as "root":

  1. Check if Access Control is running:
    Run: 'issec'

  2. Stop Access Control:
    Run: 'secons -s'

  3. For your Access Control database (seosdb), you need to be inside the 'seosdb' directory:
    Run: 'cd /opt/CA/eTrustAccessControl/seosdb'

  4. Build indexes of a DBIO based on data records:
    Run: 'dbmgr -u -build all'

  5. Restart Access Control:
    Run: 'seload'

The procedure will be the following in your WINDOWS environment as "Administrator":

  1. Check if Access Control is running:
    Run: 'net start|find "Access Control"'

  2. Stop Access Control:
    Run: 'secons -s'

  3. You need to be inside the 'seosdb' directory:
    Run: 'cd \Program Files\CA\eTrust Access Control\data\seosdb'

  4. Build indexes of a DBIO based on data records:
    Run: 'dbmgr -u -build seos_cdf.dat'
    Run: 'dbmgr -u -build seos_pdf.dat'
    Run: 'dbmgr -u -build seos_odf.dat'
    Run: 'dbmgr -u -build seos_pvf.dat'

  5. Restart Access Control:
    run 'seosd -start'

For additional information on the syntax of the 'dbmgr' command, please see our "CA Access Control for UNIX and Linux, Utilities Guide, Chapter 2: Utilities in Detail" or "CA Access Control for Windows, Reference Guide, Chapter 5: Utilities".