IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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 Version 9.5 Fix Pack 1
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR28029

  • Reported component name

    DB2 UDB ESE WIN

  • Reported component ID

    5765F4101

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2007-12-10

  • Closed date

    2008-05-05

  • Last modified date

    2012-06-12

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

    JR28028

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

Fix information

  • Fixed component name

    DB2 UDB ESE WIN

  • Fixed component ID

    5765F4101

Applicable component levels

  • R950 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 June 2012