How to calculatethe initialized Connection Pooling size in the Connection byTIBCO ActiveMatrix Adapter for Siebel.

How to calculatethe initialized Connection Pooling size in the Connection byTIBCO ActiveMatrix Adapter for Siebel.

book

Article ID: KB0093511

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for Siebel -
Not Applicable -

Description

Description:
For TIBCO ActiveMatrix Adapter for Siebel (Siebel Adapter), in Design Time -> Adapter Services Tab, set Number of Threads to Process Siebel Events, Number of Connections to Siebel and Number of Threads. In the Multithreading tab, set JMSIntegrationDefaultSession, DefaultJmsQueueSession and DefaultJmsTopicSession with different values or leave blank. In Run Time, we will see an info Connection Initializing Connection pool with size : <value>. Whether these parameters are set with values or left blank will result in a different Connection Initializing Connection pool size value.

Resolution

The process of calculating connection pooling size is a little complicated. Refer to the following: 

In Design Time, suppose we set the following parameters with values:

In Adapter Services Tab, 
Number of Threads to Process Siebel Events -> A
Number of Connections to Siebel -> B
Number of Threads -> C

In Multithreading Tab, 
JMSIntegrationDefaultSession -> D
DefaultJmsQueueSession -> E
DefaultJmsTopicSession -> F

In Run Time, we could calculate connection pool size as following process:

The initialized value of the connection pool size is 0;

if C = 0,then 
connection pool size = connection pool size + 1
connection pool size = connection pool size + D
connection pool size = connection pool size + E
connection pool size = connection pool size + F

if project has publisher then
if the B > 0 then 
connection pool size = connection pool size + B
else 
connection pool size = connection pool size + A
else 
if D exists then
if D is blank then
connection pool size = connection pool size + C
else 
connection pool size = connection pool size + D
if E exists then
if E is blank then
connection pool size = connection pool size + C
else 
connection pool size = connection pool size + E
if F exists then
if F is blank then
connection pool size = connection pool size + C
else
connection pool size = connection pool size + F

if project has publisher then
if the B > 0 then 
connection pool size = connection pool size + B
else 
connection pool size = connection pool size + A
connection pool size = connection pool size + 1

Example:

 

if: A=1,B=1,C=1,E=1,F=1 and project config does not contain publisher then:
we can calculate the connection pool size is : 1 + 1 + 1 = 3
if: A=1,B=1,C=6,E=blank ,F=blank and project config does not contain publisher then:
we can calculate the connection pool size is : 1 + 6 + 6 + 1 = 14

Issue/Introduction

How to calculatethe initialized Connection Pooling size in the Connection byTIBCO ActiveMatrix Adapter for Siebel.

Additional Information

TIBCO ActiveMatrix Adapter for Siebel Concepts -> Chapter 3 ->How the Adapter Interfaces with the Siebel Application -> Connection Pooling