suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT18042 Status: Closed

SQL0998 RETURNED FROM ENLISTDISTRIBUTEDTRANSACTION

product:
DB2 FOR LUW / DB2FORLUW / B10 - DB2
Problem description:
When trying to enlist a transaction for XA (2 phase commit) in 
Microsoft Entity Framework, the following error is returned: 
 
SQL0998N  Error occurred during  transaction or heuristic 
processing.  Reason Code = \"16\". Subcode = 
\"2-FFFFFFFF8004D026\"."} 
 
*  subcode 02, MSDTC was unable to register the connection. For 
more 
   information refer to the db2diag log file or the Windows 
Event Viewer 
   for an entry titled MicrosoftXARMCreate. 
 
 
Function stack returned: 
at 
IBM.Data.DB2.DB2Connection.EnlistDistributedTransaction2(Object 
iTxn) 
at IBM.Data.DB2.DB2Connection.EnlistTransaction(Transaction txn) 
at 
System.Data.Entity.Infrastructure.Interception.InternalDispatche 
r`1.Dispatch[TTarget,TInterceptionContext](TTarget target, 
Action`2 operation, TInterceptionContext interceptionContext, 
Action`3 executing, Action`3 executed) 
at 
System.Data.Entity.Infrastructure.Interception.DbConnectionDispa 
tcher.EnlistTransaction(DbConnection connection, 
EnlistTransactionInterceptionContext interceptionContext) 
at 
System.Data.Entity.Core.EntityClient.EntityConnection.EnlistTran 
saction(Transaction transaction) 
...
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* .NET provider                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade client to v11.1 Fixpack 2                            * 
****************************************************************
Local Fix:
If XA is not needed use Database.BeginTransaction 
(https://msdn.microsoft.com/en-us/library/system.data.entity.dat 
abase.begintransaction%28v=vs.113%29.aspx)
available fix packs:
DB2 Version 11.1 Mod 2 Fix Pack 2 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows

Solution
First fixed in v11.1 Fixpack 2
Workaround
See LOCAL FIX.
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
18.11.2016
23.06.2017
23.06.2017
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)