| Author |
Message
|
| vijayakumar |
 Posted: Wed Sep 29, 2010 3:31 am Post subject: Broker datasource name associated |
 |
|
Centurion
Joined: 01 Aug 2010
Posts: 101
|
I am using a broker BKSD1 which is already created .
I want to know what are all the datasource name associated with this broker .
can anyone help me how to check this ? |
|
| Back to top |
|
 |
| ajit1981 |
| Posted: Wed Sep 29, 2010 4:02 am Post subject: |
|
|
Apprentice
Joined: 09 Apr 2010
Posts: 41
Location: Bangalore, Inida
|
I didnt remember the excat path , you can found all the database entry in the registry entry in windows, in windows go to regedit, there search for your broker name, inside that folder there will be DSN/Database folder, there you can see all the entry of whatever database is associated with your broker, there you can found the User id of that database also and PWD will be in encrypt form.
In unix path will be like this, /var/mqsi/common/<broker name>/DSN.
I didnt remember the path, you can try to search in your system or server the excat path. |
|
| Back to top |
|
|
| vijayakumar |
| Posted: Wed Sep 29, 2010 4:37 am Post subject: |
|
|
Centurion
Joined: 01 Aug 2010
Posts: 101
|
Thanks for ur reply .
i am working in the unix environment . I did nt find the details in the path mentioned for unix .
Is there any mqsi commands or any alternate ways to check this ? |
|
| Back to top |
|
|
| ajit1981 |
| Posted: Wed Sep 29, 2010 4:42 am Post subject: |
|
|
Apprentice
Joined: 09 Apr 2010
Posts: 41
Location: Bangalore, Inida
|
| As far as I konw, there is no command to check this. Once I came up with same kind of things to check what ever database is associated with broker, I found all the DSN name in folder, try to search in /var or /opt or /opt2 folder, it must be there somewhere. I dont have access to unix server nowadays. otherwise i told you the excat path. |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Wed Sep 29, 2010 4:45 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
If you are running a later CSD of 6.1 or V7 then the mqsireportbroker command will help.
If this command is not available then and you are running on Unix then something like
| Code: |
cd /var/mqsi/registry/BKSD1/CurrentVersion
|
Will get you to where all the data is stored.One of the files in this directory will tell you the DSN used to create the broker.
Naturally, if you are running on V7 then this is not needed.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.
Last edited by smdavies99 on Wed Sep 29, 2010 4:46 am; edited 1 time in total |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Sep 29, 2010 4:46 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
ajit1981 is not correct.
That location only stores entries that have been created using mqsisetdbparms. It has no relationship to whether or not there exists a flow that is configured to have a DSN property.
In general, looking at the actual ODBC configuration (the odbc.ini file on unix or the ODBC control panel on Windows) will tell you what ODBC DSNs are available for use within broker. It's not unreasonable to assume that all of them are in use.
And if a flow tries to use a DSN that is *not* configured in ODBC, then it will get lots of exceptions that will make lots of noise in the system log.
If you really need to find out if there are, for example, DSNs defined in ODBC but *not* in use by a flow, you can use the CMP API to interrogate the broker about deployed flows and their DSN properties. |
|
| Back to top |
|
|
| vijayakumar |
| Posted: Wed Sep 29, 2010 7:06 am Post subject: |
|
|
Centurion
Joined: 01 Aug 2010
Posts: 101
|
Thanks jeff and all for ur help.
in var/mqsi/odbc Brokername.odbc.ini i find the dsn details associated with the broker . |
|
| Back to top |
|
|
|
|
