| Author |
Message
|
| Luca81 |
 Posted: Thu Mar 15, 2007 12:36 am Post subject: mqsisetdbparms in a cluster enviroment |
 |
|
Acolyte
Joined: 01 Mar 2007
Posts: 62
|
Hi to all
Sorry for my english.
I have a production cluster enviroment. I need to set a Data Source with the command mqsisetdbparms.
I done this steps:
1) I stopped the broker service using the cluster administrator.
2) I used the command mqsisetdbparms to set the userd id and pwd of gthe Data Source. This is the command used
mqsisetdbparms SWBIMBP1 -n WBIMsgLog -u wbi_dbo -p xxxx
3) I started the broker service using the cluster administrator.
But it does not work  . WBI uses the user 'wbiadm' and not the user 'wbi_dbo' for the DataSource WBIMsgLog.
why?? I used this command in another enivorment (NOT CLUSTERED) without problems.
Pls help me.
Thx u all very much |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Thu Mar 15, 2007 3:29 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You need to run it on both machines.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| Luca81 |
| Posted: Thu Mar 15, 2007 4:42 am Post subject: |
|
|
Acolyte
Joined: 01 Mar 2007
Posts: 62
|
| jefflowrey wrote: |
| You need to run it on both machines. |
Cluster is Active/Passive.
Yes, I done it on ONE machine but i did NOT switch on the other machine...
I deployed the flow on the active node where I run the command... Not on the other one... So i think it should work.
If i need run it on both machines can u write to me all the steps?
Which services stop... how stops... ecc ecc?
thx u very much |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Mar 15, 2007 7:36 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
It's the same steps on both machines.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| Luca81 |
| Posted: Thu Mar 15, 2007 7:45 am Post subject: |
|
|
Acolyte
Joined: 01 Mar 2007
Posts: 62
|
| jefflowrey wrote: |
| It's the same steps on both machines. |
ok!
I stop the service using cluster admin? or with mqsistop command? |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Mar 15, 2007 9:22 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
It shouldn't be running on the passive machine.
This might fix your problem, but it is still required.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| Luca81 |
| Posted: Fri Mar 16, 2007 1:32 am Post subject: |
|
|
Acolyte
Joined: 01 Mar 2007
Posts: 62
|
| jefflowrey wrote: |
It shouldn't be running on the passive machine.
This might fix your problem, but it is still required. |
OK thx, for the passive machine is not a problem... the services are all stopped.
But for the active machine i need stop the services before running the 'mqsisetdbparms' command...
which services should i stop??? Only the broker? And the Configuration Manager? And DB2 Services??
How stop the service? with the cluster admin or with the mqsistop command?
After having run the 'mqsisetdbparms' command how should i start the services??
Thx a lot |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Fri Mar 16, 2007 3:51 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Just the broker.
Stop it, run the command, start it.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
|
|
