| Author |
Message
|
| nickkirk |
 Posted: Tue Nov 11, 2008 6:02 am Post subject: Modifying the broker database datasource |
 |
|
Apprentice
Joined: 26 Sep 2008
Posts: 48
|
I have modified the following file :
/var/mqsi/registry/TestBRK/CurrentVersion/DataSourceName
Now I can't connect to the broker database.
The ODBC32.ini file and the tnsnames file have been updated correctly.
1) Are we allowed to modify the datasource name for the broker database?
2) If yes to 1), how to initialize this ?
3) The datasource names for the data database is in the following dir: /var/mqsi/registry/MQT001BRK/CurrentVersion/DSN/
4) The datasources described in 3) are created with mqsisetdbparms
The error I am getting is :
'[DataDirect][ODBC lib] Data source name not found and no default driver specified' |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Tue Nov 11, 2008 8:48 am Post subject: Re: Modifying the broker database datasource |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| nickkirk wrote: |
I have modified the following file :
/var/mqsi/registry/TestBRK/CurrentVersion/DataSourceName
Now I can't connect to the broker database.
The ODBC32.ini file and the tnsnames file have been updated correctly.
1) Are we allowed to modify the datasource name for the broker database?
2) If yes to 1), how to initialize this ?
3) The datasource names for the data database is in the following dir: /var/mqsi/registry/MQT001BRK/CurrentVersion/DSN/
4) The datasources described in 3) are created with mqsisetdbparms
The error I am getting is :
'[DataDirect][ODBC lib] Data source name not found and no default driver specified' |
Did you alsoe set userid and password to have access to the moved broker DB.
Anyways I would just delete and recreate the broker...
Changing the broker's DB is not something that should be taken up lightly...
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| nickkirk |
| Posted: Tue Nov 11, 2008 9:05 am Post subject: |
|
|
Apprentice
Joined: 26 Sep 2008
Posts: 48
|
I said nothing about changing or moving the actual broker database.
I changed the datasource name !
Therefore, there is no reason to change the userid or password.
Also, I am unable to delete the broker with mqsideletebroker because it needs to be able to connect to the broker database first before the deletion.
| Quote: |
| Changing the broker's DB is not something that should be taken up lightly... |
No kidding !
Please, does anyone know the answer to my original question ? |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Tue Nov 11, 2008 9:09 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Just recreate a DB with the same name as the one you used when the broker was running. Then delete the broker. Then recreate the broker. 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| mqjeff |
| Posted: Tue Nov 11, 2008 10:29 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
You can't change the DSN name... why would you need to change the DSN name?
You can change the database behind the DSN name.
Or you can delete and recreate the broker using a new DSN name that points to the same database (or a different one), if you want to.
But why would you need to change the DSN name? Did you fail to conform to corporate standards when you created it? |
|
| Back to top |
|
|
| nickkirk |
| Posted: Wed Nov 12, 2008 4:13 am Post subject: |
|
|
Apprentice
Joined: 26 Sep 2008
Posts: 48
|
| Quote: |
| But why would you need to change the DSN name? Did you fail to conform to corporate standards when you created it? |
Exactly mqjeff. This is the reason !
We have had to create a new broker. I hassle really because the topics, subscriptions, data source names (data db) all need to be created again.
It is bizarre that the data source name can not be changed.
Data Sources are only aliases that are used to refer to the actual database name.
Thanks ! |
|
| Back to top |
|
|
|
|
