Out of DB connections / Increase Database Connections

book

Article ID: 40203

calendar_today

Updated On:

Products

DSERIES- SERVER CA Workload Automation DE - System Agent (dSeries)

Issue/Introduction

Introduction:

When the number of jobs and applications increases, the server requires more database connections for processing workload.  If you are experiencing degraded performance, it could be due to available database connections.  Check for ‘Out of DB connections’ warning messages in the server tracelog.txt to verify if your server is experiencing this problem.  The number of active database connections is maintained by the server property database.maxconnections.in.pool and defaults to 50 connections in R11.3 and 100 connections in R12 release.

 

An example of tracelog entry:

20160325 22:00:00.000 [relationaldatabase] [WARN] DM.Appl.<Application Name>.<Generation>: Out of DB connections, waiting: 0

 

As per CA Workload Automation DE Deployment Best Practices guide, on a busy server our recommendation is set this value to 400.  Refer to the guide for details.  If you are unsure what this value should be, contact CA support for guidance.

 

Note: The database should allow for this many connections as well.  Validate with your DBA for the number of simultaneous connections allowed is greater than database.maxconnections.in.pool.

 

Instructions:

Setting the Maximum Database Connections to 400. 

1.    Change directory to <Server install directory>/config

cd <Server install directory>/config 

2.    Execute the script setdbparm.[bat/sh]

On Windows:

setdbparm.bat database.maxconnections.in.pool

Changing max connections in pool (database.maxconnections.in.pool)

Enter new max connections in pool: 400

Verify new max connections in pool: 400 

On UNIX:

setdbparm.sh database.maxconnections.in.pool

Changing max connections in pool (database.maxconnections.in.pool)

Enter new max connections in pool: 400

Verify new max connections in pool: 400  

3.    Restart dSeries Server for the change to take effect.

 

Additional Information:

Refer to CA Workload Automation DE Deployment Best Practices for additional best practices.

 

Environment

Release: DSWAHA01300-12-Workload Automation DE-High Availability
Component: