| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Find Runtime Database Connection Details |
« View previous topic :: View next topic » |
| Author |
Message
|
| EricCox |
 Posted: Thu Jun 21, 2012 11:08 am Post subject: Find Runtime Database Connection Details |
 |
|
Master
Joined: 08 Apr 2011
Posts: 292
|
How do we determine which database connections are being used at runtime in a message flow and compute node.
We are using an ODBC System DNS Configured with the Data Direct 5.3 Oracle Driver using an Oracle 10g client with TNSNAMES configured for load balancing on a RAC with two nodes.
How do I determine which node is being picked from TNSNAMES or will it always be the first one?
I'd really like to know what it is doing with the connection at runtime. Does Broker use connection pools?
If Node one goes away in a failure how does Message Broker behave, recover, not recover...etc.
We are on Broker 6.0.0.9.
Here is the TNSNAMES entry.
WMBLOGDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1_vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = node2_vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = svc_logging)
)
)
Thanks,
Eric |
|
| Back to top |
|
 |
| lancelotlinc |
| Posted: Thu Jun 21, 2012 11:13 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
I'm sure you know by now, v6.0.x.x is no longer supported.
There is no database connection pooling per se in WMB. If you have three nodes in a flow, and each node calls a database, then you have three active connections to a database each time the flow is invoked.
If you have three active connections to a database per flow, and you have nine additional instances of that flow, then there will be thirty active connections to the database if all ten instances are running.
Your DBA can help you see how many active connections are being used from your Message Broker instance.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Thu Jun 21, 2012 11:59 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| lancelotlinc wrote: |
I'm sure you know by now, v6.0.x.x is no longer supported.
There is no database connection pooling per se in WMB. If you have three nodes in a flow, and each node calls a database, then you have three active connections to a database each time the flow is invoked.
If you have three active connections to a database per flow, and you have nine additional instances of that flow, then there will be thirty active connections to the database if all ten instances are running.
Your DBA can help you see how many active connections are being used from your Message Broker instance. |
I believe you're missing the point. I thought the OP was talking about the oracle RAC feature and connections. Unless you try it out, you won't know... 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| EricCox |
| Posted: Thu Jun 21, 2012 12:07 pm Post subject: We have tried it out. |
|
|
Master
Joined: 08 Apr 2011
Posts: 292
|
We have tried it and don't like the way it behaves.
We are wondering what the expected behavior is given the Drivers and Oracle Client configuration.
I don't think Broker can identify a stale connection to a failed node and build a new connection to the online node without either killing the EG and restarting or rebooting the server.
It behaves as if it holds the connection to the RAC node that is down and doesn't do anything in response. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Thu Jun 21, 2012 12:19 pm Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
|
| 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
|
|
|
|
