| Author |
Message
|
| sk_atul |
 Posted: Thu Feb 01, 2007 11:46 pm Post subject: Problems in changing DB thru mqsisetdbparms |
 |
|
Newbie
Joined: 01 Feb 2007
Posts: 7
|
There's a problem in my broker for which I need your assistance.
I was connected to one database thru the broker, but needed to change it to point to another dsn.The dsn is working ok but broker is down.
I had set the db parms to the other dsn using mqsisetdbparms its giving errors as below.
Description:
( WS_Broker ) The broker was unable to access its database.
There was no running database available.
Start the database, the broker will recover itself after a small delay.
Description:
( WS_Broker ) The broker made an unsuccessful attempt to access its database 'webshop' with userid 'db2admin'.
The broker's database could not be accessed using the userid and password supplied.
Ensure that the database is running and that the userid and password are correct.
Why is it connecting to 'webshop' using 'db2admin' ... when the userid it has to use is different. db2admin was the userid used for the previous dsn name.
I have deleted the previous dsn and also the setting by using the mqsisetdbprams with -d option.
This is the command i had issued:
mqsisetdbparms WS_Broker -n WEBSHOP -u webshop -p |
|
| Back to top |
|
 |
| gregop |
| Posted: Fri Feb 02, 2007 12:14 am Post subject: |
|
|
Voyager
Joined: 24 Nov 2006
Posts: 81
|
mqsisetdbparms is for changing userid/password on user databases accessed in message flow compute node, database nodes..
IT DOES NOT APPLY TO THE BROKER DATABASE.
The Broker db user (and password) and datasource is defined at broker creation on the mqsicreatebroker command. I think you can only change the password after broker creation by the mqsichangebroker command.
Re-create the DSN used when the broker was created, then the broker should be able to access its db again. |
|
| Back to top |
|
|
| sk_atul |
| Posted: Fri Feb 02, 2007 12:23 am Post subject: |
|
|
Newbie
Joined: 01 Feb 2007
Posts: 7
|
| Yes its a application db only, to be used for the db code in compute nodes |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Fri Feb 02, 2007 12:25 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi sk_atul,
| sk_atul wrote: |
| Yes its a application db only, to be used for the db code in compute nodes |
So you changed the application database...are u using the old DSN name for this new db ? If not, did you change it in the nodes ?
Regards. |
|
| Back to top |
|
|
| sk_atul |
| Posted: Fri Feb 02, 2007 12:28 am Post subject: |
|
|
Newbie
Joined: 01 Feb 2007
Posts: 7
|
| yes I changed the nodes and the catalog entries after deleting the old ones.Also removed the old dsn values. |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Fri Feb 02, 2007 12:30 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi sk_atul,
| sk_atul wrote: |
| yes I changed the nodes and the catalog entries after deleting the old ones.Also removed the old dsn values. |
The problem seems to be that something seems to be referencing the old DSN name, and since you deleted it, it is creating a problem...Open the flow in text mode and search for your old DSN name...
Regards. |
|
| Back to top |
|
|
| sk_atul |
| Posted: Fri Feb 02, 2007 12:45 am Post subject: |
|
|
Newbie
Joined: 01 Feb 2007
Posts: 7
|
There's no dsn value in any of the flows.
And the errors i sent are coming as soon as i give mqsistart. |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Fri Feb 02, 2007 1:06 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi sk_atul,
| sk_atul wrote: |
There's no dsn value in any of the flows.
And the errors i sent are coming as soon as i give mqsistart. |
You are getting the errors while starting the broker ? Then that means that you have changed the wrong DSN, instead of the application DSN you must have altered the Broker db DSN.
Regards. |
|
| Back to top |
|
|
| sarat |
| Posted: Fri Feb 02, 2007 1:41 am Post subject: |
|
|
Centurion
Joined: 29 Jun 2005
Posts: 136
Location: India
|
seems he's using same DSN and database for both broker and the flows.
He has not created another dsn till now...i'm thinking so!!!
and he has deleted the dsn of broker
_________________
With Regards,
Sarat. |
|
| Back to top |
|
|
| sk_atul |
| Posted: Fri Feb 02, 2007 1:46 am Post subject: |
|
|
Newbie
Joined: 01 Feb 2007
Posts: 7
|
I am using 3 diff DSNs
1st for broker which is running
2nd for old database which is now removed
3rd for the databse which i have to connect to. |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Fri Feb 02, 2007 2:17 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi sk_atul,
| sk_atul wrote: |
I am using 3 diff DSNs
1st for broker which is running
2nd for old database which is now removed
3rd for the databse which i have to connect to. |
You are not being clear and that is making us run around the issue....Just paste the entire exception list...
Regards. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Fri Feb 02, 2007 2:58 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
I am thinking that the DSN name is "WEBSHOP", and the mqsisetdbparms has been issues for the name "WEBSHOP", but the name in the flow is "webshop".
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| sk_atul |
| Posted: Fri Feb 09, 2007 5:15 am Post subject: The Real Problem is ... |
|
|
Newbie
Joined: 01 Feb 2007
Posts: 7
|
I had a DSN name X pointing to a database A which was setup to be used by the compute node. Now the requirement is that I have to use the database B for the compute node operations.So, I have created the DSN Y to database B.
So, now I want to setup that new DSN name Y so that the compute node works with the new database.I have set the mqsisetdbparms to the new value of Y.But after atarting the broker the error message comes where it says that "cannot connect to the database using the username for X" whereas I have done the text search and nowhere I found the reference to DSN X  . |
|
| Back to top |
|
|
| gregop |
| Posted: Fri Feb 09, 2007 5:53 am Post subject: |
|
|
Voyager
Joined: 24 Nov 2006
Posts: 81
|
So you've amended your compute nodes to point to DSN Y or reconfigured your bar file to point to DSN Y ?
And redeployed ? |
|
| Back to top |
|
|
| sk_atul |
| Posted: Fri Feb 09, 2007 6:04 am Post subject: yes |
|
|
Newbie
Joined: 01 Feb 2007
Posts: 7
|
yes done all that.
Still will try again monday as tomm's weekend. |
|
| Back to top |
|
|
|
|
