We are developing an AIX and Linux Host Application that will interact with IBM DB2 installed on separate AIX Box via unixODBC Driver Manager v2.3.2. The application is planned to work in XA with Transaction Manager been IBM MQ v7.x.
We tried creating the same application using IBM 'Embedded SQL' instead of 'unixODBC Driver Manager'. XA works very well but it doesn't work when used with the ODBC Driver. MQ been Transaction Manager, we have added 'IBM DB2' detail as a Resource Manager.
- I need to know would using unixODBC Driver Manager, result in adding Resource Manager as ODBC Driver and not IBM DB2?
- DB2CLI does talk of XA API support but there is no where I found creation of swit(Switch) file for Transaction Manager. Is my understanding correct?
Thanks in advance.