MQSeries.net :: View topic

shalabh1976 · Posted: Mon May 12, 2003 10:36 am Post subject: Promote Property Versus ODBC

In my current environment we have 3 subsystems viz., DEV, SIT and UAT
Each of these has a different Data Source name but the same Schema and Table name.

To enable the current code to run in all three environments one must go and manually change the DataSource name in each node where it is used.
In my case it is in 11 places.

There are two possible solutions to this :
1. Use the Promote property and promote the DataSource name to the top level message flows. Since there are 5 major flows the Data Source name would have to be modified 5 times.
Also if any of the connected subflows is checked out , modified and checked back in, all the promote links must be checked for proper working.

2. Modify the ODBC file such that we can have an ALIAS name for the different datasources and modify this file to point to the correct datasource for each environment. The code need not be changed.
For the OS390 this would be the DSNAOINI file and possibly the DDF.

I wanted to know which approach to take since I do not have OS390 expertise, so I do not know how difficult the second approach might be.

Also if there are other alternate solutions, please advise.