Timeout Threshold to Connect to DBs

Products

• CA Identity Suite

Issue/Introduction

We are looking to change the timeout threshold to connect to the databases on our IAM IDM 14.4 servers. Is there an easy solution to this? 

 

 

Environment

Release : 14.x

Resolution

The database connections are managed by the application server's DB connection pools, The connection pool settings, including timeout values, can be updated in the data sources in the standalone-full-ha.xml. On vAPP you can use the Wildfly CLI to update the configuration.

You should check these settings:

<idle-timeout-minutes>5</idle-timeout-minutes>

 For production, you may want to change these to:

<blocking-timeout-millis>10000</blocking-timeout-millis>

<idle-timeout-minutes>0</idle-timeout-minutes>

 What this will do is reduce the timeout wait on connections that are idle from 5mins to 0min. And keep the time to block while waiting for an available connection to 10secs. You can try a lower value.