AutoSys 4.x Database Connections
In AutoSys 4.x the number of database connections is influenced by the EPCount parameter in the $AUTOUSER/config.$AUTOSERV file or in the AutoSys Admin UI on Windows. One database connection is made for each EP. Database connections are also created by client utilities in AutoSys 4.x. These client utility database connections only exist for the lifetime of the client utility transaction.
AutoSys 11.0 Database Connections
In AutoSys 11.0 the Scheduler and Application Servers maintain a constant pool of database connections.
The number of connections can be control by using the environment variable DB_CONNECTIONS.
The current documentation for DB_CONNECTIONS is as follows:
Controls the maximum number of database connections allotted to the Scheduler. Increasing this value increases the Scheduler's ability to perform simultaneous database operations.
Limit: 1 to 128
Note: The Application Server also shares the same DB_CONNECTIONS tuning parameter. If the Scheduler and Application Server are run on the same Windows computer, then this value will be applied to both processes upon startup.
Note: The Application Server also shares the same DB_CONNECTIONS tuning parameter. If you set this value in the environment script files located in the $AUTOUSER directory and start the Scheduler and Application Server on the same UNIX computer after sourcing the environment, then this value will be applied to both processes upon startup.
In AutoSys 11.0 the client utilities, by default, do not access the database directly.
Client utility requests are routed through the Application Server, which uses its database connection to fulfill the request.
The connections remain open and reserved until the Application Server(s) and Scheduler(s) are stopped.
The default Application Server setting is 32.
There is an additional 1 db_monitor connection (process) per Scheduler and Application Server.
A tie-breaker scheduler will reserve between 2-5 connections by default.
Running in HA mode will result in an additional connection (process).
It is recommended to set this parameter within the $AUTOUSER/autosys.sh.$hostname file (r11.0) on Linux/Unix.
This parameter must be set in the environment and cannot be set via the $AUTOUSER/config.$AUTOSERV file.
For Windows it should be an environment variable set at the System level.