| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Can we register two Schema in same data base with one DSN |
« View previous topic :: View next topic » |
| Author |
Message
|
| sankritya |
 Posted: Wed Jul 21, 2010 6:00 am Post subject: Can we register two Schema in same data base with one DSN |
 |
|
Centurion
Joined: 14 Feb 2008
Posts: 100
|
Hi All,
Can we register two Schema in same data base with one DSN in Message Broker. I am trying to run the following commands
mqsisetdbparms BROKER -n DSN -u userSchema1 -p password1
mqsisetdbparms BROKER -n DSN -u userSchema2 -p password2
Both the Schema are available in the Same Oracle Data Base. But when I register the userSchema2 then userSchema1 is not accessible from the Broker and it is returning error if I try to access tables created in userSchema1.
DatabaseException: Child SQL exception, 42S02, 942, [IBM][ODBC Oracle Wire Protocol driver][Oracle]ORA-00942: table or view does not exist.
Do I need to create different DSN for different Schema?
Broker Version - 6.1.0.4
AIX Box |
|
| Back to top |
|
 |
| Gaya3 |
| Posted: Wed Jul 21, 2010 6:52 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
how about different DSN's
where one of the DSN which is referering to the same server or schema.
i mean a link internally to it.
probably this may help you to resolve this issue.
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| sankritya |
| Posted: Wed Jul 21, 2010 7:09 am Post subject: |
|
|
Centurion
Joined: 14 Feb 2008
Posts: 100
|
| If different DSN are used for the different schema then it is not giving any error. But Do we need to create different DSN for Different Schema? As the database contains around 20 different schema containing different tables which may be accessed by the flows. So we will need to create 20 DSN's. Also it will be difficult to access the different Tables from the same compute nodes if they are using different DSN's are under different Scema. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Jul 21, 2010 7:13 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
You can only associate a single user credential with a single DSN.
mqsisetdbparms will create or overwrite the existing credential if you issue it twice for the same DSN.
This does not mean in any sense that you are required to create a separate DSN for each schema on the Database.
It means that you need to create a separate DSN for each separate user credential that you need to present to the database when you connect.
Your site policy may require that you can not grant authorities to more than one schema from the same user credential - in which case you need to specify one DSN for each schema.
If your site policy ALLOWs you to grant permissions to other schemas for a specific user, you can create a single userid for the Broker itself and create a single DSN for that, and then include the name of the needed schema in all of your database calls. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
