ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 237283

calendar_today

Updated On:

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.