search cancel

Autosys DB performance - large number of jobs

book

Article ID: 226983

calendar_today

Updated On:

Products

CA Workload Automation AE

Issue/Introduction

We have a large number of jobs (about 30%) defined to the Autosys database that either have not run in years, or have never run at all.

Are these job definitions potentially using up resources on my system in terms of performance/response times?

The space is not an issue; Iam concerned about any other potential impact. 

Environment

Release : 12.0

Component : CA Workload Automation AE (AutoSys)

Resolution

Yes, having a large number of jobs just sitting there defined but never used could have some performance impacts.

Things like autorep -J ALL option would waste time/resources getting data that is not used/useful.
WCC makes calls to autosys to also collect ALL the jobs defined to AutoSys.
Collecting an extra 10k to 30k worth of jobs or scanning for / thru them is a waste of time and resources.

The scheduler will scan thru the tables as it pulls job definitions, processes events and updates job statuses...
Typical AutoSys performance issues appear when the tables like ujo_proc_event or ujo_job_runs or ujo_machine get large, but the less you have in ujo_job_status and ujo_job could still help in general.   

Monitor your "autoaggr -h" results, and as_server logs, and DBMaint.out.

Look for slow responses or statistics and trends.

If interested contact your Broadcom account team regarding an AutoSys/WCC health check?
It is something our SWAT/Services team can do, they provide you with scripts that collect data about your environment, they review it and can then give you a report on the environment.
Showing you your numbers, status, performance, recommendations, etc...