MQSeries.net :: View topic

andrewjhenderson

I have not seen this technote mentioned on mqseries.net but have a look if additional instances is your thing.

We were getting ODBC connection issues with infrequent traffic in MB v6,
( tcp/ip timeout probably ), but could not understand why.

Supposed behaviour from the manual was this.

When you start a broker, and while it is running, it opens connections to WebSphere MQ queues and to databases. The broker makes the connections when it needs to use them, and they remain open until:
The message flow becomes idle
The message flow is stopped
The broker is stopped

The exception to what is in the manual is this technote :

"Database connections are not released when using additional instances"

http://www-1.ibm.com/support/docview.wss?rs=849&context=SSKM8N&context=SSKMAB&q1=additional+instances&uid=swg21239256&loc=en_US&cs=utf-8&lang=en

I'm sure people on this board may be aware of this already, but I was not, so I post it for anyone else who is confused by seeing ODBC connections, they think should have gone.