| Author |
Message
|
| ihatelovestories |
 Posted: Wed Dec 28, 2011 6:03 pm Post subject: DSN associated with Broker |
 |
|
Novice
Joined: 27 Dec 2011
Posts: 14
|
Hi Guys,
Is there any command to find DSN name associated with broker in aix environment?
I know where all the dsn available which are created using mqsisetdbparms
"/var/mqsi/registry/BRKR/CurrentVersion/DSN/"
under this this path I can see 4 different dsns created.. but not sure which is currently associated with my broker..
thanks. |
|
| Back to top |
|
 |
| ihatelovestories |
| Posted: Thu Dec 29, 2011 1:26 am Post subject: |
|
|
Novice
Joined: 27 Dec 2011
Posts: 14
|
here I want to generalize my query..
I have a dsn named DSN1 for db DB1 which I associated with broker BRKR1 ..
now I am creating another dsn named as DSN2 for DB2 and associating with BRKR1 ..
In flow I can use both DSN1 and DSN2 ..
but I want to use both like ..
in my compute node I like to use DBN1 as datasource proerpty .. inside my esql i like to connect to different database using DSN2 ..
but scenario not working for me ..
not able to connect to another dsn which is associated with different database ..
please help to find way to connect this.. |
|
| Back to top |
|
|
| marko.pitkanen |
| Posted: Thu Dec 29, 2011 2:08 am Post subject: |
|
|
Chevalier
Joined: 23 Jul 2008
Posts: 440
Location: Jamsa, Finland
|
Hi,
You should read again what the manuals says about SELECT and PASSTRHU clauses and how the compute node's Data Source property should be used and what are the restrictions between Data Sources that can be "dynamically" referenced.
--
marko |
|
| Back to top |
|
|
| ihatelovestories |
| Posted: Thu Dec 29, 2011 2:41 am Post subject: |
|
|
Novice
Joined: 27 Dec 2011
Posts: 14
|
| marko.pitkanen wrote: |
Hi,
You should read again what the manuals says about SELECT and PASSTRHU clauses and how the compute node's Data Source property should be used and what are the restrictions between Data Sources that can be "dynamically" referenced.
--
marko |
can you brief me what manual says.. |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Dec 29, 2011 7:03 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| ihatelovestories wrote: |
| can you brief me what manual says.. |
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| ihatelovestories |
| Posted: Thu Dec 29, 2011 5:42 pm Post subject: |
|
|
Novice
Joined: 27 Dec 2011
Posts: 14
|
| Vitor wrote: |
|
..  |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Thu Dec 29, 2011 10:38 pm Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| ihatelovestories wrote: |
| Vitor wrote: |
|
.. |
What Vitor is trying to tell you is that you should go read the documentation and THEN by all means come back here with further questions on the points you don't understand.
Those of us who regularly post replies here really appreciate those who take the trouble to read the docs and try a few things out before coming here and asking very generic questions.
If you were to say something like...
| Quote: |
I did this .... and this .... happened.
So I tried this ... and this .... happened.
I don't understand why. As I see it, the docs say that either should work.
|
When we see evidence of someone willing to help themselves, they will more likely get help.
_________________
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. |
|
| Back to top |
|
|
|
|
