DSXchange

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)

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.

Thanks a lot Andy for your response.

You are right the title is most appropriate now.

Surely I will post it in MQ related forum.Just thought that as it is related to datastage job running consisting DTS that's why posted over here.

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

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