WMQ as Distributed Transaction Manager for ODBC and JDBC together

[Yash Ganthe]

Hi,

We intend to use a single Queue Manager as Distributed Txn Manager for a C++ program and a Java program. The Database used by both apps is the same. The qm.ini looks like:
XAResourceManager:
Name=MYDBQA52
SwitchFile=jdbcdb2
XAOpenString=MYDBQA5,appsuqa,dbserver,toc=t
ThreadOfControl=PROCESS
XAResourceManager:
Name=MYDBQA51
SwitchFile=db2swit
XAOpenString=MYDBQA5,appsuqa,dbserver,toc=t
ThreadOfControl=THREAD

We are using different switch files for the same database and hence the same Resource Manager. The C++ application crashes when it tries to perform a MQBEGIN. The error says: External XA Transaction Participant not available [MQRC_PARTICIPANT_NOT_AVAILABLE].

When we replace the jdbc switch file with the db2swit switch file, the C++ app runs fine. But the Java app obviously fails as the switch file is for JDBC.

Is there any restriction on using a JDBC switch file and an ODBC one in the same qm.ini?
Which stanza does QM use when doing an XA_Open if there are multiple stanzas?

Thanks,
Yash