AutoSys Workload Automation

Hi all.

Actually we have around 140 autosys agent. (11.3.6).

  . Autosys AGENT : 140

                    JOBS : 6,500

                    Running jobs per day : 720,000

  . DB:  ORACLE 11G RAC

            PROCESSES :1,500

            SESSIONS : 2,300

The autosys manager parameters were seted as below.

. DB_CONNECTIONS : 128 (max)

. SCHED_SCALE : 42

My questions are below.

1. What are the appropriate values of DB_CONNECTIONS and SCHED_SCALE of our environment?

2. What does the DB_CONNECTIONS value related to?

    number of concurrent running jobs or number of agents? 

3. If the SCHED_SCALE is set to over  limit (for example 200), What would be the problem?

Thanks in advanced.

Hello

• DB_CONNECTIONS
  Defines the maximum number of database connections that the scheduler and application server can connect to. Increasing this value increases the ability of the scheduler to perform simultaneous database operations.
• The default settings are designed for shops with 10,000 jobs defined and 50,000 job runs per day.
  Default: 16
  Limits: 1-128

SCHED_SCALE
Defines the maximum limit of process threads that can be started dynamically. This value does not represent the total number of process threads that are active. This value is a scale value that is used by the scheduler to calculate the maximum limit of process threads that can be started dynamically as the workload demands. Therefore, a SCHED_SCALE value of 1 represents the lowest ceiling of additional dynamic threads that can be started to process job events (some arbitrary ceiling not necessarily equal to one). Increasing this value increases the ability of the scheduler to process job events.

it is an environment variable that identifies the number of “pipes” uses to process events.  The default setting is 5 and increasing it can help improve the throughput of the scheduler.  The limits are 1-64, with 5 the default.  Setting it too high can have adverse effects by overwhelming agents with too many requests.  For most large sites, a maximum setting of 25 is adequate. 

Default: 5
Limits: 1-64

The application server also shares the same DB_CONNECTIONS tuning parameter. On start up, if the scheduler and application server are running on the same computer, the DB_CONNECTIONS parameter value is applied to both the scheduler and the application server.

The appropriate value for these both parameters depends on your environment, Real Memory, CPU speed, How fast is your database and so on. There is no magic number to give and increasing them to their max value could have bad side effect if the physical and system resources are quite short.

We published some recommendation: Tuning and Connectivity

Regards

Jean Paul

Hi Sender,

You can define the SCHED_SCALE and DB_CONNECTIONS parameters to tune the scheduler.

DB_CONNECTIONS can be set from 1-128.

SCHED_SCALE can be set from 1-42 .

The default value of SCHED_SCALE=5 and DB_CONNECTIONS=16.

DB_CONNECTIONS is almost three times the value of SCHED_SCALE.

Based on the above defaults and the code implementation we provided you

with the formula DB_CONNECTIONS=(SCHED_SCALE*3 + 1).

The formula cannot be taken literally when touching the upper limits.

Incase you are seeing any performance delays with the current SCHED_SCALE

you can increase the value beyond 42, while restricting DB_CONNECTIONS to

128. But as increase the value of SCHED_SCALE, AutoSys will use increased

number of system resources and could hit the ceiling on your system.

With DB_CONNECTIONS having a limit of 128 this means we should not increase

SCHED_SCALE past 42, although this has a maximum value of 64.

I hope this make sense.

Thanks and best regards,

Faouzia