Resolution:
Description:
============

When using DB Concepts feature in BE, you can set the InitialSize, Min Size and Max Size for the connection pooling mechanism. Often users are concerned on how to arrive at a proper value for these parameters and this article provides further guidance on it.


Environment:
==========

   o TIBCO BusinessEvents 4.x and 5.x releases

   o Database Concepts feature in TIBCO BusinessEvents.




Symptoms:
========

Setting insufficient values in the Max size may lead to disconnection and improper database connection issues like "Bad connection" error messages.



Resolution:
=========

Generally number of connection should be more than the sum or equal to number of worker threads, at least when the load is max all the worker should get one connection each. This rule-of-thumb should be a good starting point; but at the end - you should monitor the connections on the DB side and see how many connections are being utilized under load. No need to define excessive size pools - unnecessarily.

In addition you can specify the following properties in your CDD.

Wait Timeout=nn (in seconds)

In case of all connections are busy, thread will wait for time specified before it gets good connection. (rather than immediately giving 'Bad connection error').  Again you can decide this timeout value, based on some monitoring with DB queries.

This guidance can be use for calculating the number of connections when there are multiple jdbc resources, in a single project.


Note:
====

Similar properties in BE 3.0.2 release also exists, which you need to set it in the be-engine.tra files.

be.dbconcepts.pool.min=&ltDefault=0>

be.dbconcepts.pool.max=&ltdefault=as set in designer>, which you can override here

be.dbconcepts.pool.inactivityTimeout=&ltdefault=0>

be.dbconcepts.pool.PropertyCheckInterval=&ltdefault=900>

be.dbconcepts.connection.check.interval=&ltdefault=60>



Attachments:

==========

None.


References:

==========

TIBCO BusinessEvents Data Modeling Developer’s Guide - DatabaseConceptsPropertiesReference

Guideline on setting a value for max pool size, when using the Database concepts (DB concepts) feature in TIBCO BusinessEvents (BE).