How to modify maximum number of connections that a agent can make against database?
search cancel

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