| Author |
Message
|
| smeunier |
 Posted: Fri Sep 29, 2006 9:20 am Post subject: Loopback vs. EXTSHM=ON |
 |
|
Partisan
Joined: 19 Aug 2002
Posts: 305
Location: Green Mountains of Vermont
|
| Is there any argument amoung the community as to which is better for broker connections to the Db? I have used Loopback in the past and this works fine, but will environment variable EXTSHM=ON provide the same amount of connectivity? |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Fri Sep 29, 2006 9:21 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You'll run out of connections using shared memory, even with EXTSHM=ON.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| mvic |
| Posted: Fri Sep 29, 2006 3:25 pm Post subject: |
|
|
Jedi
Joined: 09 Mar 2004
Posts: 2080
|
| jefflowrey wrote: |
| You'll run out of connections using shared memory, even with EXTSHM=ON. |
Please explain Jeff. I'd expect any limitations that may exist to be no less when using client MQI connections.
Actually, smeunier, please would you be clearer about what limitation you suggest you might be hitting, and what is meant by the phrase "the same amount of connectivity"? And what is the relevance of EXTSHM=ON to this particular question? |
|
| Back to top |
|
|
| wschutz |
| Posted: Sat Sep 30, 2006 2:33 am Post subject: |
|
|
Jedi Knight
Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)
|
mvic, we're talking about database connections here, not MQ client connections.
I usually have used the "loopback" database connection in the past without any problem.
_________________
-wayne |
|
| Back to top |
|
|
| mvic |
| Posted: Sat Sep 30, 2006 11:11 am Post subject: |
|
|
Jedi
Joined: 09 Mar 2004
Posts: 2080
|
| wschutz wrote: |
| mvic, we're talking about database connections here, not MQ client connections. |
Oops 
I guess I was thinking too much of "WebSphere MQ Installation/Configuration Support".  |
|
| Back to top |
|
|
| smeunier |
| Posted: Mon Oct 02, 2006 5:34 am Post subject: |
|
|
Partisan
Joined: 19 Aug 2002
Posts: 305
Location: Green Mountains of Vermont
|
Jeff accurately answered the question in the first round. The EXTSHM variable, is set as part of the profile of the id that starts the Message Broker. This enables the use of Shared Memory by the Message Broker.
A problem can be encountered by the Message Broker when many Messages flows exists in a Execution Group, when trying to obtain the connection needed to reference message flow information from the brokers database.
In this case, a loopback needs to be implemented. My question was driven from the manual which indicates the problem may be resolvavble from both angles: EXTSHM and/or loopback. |
|
| Back to top |
|
|
|
|
