| Author |
Message
|
| mqmaniac |
 Posted: Tue Jan 17, 2006 4:45 pm Post subject: Can you change Database connectivity Automatically in ESQL |
 |
|
Master
Joined: 27 Dec 2005
Posts: 201
|
I am trying to move a WMQI 2.1 Message Flow to different environments.
Is it possible in Esql Code to detect the name of the Broker on which the Flow has been deployed.I want my Flow to detect the broker name and connect to the appropriate Database automatically.
I just want to know if it is possible with MQMD properties? |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Tue Jan 17, 2006 4:56 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
It's not possible with ESQL.
Unless you can take advantage of your QM name. And even that isn't necessarily going to be in your MQMD.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| JT |
| Posted: Tue Jan 17, 2006 5:15 pm Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
If your configuration is such that one server supports a single broker environment, then it's possible to:- Set a system environment variable, say BRKENV, on the broker server to identify the supported environment (dev, int, uat, prod).
- Within the message flow add the IA06 Get All Environment Variables plug-in to retrieve that value. The value is assigned to a special ENV tree.
- In your ESQL code interrogate the value Root.ENV.BRKENV to determine the environment and subsequent database.
|
|
| Back to top |
|
|
| mgk |
| Posted: Wed Jan 18, 2006 2:58 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
Just in case you are planning to move, this is possible from ESQL in Message Broker V6.
Regards,
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| Back to top |
|
|
| mqmaniac |
| Posted: Wed Jan 18, 2006 3:52 pm Post subject: |
|
|
Master
Joined: 27 Dec 2005
Posts: 201
|
Thanks for your replies.When i tried to download the plugin it says tht it can be used only for V5.0 and above.
I would be great help,if you give me the reply in more detail.
I am looking for Strong Confirmation whether its possible or not as i plan to change the flow design if its not.
Thanks
| JT wrote: |
If your configuration is such that one server supports a single broker environment, then it's possible to:- Set a system environment variable, say BRKENV, on the broker server to identify the supported environment (dev, int, uat, prod).
- Within the message flow add the IA06 Get All Environment Variables plug-in to retrieve that value. The value is assigned to a special ENV tree.
- In your ESQL code interrogate the value Root.ENV.BRKENV to determine the environment and subsequent database.
|
|
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Jan 18, 2006 3:54 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
It's absolutely not possible in v2.1 or v5 without a plug-in.
If you ask the author of the Cache plugin, they may have a copy of the v2.1 compatible plug-in still around and can provide it to you.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| mqmaniac |
| Posted: Wed Jan 18, 2006 4:17 pm Post subject: |
|
|
Master
Joined: 27 Dec 2005
Posts: 201
|
Can you please give me somemore details regarding the plug-in,as where to find it or buy it and any documents on how to use it.
Thanks a lot!
| jefflowrey wrote: |
It's absolutely not possible in v2.1 or v5 without a plug-in.
If you ask the author of the Cache plugin, they may have a copy of the v2.1 compatible plug-in still around and can provide it to you. |
|
|
| Back to top |
|
|
| JT |
| Posted: Wed Jan 18, 2006 4:40 pm Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| Click on the text ' IA06 Get All Environment Variables plug-in' in my previous post. |
|
| Back to top |
|
|
| EddieA |
| Posted: Wed Jan 18, 2006 6:58 pm Post subject: |
|
|
Jedi
Joined: 28 Jun 2001
Posts: 2453
Location: Los Angeles
|
| Quote: |
| Click on the text ' IA06 Get All Environment Variables plug-in' in my previous post. |
And when you look at the contained manual, it states:
| Quote: |
| This SupportPac provides a plug-in node to be used with the IBM WBI Message Broker V5 and above |
mqmaniac, who has already downloaded this and found the same quote, is looking for a V2.1 copy.
Cheers,
_________________
Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0 |
|
| Back to top |
|
|
|
|
