JR28028: SQL0998N RC=16 WITH DB2.NET PROVIDER WHEN MSDTC IS USED AND REGI STRY KEY IS NOT FOUND

DB2 Version 9.1 Fix Pack 7  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 5   for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6   for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7a  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 8  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

APAR status

• Closed as program error.

Error description

• An application may receive the following error:
  "SQL0998N  Error occurred during transaction or heuristic
  processing.  Reason Code = "16". Subcode = "2-80004005".
  SQLSTATE=58005"
  .
  This would happen if the DB2.NET data provider is being used
  and it is being used with MSDTC.   MSDTC looks at the Windows
  registry key for the full path name to the db2app.dll library.
  The problem is that the DB2.NET provider uses a second backslash
  when it loads the db2app.dll library.  This path is different
  from the path in the Windows registry key
  HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\XADLL which is what
  caused the error.
  .
  This APAR will ensure that when the db2app.dll is loaded by the
  DB2.NET provider that only a single backslash is used before the
  "bin" folder in the path name.
  

Local fix

• Modify the Windows registry by adding a second backslash to DB2
  Path name before "bin" for the
  HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\XADLL registry key.
  

Problem summary

• Users Affected:   DB2 .NET Data Provider users.
  Problem Description:  SQL0998N RC=16 when using DB2.NET provider
  with MSDTC.
  

Problem conclusion

• First fixed in DB2 UDB Version 9, Fixpak 5
  

Temporary fix

• Modify the windows registry to add an extra backlash before
  "bin".
  

Comments

APAR Information

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

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

  JR28029

Fix information

• Fixed component name

  DB2 UDB ESE WIN

• Fixed component ID

  5765F4101

Applicable component levels

• R910 PSN

     UP