Question & Answer
Question
testconn20/40 for .net provider testing failed at step6 with following error on windows 8 C:\Program Files\IBM\IBM DATA SERVER DRIVER\bin>testconn20 -dtc "database=sampledsn;uid=username;pwd=password" ...... ----------------------- Step 6: Creating XA connection DB2TransactionScope: Failed to open connection to database! IBM.Data.DB2.DB2Exception: ERROR [58005] [IBM][DB2/NT64] SQL0998N Error occurred during transaction or heuristic processing. Reason Code = "16". Subcode = "2-FFFFFFFF8004D026". at IBM.Data.DB2.DB2ConnPool.Open(DB2Connection connection, String& szConnectionString, DB2ConnSettings& ppSettings, Object& ppConn) at IBM.Data.DB2.DB2Connection.Open() at TestConn.DB2TransactionScope.Open(String connstr) Looking for XADLL key for C:\Program Files\IBM\SQLLIB\bin\db2app.dll Incorrect registry entry for C:\Program Files\IBM\SQLLIB\bin\db2app.dll in SOFTWARE\Microsoft\MSDTC\XADLL is: C:\Program Files\IBM\SQLLIB\BIN\DB2APP64.DLL, should be C:\Program Files\IBM\SQLLIB\bin\db2app.dll Test failed. -----------------------
Cause
Windows 8 has special setup for XA enable
Answer
The solution is to make a simple change to the MSDTC settings in Windows 8.
a.Run dcomcnfg command
b.Expand the "Component Services" node, then the "My Computer" node, then the "Distributed Transaction Coordinator" node
c.Right-Click on the "Local DTC" node and select "Properties"
d.On the "Local DTC Properties", select the "Security" tab
e.Select Network DTC Access, Allow Inbound, Allow Outbound, No Authentication Required, and Enable XA Transactions
Then the testconn20/40 will succeed like follows:
--------------------
Step 6: Creating XA connection
DB2TransactionScope: Connection Closed.
Elapsed: 4.0412311
Test passed.
-------------------
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21963411