Default recommendation for GEL_CONNECTION_POOL_S253100 feature

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

What is the recommendation value for GEL_CONNECTION_POOL_S253100? 

Environment

Clarity 16.2.3 onwards 

Resolution

• GEL_CONNECTION_POOL_S253100 is a feature to Isolate GEL queries into their own JDBC connection pool
• The feature can be enabled by running command admin toggle-feature GEL_CONNECTION_POOL_S253100 1
• Flush the caches
• Check the properties.xml connection pool tag is added, now gel script will use the number defined in maximum connections 

• <backgroundServer jvmParameters="-Xmx1024m -Xms512m -XX:MaxMetaspaceSize=512m -XX:-UseGCOverheadLimit" programParameters="">
       <connectionPool maximumConnections="20" maxIdle="5" minimumIdleEvictionTime="5000" timeBetweenEvictionRuns="15000" validationQuery="select 1 from dual"/>
  
  </backgroundServer>