| Author |
Message
|
| kbtraj |
 Posted: Wed Jun 18, 2014 4:50 am Post subject: Message Broker - Database - DSN - Connectivity details |
 |
|
Novice
Joined: 28 Apr 2014
Posts: 10
|
Hi,
I am relatively new to WMB. The version we currently use is 6.0.0.8 and we are in the process to upgrade. I want to understand the working details of MB before I change anything in there. I know this is not a technical help but I am not finding specific answer points anywhere. Please redirect me if you find any doc/help page.
Here are my questions:
1. I know we should have a database setup for MB to run. Is it applicable to all versions till 8? Is it necessary that it has to be an IBM DB2 db?
2. How can I view/setup the above said db details?
3. Can I create my own tables in the above database?
4. I see there is an external Oracle DB setup for user table in our environment that is linked to MB. How do MB knows this database? Using DataSource name?
5. Where can I find the config files for these DataSources?
Thanks |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Wed Jun 18, 2014 4:54 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
The internal DB is no longer needed since WMB version 7.
The user DBs are either defined in configurable services (JDBC) or in the ODBC.ini pointed to by your environment variable (set up either for the user or while running mqsiprofile...
Have fun 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| kbtraj |
| Posted: Wed Jun 18, 2014 8:01 am Post subject: |
|
|
Novice
Joined: 28 Apr 2014
Posts: 10
|
Apart from the questions above, one more:
We have three DB environments (Dev, ACPT & Prod). if we specify the DSN name inside the message flow compute node properties, does it mean I can not use the same bar file in all three environments? Do I need to have three versions of message flows & bar files each pointing to different DBs.
Or, one thing I can think of is having some common name in the Compute node value and customizing the odbc.ini file. Is it how I supposed to change?
Please help! |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Jun 18, 2014 8:27 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| kbtraj wrote: |
| Is it how I supposed to change? |
No.
Look up "promoted properties" in the product documentation.
This (if memory serves me) was the same in WMBv6.0 so it's not a change this (long overdue) migration is pushing on you.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| kbtraj |
| Posted: Thu Jun 19, 2014 11:12 pm Post subject: |
|
|
Novice
Joined: 28 Apr 2014
Posts: 10
|
Hi Vitor,
Thanks. That helped me to read on a relevant topic.
I know the question is not up to your expectation
I am just starting here.. a lot to learn (how to ask right questions!)..  |
|
| Back to top |
|
|
|
|
