How to rebuild your database.

Products

• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation AE - Scheduler (AutoSys)
• Workload Automation Agent
• CA Privileged Identity Management Endpoint (PIM)

Issue/Introduction

Steps to rebuild the indices of your seosdb database.

Environment

Release: R12.8 SP1 / PAMSC 14.x
Component: SEOSNT

Resolution

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'

Additional Information

For additional information on the syntax of the 'dbmgr' command in the product documentation.