| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Database Open/Close connection in a flow... |
« View previous topic :: View next topic » |
| Author |
Message
|
| Maximus |
 Posted: Tue Jul 13, 2004 6:21 am Post subject: Database Open/Close connection in a flow... |
 |
|
Acolyte
Joined: 14 Jun 2004
Posts: 57
|
Hi Guys,
Does WBI Message Broker 5.0 open a new connection every time a database operation is used and close the connection when execution of the message flow ends? Or is there some kind of connection pooling mechanism? If there is, what kind of pooling and how does it work? Any experiences? |
|
| Back to top |
|
 |
| JT |
| Posted: Tue Jul 13, 2004 6:39 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
Excerpt from the Toolkit > Help > Help Contents:
| Quote: |
User database connections
The number of connections required by the broker to a user database depend to some extent on the actions of the message flows that access that database. For each broker that accesses a database, one connection is required for every node that accesses a separate ODBC data source name (DSN) for each message flow thread. If the same DSN is used by a different node, the same connection is used.
When you start a broker, it opens all the connections that it requires. The broker caches these database connection handles for performance reasons. For example, when a message flow node initiates access to a user database, it opens a connection for the data source. This is done the first time that a message is processed by that message flow node. This connection remains open until the execution group or broker is shut down.
If you stop the broker, it releases all current database connection handles.
If you are using the same database for application data and for broker internal data, you must add the two connection requirements together when you calculate how many connections are required. For details of broker database connection requirements, see XREF REQUIRED.
If you are using DB2 for your database, and you believe the connections that the broker might require exceed the default allowance of forty, you must increase the maxappls parameter to a new value based on your calculations. |
|
|
| Back to top |
|
|
| Maximus |
| Posted: Tue Jul 13, 2004 6:52 am Post subject: |
|
|
Acolyte
Joined: 14 Jun 2004
Posts: 57
|
Wow that was quick! Thanks for the answer, I searched the PDF but did not search the information center.
Regards,
Maximus |
|
| 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
|
|
|
|
