| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Connection steel open - DB2 |
« View previous topic :: View next topic » |
| Author |
Message
|
| Gama |
 Posted: Wed Apr 05, 2006 7:26 am Post subject: Connection steel open - DB2 |
 |
|
Centurion
Joined: 11 Jan 2005
Posts: 103
Location: Portugal
|
Hello all comunity,
I have some problem, in my DB2 or WMQI (2.1), that the connection to the DB2 steel open, and cause error's because exceed the limit of connection in DB2.
I WMQI 2.1, is possible force the close connection?
Exist any parameter to change that parameter in WMQI?
Thanks
Gama |
|
| Back to top |
|
 |
| fschofer |
| Posted: Wed Apr 05, 2006 8:19 am Post subject: |
|
|
Knight
Joined: 02 Jul 2001
Posts: 524
Location: Mainz, Germany
|
|
| Back to top |
|
|
| Gama |
| Posted: Wed Apr 05, 2006 8:39 am Post subject: |
|
|
Centurion
Joined: 11 Jan 2005
Posts: 103
Location: Portugal
|
Hi fschosfer, thanks for your reply.
Like JT post.
"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.
"
I only use 4 datasource's in tho execution group's and when i get the active connections to the database i have 45 connection to the Database, this is normal?
Datasources
iSeries1 (AS/400 DB2/400)
iSeries2 (AS/400 DB2/400)
db2w2k1 (DB2 8.1)
db2w2k2 (DB2 8.1)
Thanks |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Apr 05, 2006 9:00 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Are you running your flow with multiple instances?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| Gama |
| Posted: Wed Apr 05, 2006 9:04 am Post subject: |
|
|
Centurion
Joined: 11 Jan 2005
Posts: 103
Location: Portugal
|
No,
Only in default DB2 8.1 instance DB2-DB2-0, but in AS/400 are diferent's because the iSereis are tho (iSeries1 V5R2M0 and iSeries2 V5R2M0). |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Apr 05, 2006 9:10 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Are you running your flow in multiple execution groups?
Which of the 4 datasources are you seeing 45 connections to?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| Gama |
| Posted: Thu Apr 06, 2006 12:18 am Post subject: |
|
|
Centurion
Joined: 11 Jan 2005
Posts: 103
Location: Portugal
|
I have many flows, runing in several execution groups, but the same message flow only run in one execution group.
only in Windows Data Source, DB2 8.1 (DB1 and DB2)
I consluted the AS/400 and i have a lot of connctions pending. |
|
| 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
|
|
|
|
