DE (dSeries) : 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

Workload Automation DE Server fails to trigger workload and jobs are waiting.

Cause

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

Environment

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

Resolution

Setting the Maximum Database Connections to 400. 

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

cd <Server install directory>/config 

  1. 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  

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

 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.

 

Additional Information

On a busy server, the recommendation is set this value to 400.