Db2 Error Occurred During Transaction Or Heuristic Processing
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up TransactionScope won't work with DB2 provider up vote 2 down vote favorite 1 I've been trying to use TransactionScope with a DB2 database (using DB2 .Net provider v 9.0.0.2 and c# 2.0) which SHOULD be supported according to IBM. I have tried all the advice i could find on the IBM forums (such as here) to no avail. I have enabled XA transactions on my XP Sp2 machine, tried also from a Win 2003 Server machine but i consistently get the infamous error: ERROR [58005] [IBM][DB2/NT] SQL0998N Error occurred during transaction or heuristic processing. Reason Code = "16". Subcode = "2-80004005". SQLSTATE=58005 The windows event log says: The XA Transaction Manager attempted to load the XA resource manager DLL. The call to LOADLIBRARY for the XA resource manager DLL failed: DLL=C:\APPS\IBM\DB2v95fp2\SQLLIB\BIN\DB2APP.DLL File=d:\comxp_sp2\com\com1x\dtc\dtc\xatm\src\xarmconn.cpp Line=2467. Also, granted the NETWORK SERVICE user full rights to the folder and dll. Here's the MSDTC startup message MS DTC started with the following settings: Security Configuration (OFF = 0 and ON = 1): Network Administration of Transactions = 0, Network Clients = 0, Inbound Distributed Transactions using Native MSDTC Protocol = 0, Outbound Distributed Transactions using Native MSDTC Protocol = 0, Transaction Internet Protocol (TIP) = 0, XA Transactions = 1 Any help would be much appreciated! Thanks, Florin db2 transactionscope drivers share|improve this question asked Sep 10 '09 at 8:00 user171282 add a comment| 2 Answers 2 active oldest votes up vote 4 down vote I managed to get the creaky old IBM DB2 v7 ODBC driver working in a TransactionScope. It required: XA transactions enabled in MSDTC properties A value entered under the registry key HKLM\SOFTWARE\Microsoft\MSDTC\XADLL with name 'DB2CLI.DLL' and
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Asked by: Problem with TransactionScope with Linked server to DB2 SQL Server > SQL Server Data Access Question 0 Sign in to vote Hi I have an windows application built on ADO.net for executing procedure present in SQl server 2008 DB. This procedure in turn executes http://stackoverflow.com/questions/1403946/transactionscope-wont-work-with-db2-provider query in DB2 via linked server. Everything works fine untill I use Transactionscope inside my dotnet code. I get below exception when I put the execute inside a transactionscope in dotnet code. The operation could not be performed because OLE DB provider "IBMDADB2.DB2COPY1" for linked server "
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2008 » SQL http://www.sqlservercentral.com/Forums/Topic1532361-1292-1.aspx Server Newbies » How to use a Cursor opened by a Stored... How to http://www.mqseries.net/phpBB2/viewtopic.php?t=40883 use a Cursor opened by a Stored Procedure on DB2 Rate Topic Display Mode Topic Options Author Message moz987moz987 Posted Saturday, January 18, 2014 4:45 AM Grasshopper Group: General Forum Members Last Login: Monday, March 7, 2016 5:34 AM Points: 21, Visits: 52 Hello everyone,i am currently stuck at the problem mentioned the db2 error title. I have a Stored Procedure on DB2 which opens a Cursor to deliver me data. I am able to call this Procedure with the following command:execute('call mySchema.myProcedure()') at DB2_Linked_ServerAfter committing on my SQL Server 2008 in the SQL Server Management Studio i get the data filled in the Results tab. But i don't have a clue how to catch/get the cursor so that i can db2 error occurred actually work with the cursor.I hope someone can help me. Thanks in advance for your time and efforts Post #1532361 WolfgangEWolfgangE Posted Saturday, January 18, 2014 5:24 AM SSC Veteran Group: General Forum Members Last Login: Wednesday, August 24, 2016 6:46 AM Points: 202, Visits: 774 It think the following should do it:create table #tmpSomeData ( col1 ..., col2... )insert int o#tmpSomeData ( col1, col2, ... ) execute('call mySchema.myProcedure()') at DB2_Linked_ServerThe table needs as much columns as your result set and appropriate data types.Then the execute-statement inserts the data in the table. Post #1532365 moz987moz987 Posted Monday, January 20, 2014 3:41 AM Grasshopper Group: General Forum Members Last Login: Monday, March 7, 2016 5:34 AM Points: 21, Visits: 52 Hi,i tried your suggestion and failed with this Error-Code:'[DB2] SQL0998N Error occurred during transaction or heuristic processing. Reason Code = "15". Subcode = "15". SQLSTATE=58005'The distributed transaction coordinator is started and Network DTC Access and XA Transactions are allowed. I don't understand what the problem is..The reason code 15 means that the transaction doesn't exist but i dont know why Post #1532559 WolfgangEWolfgangE Posted Monday, January 20, 2014 3:52 AM SSC Veteran Group: General Forum Members Last Login: We
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support
MQSeries.net Forum IndexMultiphase CommitMQ as a transaction coordinator for UDB MQ as a transaction coordinator for UDB View previous topic :: View next topic Author Message TheAndroid Posted: Tue Dec 04, 2007 12:26 pm Post subject: MQ as a transaction coordinator for UDB NoviceJoined: 04 Dec 2007Posts: 23 Hi all, I am getting a message from UDB: FATAL SQL ERROR SQL0998N Error occurred during transaction or heuristic processing. Reason Code = "9". Subcode = "". SQLSTATE=58005 SQLSTATE 58005: A system error (that prevents the successful execution of subsequent SQL statements) occurred. I was wondering if anyone had seen this before. I am using MQ v6 as a transaction coordinator for a 32bit COBOL program. When I was running V5.3, this worked fine. Now, I'm getting these errors. I rebuilt the switch files as directed and made sure it was in the correct directory. I know MQ is trying to use the 32 bit version as I can rename the one in /var/mqm/exits and it will complain when I do MQBEGIN. However, the documentation at boulder says it should be using the 64 bit one. If I delete the 32 bit db2swit file, I get 2212 errors (RESOURCE_MANAGER_NOT_FOUND) errors so it is demanding the 32 version. I'm at a loss on this as when I do db2 ? sql0998 the response shows two subcodes. Neither of which I'm getting. db2diag on the server doesn't show anything either. Either way, the error message itself is NO help! I realize this sounds more like a UDB post, but I have no idea what to look at next. The only thing which has changed is MQ, so I have to suspect it. Help! Back to top JuulV Posted: Tue Dec 04, 2007 1:08 pm Post subject: ApprenticeJoined: 05 Sep 2007Posts: 28Location: Belgium Just a wild guess... do you have both 32- and 64-bit versions of the switch files? And are these in the correct locations? With correct permissions? And are they correctly defined in the qm.ini file? I've notic