How to modify maximum number of connections that a agent can make against database?
book
Article ID: 52701
calendar_today
Updated On:
Products
Workload Automation Agent
Issue/Introduction
In agentparm.txt edit the following line:
db.connectionPool.maxSize=<n>
Note:
- Specify a number greater than five if you will be running many stored procedures or SQL queries on the database at one time.
- Specifying a high number of open connections to the database requires more resources. Do not specify a number greater than 20.
- If you specify zero, connections will not be reused. A new database connection opens each time you run a database job.
Environment
Release:
Component: DBAGTD
Feedback
thumb_up
Yes
thumb_down
No