MQSeries.net :: View topic - DB connectivity

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 » DB connectivity

DB connectivity

« View previous topic :: View next topic »

Author

Message

RocknRambo

Posted: Mon Nov 10, 2008 6:29 am Post subject: DB connectivity

Partisan

Joined: 24 Sep 2003
Posts: 355

how does the connectivity to a database established either for compute or db nodes ?

If multiple compute nodes are connected to the same application database (eg: SQL Server), does each compute create its own db thread or the same thread shared across? Is there a concept of db pooling in MB?

any pointing is appreciated.

-RR

zpat

Posted: Mon Nov 10, 2008 6:33 am Post subject:

Jedi Council

Joined: 19 May 2001
Posts: 5866
Location: UK

Multiple compute nodes in the same or different message flows?

sridhsri

Posted: Mon Nov 10, 2008 6:33 am Post subject:

Master

Joined: 19 Jun 2008
Posts: 297

Most nodes use ODBC to connect with the DB - exceptions are JCN (can optionally use JDBC) and DataRetrieve node (JDBC).

Any connection pooling done by MB is not available for administration as is with in the case of most Application Servers (so even if it does do any poling you cannot change it or view it).

I would presume that each thread would have one connection with one database. I can say for sure that compute nodes do not start any thread of their own.

RocknRambo

Posted: Mon Nov 10, 2008 6:40 am Post subject:

Partisan

Joined: 24 Sep 2003
Posts: 355

Multiple message flows with compute or db nodes. does it mean each message flow creates a db thread or the execution grp creates the thread?

As a best practice, how is the DNS name (alias on odbc.ini) created? in the scenario of multiple message flows trying access same the application database for different tables or so.

PeterPotkay

Posted: Mon Nov 10, 2008 7:17 am Post subject:

Poobah

Joined: 15 May 2001
Posts: 7722

User database connections
_________________
Peter Potkay
Keep Calm and MQ On

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » DB connectivity

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