A jil syntax check of 2000 jobs takes 4+ hours

Products

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

Issue/Introduction

Autosys 11.3.6 SP8 Cum1 on Linux connecting to an Oracle 12c Enterprise Edition Release 12.2.0.1.0 – 64 bit - Oracle Pluggable RAC database.

We are seeing jil syntax checks taking an excessive amount of time.

For example, a jil syntax check of 2000 jobs takes 4+ hours.

Environment

Release : 11.3.6

Component : CA Workload Automation AE (AutoSys)

Resolution

Root-Cause:

As the number of job inserts/updates/deletes grows in a single file, the string data parsed and traversed between the client(jil) and server grows, and moreover, it has to get these jobs dependencies and relationships from the database and form the meta string and send to client(jil) takes more time.

This is the actual design.

As a best practice, we suggest splitting the single jil syntax file into smaller files each containing around 500 jobs.
Syntax check of all smaller files completed in less than 50 minutes.