MQSeries.net :: View topic - How to Set Database Timed Out intervel on compute nodeof MB5

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 » How to Set Database Timed Out intervel on compute nodeof MB5

How to Set Database Timed Out intervel on compute nodeof MB5

« View previous topic :: View next topic »

Author

Message

sarathsps

Posted: Tue May 09, 2006 3:58 am Post subject: How to Set Database Timed Out intervel on compute nodeof MB5

Novice

Joined: 04 May 2006
Posts: 19

Hi ,

I am using Message Broker 5.0, I am calling a DB2 Stored Procedure in the compute node by giving the datasource name on the Properties of the compute node.
1) Is there any way to set the database timeout interval on the compute node or elsewhere , so that after the interval the thread should terminates

2) In the same way how can we achieve the database pooling in the same ESQL.

Please help.

Thanks in advance

Parthasarathy S

jefflowrey

Posted: Tue May 09, 2006 4:38 am Post subject:

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

Your database connections are already pooled by Broker for you, outside of your control.

You don't need to worry about the threads or the database timeout interval.

You can't construct a database pool in ESQL.
_________________
I am *not* the model of the modern major general.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » How to Set Database Timed Out intervel on compute nodeof MB5

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