IT18042: SQL0998 RETURNED FROM ENLISTDISTRIBUTEDTRANSACTION

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
Db2 Version 11.1 Mod4 Fix Pack4 iFix001 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error 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)
  ...
  

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)
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * .NET provider                                                *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade client to v11.1 Fixpack 2                            *
  ****************************************************************
  

Problem conclusion

• First fixed in v11.1 Fixpack 2
  

Temporary fix

• See LOCAL FIX.
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  IT18114

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels