Recommendation for connection and thread pool parameters of Informatica agent (plugin)

Products

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

Issue/Introduction

Is it recommended for both db pool and thread pool to be the same?

Environment

Release : 12

Component :

Resolution

The "informatica.thread.pool.size" is related to number of total connections for executing Tasks/Workflows.   This parameter closely related to "informatica.connection.pool.size" parameter.  The pool size is for JDBC connections and yes, both parameters should ideally be the same.

The default value is 20 for both parameters.  If users intended to run more than 20 jobs concurrently or have long run workflows, then increase the values accordingly.

Additional Information

For more details, see this link here.