search cancel

autorep command takes long time to process

book

Article ID: 112116

calendar_today

Updated On:

Products

CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) Workload Automation Agent

Issue/Introduction

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.

Cause

This is likely attributed to the deletion of a large amount of data from the database.

Environment

Any OS
Any DB
Any release of Workload Automation AE.

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.