| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| check if a bar file was deployed with the right DBproperties |
« View previous topic :: View next topic » |
| Author |
Message
|
| WBI_user |
 Posted: Mon Feb 25, 2008 7:47 am Post subject: check if a bar file was deployed with the right DBproperties |
 |
|
Partisan
Joined: 07 Aug 2001
Posts: 386
|
Is there an easy way to check if the bar file was deployed with the right Data source ? For example I have a bar file Prod.bar which contains a flow myprodflow.cmf. This bar file has to be deployed to two production system Prod1 and Prod2.
myprodflow message flow has to access DB which is ProdDB1 on Prod1 and ProdDB2 on Prod2.
So the bar file was configured with data source ProdDB1 before deployed to Prod1 and ProdDB2 before deployed to Prod2.
When I display the deployed flow under the execution group of Prod1 or Prod2, I cannot tell if the data source name. So I do not know if the data source name was correct until someone starts to use the flow and get a failure. It does point me back to the bar file. But going back to the bar file
can not tell unless it was checked right after the deploy. If it was checked some time later, another override or re-configure may have happened.
Did I miss anything ? Is there a way to find out before we start the flow in Production after the deploy ?
The data source name is just one, we have flows that uses UDPs and we like to have someway to verify them before we start the message flow. |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Mon Feb 25, 2008 8:08 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You can't query this from the deployed BAR.
You can use, for example, mqsiapplybaroverride to ensure that the bar file has the correct values.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| WBI_user |
| Posted: Mon Feb 25, 2008 9:37 am Post subject: |
|
|
Partisan
Joined: 07 Aug 2001
Posts: 386
|
Thanks jefflowrey, we just had a situation like this.
We had a DB problem and need to switch DB
A support person was called in 3 am in the morning to change the data source name of a few message flows. beause it was only a few, he decided just to re-configure the bar file and re-deploy. He mada a mistake and production took an impact when the stores open in the morning. We wish that there was way to query the deployed bar file to ensure that every configurable parameter is of the right value before he finished his call and go home. Not to find out when production starts in the morning. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Mon Feb 25, 2008 9:42 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
The only thing you can do, that I can think of, is create keywords that hold duplicate copies of these values.
From my point of view, the problem you had was not that the DB values were incorrect, bu that the process to change them was incorrect.
You should have a) been able to change the ODBC entry without changing the DSN, b) change the flow properties in a reliable, trackable, auditable manner so that you could look at the results of the change, rather than trying to query broker.
If nothing else, the operator should have kept the new BAR files so that you could query those.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| WBI_user |
| Posted: Mon Feb 25, 2008 10:04 am Post subject: |
|
|
Partisan
Joined: 07 Aug 2001
Posts: 386
|
| Thanks jefflowrey, I agree with you 100%. We do have the bar override and mqsideploy procedure. But soemtimes it is the shot cut that kills you. However, it is always nice to have a way to tell what exactly is running rather than just what is suppose to be running. |
|
| 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
|
|
|
|
