autorep command takes long time to process

Document ID : KB000112116
Last Modified Date : 27/08/2018
Show Technical Document Details
Issue:
When running autorep to create a report on jobs, the experience is that it is taking an excessive amount of time to receive the data from the database.
Environment:
Any OS
Any DB
Any release of Workload Automation AE.
Cause:
This is likely attributed to the deletion of a large amount of data from the database.
Resolution:
As a Best Practice, whenever a large amount of data is cleared from the database, it is usually a good idea to run the reindexDB.pl script which is located in the $AUTOSYS/dbobj directory. It will improve performance.
Additional Information:
Reference https://docops.ca.com/ca-workload-automation-ae/11-4-2/en/administrating/ae-administration/maintain-the-event-server/rebuild-table-indexes-for-a-ca-workload-automation-ae-database for additional details.