| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| How WMQI determines its database connections ... Anyone ? |
« View previous topic :: View next topic » |
| Author |
Message
|
| schroederms |
 Posted: Tue Jan 20, 2004 2:02 pm Post subject: How WMQI determines its database connections ... Anyone ? |
 |
|
Disciple
Joined: 21 Jul 2003
Posts: 169
Location: IA
|
I have a general question on how WMQI grabs database connections, I'm catching some heat from my boss so I thought I would try to fine out if there is a formula to this madness.
Anyway a little topology of this place.
Our backend EAI database is ORACLE.
I'm running two brokers.
Broker1, has two execution groups (GRP1 & default)
GRP1 has one flow and Ex Grp Default a one flow.
The one flow in GRP1 has 2 additional instances set and goes after ORACLE.
The flow in Default has no additional instances and DOES NOT go after ORACLE.
Broker2, has 5 execution groups (SAP1, SAP2, GRP1, & GRP2).
SAP1 has 15 flows however none go after ORACLE.
SAP2 has 4 flows however none go after ORACLE.
GRP1 has 4 flows and ONE goes after ORACLE and no addtional instances.
GRP2 has 2 flows each goes after ORACLE and one flow has two additional instances on it.
Now somewhere I read each execution groups has 3 connections so:
7 ( ex grps) X 3 = 21 plus 3 ( from Broker1-GRP1 one + 2 additional) plus 1 ( from Broker2-GRP1) plus 3 ( from Broker1-Grp2 one + 2 additional) = TOTAL OF 28
Is there such a thing as connection pooling in WMQI ? Does it realease its connections on addtional instances when they are not needed ? ( Does not look like it does).
Any thoughts ?
Thanks in advance.
Mike  |
|
| Back to top |
|
 |
| kirani |
| Posted: Fri Jan 23, 2004 11:45 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
| schroederms wrote: |
Now somewhere I read each execution groups has 3 connections so:
|
That's not true.
The logic for number of connections is this:
For each message flow thread, one connection is required per node that accesses a separate ODBC data source name. IF the same DSN is used by different node within the message flow, the same connection is used.
Based on the information you had provided, your total number of connection to the ORACLE DB would be 3 (for MF in GRP1 on BKR1) + 1 (For MF in GRP1 on BKR2) + 4 (for MFs in GPR2 on BKR2) = 8.
I am assuming that all nodes in your message flows are going after the same DSN.
| schroederms wrote: |
Is there such a thing as connection pooling in WMQI ? Does it realease its connections on addtional instances when they are not needed ? ( Does not look like it does).
|
Not really. When a message flow node initiates access to the user database, it opens a connection to the DSN. This is done the first time the message is processed by the message flow node. The broker will then caches this connection until the EG or broker is shut down.
I hope this helps.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
