I am trying to use DTS stage by configuring qm.ini file
In queue manager config file I have one DB2 database has already added as resource. Now if I want to add a separate DB2 database in different server(which is already cataloged in the DS server ) then do I need to create a new switch load library for that alone.
If not then do I need to stop the queue manager first and then add the entry in the qm.ini file and again start the queue manager.
One more thing in this regard can we use any database (other than Oracle,DB2,SQl server)
WebSphere MQ w/ DTS - Queue Manager config file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 152
- Joined: Mon Mar 07, 2011 6:16 am
I changed your title a bit to make it more apparent that this is really a WebSphere MQ question (at least I think it is!).
You might want to try posting on an MQ technical forum to increase your odds of getting a response. There are only a few folks here that have worked with MQ, and very few that might have done a distributed transaction with MQ.
You might want to try posting on an MQ technical forum to increase your odds of getting a response. There are only a few folks here that have worked with MQ, and very few that might have done a distributed transaction with MQ.
-
- Participant
- Posts: 152
- Joined: Mon Mar 07, 2011 6:16 am
It's a fair question, and I've done a fair amount of work with DTS, but alas, always with one critical target DB. Not sure about that MQ particular..... let us know if you find out anything on the MQ side of things!
Ernie
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
-
- Participant
- Posts: 152
- Joined: Mon Mar 07, 2011 6:16 am
Thanks to all for the support.
The qm.ini file finally has been changed and entered a new database details and restarted the mq server and it worked perfectly.
In my config file I have more than one databases situated in the different server.The DTS stage works perfectly for any one of the database.
Now I'm marking it as resolved
The qm.ini file finally has been changed and entered a new database details and restarted the mq server and it worked perfectly.
In my config file I have more than one databases situated in the different server.The DTS stage works perfectly for any one of the database.
Now I'm marking it as resolved
Soumya