Default recommendation for GEL_CONNECTION_POOL_S253100 feature
search cancel

Default recommendation for GEL_CONNECTION_POOL_S253100 feature

book

Article ID: 393435

calendar_today

Updated On:

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>