MQSeries.net :: View topic

WBIBB · Posted: Fri Sep 26, 2003 7:36 am Post subject: XA FAILURE

WMQI2.1/CSD3/DB27.2/AIX5.1/WMQ5.3
I am testing based on input message for different scenarios. If I uncheck transaction coordination on message flow it works fine but when XA is included I get the below error and message hits failure queue. I would like to have more insights from anyone out there who have configured successfully in similar environment. I am guessing about DB driver.

WMQIv210[31698]: (RCUA01.default)[2320]BIP2322E: Database error: SQL State 'HY501'; Native Error Code '-1001'; Error Text '[IBM][CLI Driver] SQL1001N "&FPYYRX&" is not a valid database name. SQLSTATE=2E000: RCUA01.9c0dfa6c-f600-0000-0080-d7c6584441e9: /build/S210_P/src/DataFlowEngine/ImbOdbc.cpp: 247: ImbOdbcHandle::checkRcInner

The following configuration was done

QMGR
The sample file xaswit.mak provided by WebSphere MQ was used to create DB2 switch load file along with associated C source files in the following directory (/usr/mqm/samp/xatm).
Edited the xaswit.mak to uncomment lines appropriate to version of Database used and executed the makefile using the command. make â€“f xaswit.mak db2swit and generated switch file is placed in current directory.

Qm.ini file
XAResourceManager:
Name=DB2 test
SwitchFile=/usr/mqm/samp/xatm/db2swit
XAOpenString=DB=test,UID=mqm,PWD=xxx,TPM=MQ
ThreadOfControl=PROCESS

.odbc.ini file
[RCUA01B]
[ODBC Data Sources]
RCUA01B =IBM DB2 ODBC Driver

Driver=/home/db2caed/sqllib/lib/db2.o.db2caef
Description= RCUA01B DB2 ODBC Database
Database= RCUA01B

Message flow
Designed & configured a message flow for XA globally coordinated

InputNode >> Compute node >> Filter >> True >> Output (Success)
False >> Throw (Failure)
Fail terminal of InputNode is connected to OutputNode

ESQL
Compute:
INSERT INTO Database.test_table(Column1,Column2) VALUES('300','400');

Filter : If Root.XML.Value = '1' then
return TRUE;
end if;

If Root.XML.Value = '2' then
return FALSE;
end if;