| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Accessing multiple schemas from a single DB2 instance |
« View previous topic :: View next topic » |
| Author |
Message
|
| ponshy |
 Posted: Sun Jun 23, 2002 10:18 am Post subject: Accessing multiple schemas from a single DB2 instance |
 |
|
Newbie
Joined: 23 Jun 2002
Posts: 5
|
Hi,
In our shop we have development, test & QA environments hosting same DB2 instance but one schema for dev, test & QA.
In a Compute (dev), I have to refer a table :
FROM Datasource.schemaDev.TABLE_A
in Test, FROM Datasource.schemaTest.TABLE_A
in QA, FROM Datasource.schemaQA.TABLE_A
I know we can promote Datasource property and set it .. how about schema. I prefer not to change ESQL in each environment for that mater even the promoted Datasource property.
Is there a way to get the Datasource & schema names from a file and use them in ESQL to avoid coding error when msgflows migrated across different paths ?
Any sugesstion/sample code please ...
Thanks. |
|
| Back to top |
|
 |
| kirani |
| Posted: Sun Jun 23, 2002 10:52 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Ponshy,
| ponsha wrote: |
| Is there a way to get the Datasource & schema names from a file and use them in ESQL to avoid coding error when msgflows migrated across different paths ? |
There is no such facility provided in WMQI to read Data source & schema names from file. However, you can write a plug-in node to implement this.
Do you have same broker shared between Dev, Test and QA? If not, you can use different schema owners user-id/pwd to connect to different databases in your broker. Your ODBC connection in Dev, Test and QA will point to different db schemas. By doing this, I think you can write unique ESQL which will work in Dev, Test and QA without any change.
Hope this helps.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| bnewman |
| Posted: Wed Aug 21, 2002 7:38 am Post subject: Specifiying datasource/user/password for db connection |
|
|
Newbie
Joined: 21 Aug 2002
Posts: 1
|
Can you provide examples of how you can specify a different odbc datasource, userid, and password to connect to a different database on the AIX platform. We have installed MQSI 2.1 and created all the databases under one userid. However, when we connect to various external databases, we need to use a different userid, and can't find where to change this. We tried the odbc.ini file, but it didn't pick up the userid and password.
thanks. |
|
| 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
|
|
|
|
