MQSeries.net :: View topic - Setting Timeout to ODBC

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Setting Timeout to ODBC

Setting Timeout to ODBC

« View previous topic :: View next topic »

Author

Message

mickey1691

Posted: Thu Jun 12, 2014 9:51 pm Post subject: Setting Timeout to ODBC

Novice

Joined: 04 Jun 2013
Posts: 19

Hi. Is there any way in Message Broker to set a timeout to odbc connections to an Oracle Database? As in after a set time of the connection being idle. the message broker drops the connection.

Broker version is 8.0.0.2.

Thanks!

zpat

Posted: Thu Jun 12, 2014 10:38 pm Post subject:

Jedi Council

Joined: 19 May 2001
Posts: 5866
Location: UK

I believe it is automatically dropped after one minute of non-use.
_________________
Well, I don't think there is any question about it. It can only be attributable to human error. This sort of thing has cropped up before, and it has always been due to human error.

mickey1691

Posted: Thu Jun 12, 2014 11:37 pm Post subject:

Novice

Joined: 04 Jun 2013
Posts: 19

zpat wrote:

I believe it is automatically dropped after one minute of non-use.

Is there any way to change that setting?

Simbu

Posted: Fri Jun 13, 2014 12:44 am Post subject:

Master

Joined: 17 Jun 2011
Posts: 289
Location: Tamil Nadu, India

mickey1691 wrote:

zpat wrote:

I believe it is automatically dropped after one minute of non-use.

Is there any way to change that setting?

Yes.
http://www-01.ibm.com/support/knowledgecenter/SSMKHH_10.0.0/com.ibm.etools.mft.doc/ac00406_.htm?lang=en

zpat

Posted: Fri Jun 13, 2014 2:02 am Post subject:

Jedi Council

Joined: 19 May 2001
Posts: 5866
Location: UK

This document explains when ODBC connections are released from WMB message flows.

http://www-01.ibm.com/support/docview.wss?uid=swg1IC72002

This document explains how this works with multi-instances of a flow

http://www-01.ibm.com/support/docview.wss?uid=swg21610149&myns=swgws&mynp=OCSSKM8N&mync=E
_________________
Well, I don't think there is any question about it. It can only be attributable to human error. This sort of thing has cropped up before, and it has always been due to human error.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Setting Timeout to ODBC

Jump to:

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

Protected by Anti-Spam ACP