| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
| difficulty with propagate MessageSource clause |
« View previous topic :: View next topic » |
| Author |
Message
|
| pcelari |
 Posted: Mon Apr 16, 2007 5:48 pm Post subject: |
 |
|
Chevalier
Joined: 31 Mar 2006
Posts: 411
Location: New York
|
| jefflowrey wrote: |
Yes, only the last one.
|
But if only the last one becomes valid, then how can the broker access multiple databases without setting the userid and passwd somewhere?
Put it more clearly, with the following command:
mqsisetdbparms MYBKR -n MYDB1 -u userid -p userpwd
mqsisetdbparms MYBKR -n MYDB2 -u userid -p userpwd
mqsisetdbparms MYBKR -n MYDB3 -u userid -p userpwd
I set the the broker to remember the userid and password for accessing MYDB3, the last one override the first two.
However, to call a SP in MYDB1 in a compute node, I use the following syntax as suggested by MGK:
CALL mySP3( myParams ) IN DATABASE MYDB1;
However, since only the last mqsisetdbparms command is current at this time, overriding the first two commands, the broker doesn't know the userid and passwd for MYDB1. i.e. the access will fail.
Could you or MGK clarify this? really appreciated.
_________________
pcelari
-----------------------------------------
- a master of always being a newbie |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Mon Apr 16, 2007 6:49 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
A DSN is not the same thing as a database, and a database is not the same thing as a DSN.
In addition, broker is neither limited to accessing a single database, nor a single DSN.
But you can only associate one User and Password with one DSN.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| pcelari |
| Posted: Tue Apr 17, 2007 10:38 am Post subject: |
|
|
Chevalier
Joined: 31 Mar 2006
Posts: 411
Location: New York
|
| jefflowrey wrote: |
Yes, only the last one.
|
No, that's not true. I run the command:
mqsisetdbparms MYBKR -n MYDB1 -u userid -p userpwd
mqsisetdbparms MYBKR -n MYDB2 -u userid -p userpwd
mqsisetdbparms MYBKR -n MYDB3 -u userid -p userpwd
After this, the msgflow successfully accessed all three databases.
However, thank you all for the inspirations that have brought me such far!
Also, I have found out, on zLinux there isn't such a thing as DSN, the broker access the database directly via local CLI catalogs that point to remote databases.
_________________
pcelari
-----------------------------------------
- a master of always being a newbie |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Apr 17, 2007 11:04 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Sorry, I was reading the commands wrong. 
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
