Originally posted by: SystemAdmin

We have a map that we are attempting to use the -GTX to control our Oracle threads.

We have altered our INI file to ShareConnectionThreads=1 (Enables sharing for GTX only. Only connections with GTX will get combined to the same thread.)

We have then gone into our map(s) to add the -GTX command on the database cards/rules where we want the GTX to be controlling the tread. We are now receiving a "-600:OpenConnection: couldn't open the connection" failure at the point of the -GTX adapter command - happens whether we are running on Design Studio or Launcher v8.2.0.5.

Any help would be appreciative. I must be missing something important.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

Okay, we are thinking that we are missing the IBM WebSphere MQ (MQS TM). Documentation then states, "The MSMQ, Oracle, and Oracle AQ adapters can only participate in global transactions initiated by the MS SQL Server or IBM WebSphere MQ adapters, respectively."

In our situation we have a "driver" pulling from MQ determining the which of our 4 message types to translate. This brings my next question. 3 of our 4 messages need the GTX - the 4th message type is totally independent and we will be adding on more "independent" message types. Does this mean our independent message types will be held up by our -GTX messages? If so, we would need to get creative with our MQ message header so we can funnel to different MQ watch settings.
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender