|
Problem IC78007
|
Status: Closed |
32 BIT XA APPLICATION RUNNING ON WINDOWS/ DB2 64 BITS FAILS WITH SQL0998N |
| product: |
DB2 CONNECT / DB2CONNCT / 970 - DB2 |
| Problem description: |
When a 32 bit XA application runs on Windows/ DB2 64 bits, XA
transactions get:
SQL0998N Error occurred during transaction or heuristic
processing.
Reason Code = "16". Subcode = "2-80004005". |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Windows DB2 32 bit XA application user *
****************************************************************
* PROBLEM DESCRIPTION: *
* When a 32 bit XA application runs on Windows/ DB2 64 bits, *
* XA *
* transactions get: *
* *
* *
* *
* SQL0998N Error occurred during transaction or heuristic *
* *
* processing. *
* *
* Reason Code = "16". Subcode = "2-80004005". *
* *
* The problem only happens to 32 bit XA application. 64 bit *
* application is not effected. *
* *
* This is due to XADLL registry key reference to the 32 bit *
* db2app.dll which cannot be loaded by Windows MSDTC. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to v9.7 FP5 *
**************************************************************** |
| Local Fix: |
Redirect the 32-bit XADLL reg key (at
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\XADLL) as below:
1. Run 'regedit' on command line.
2. Go to the registry key of:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\XADLL
3. It currently should have a registry key name of
<db2path>\db2app.dll
4. Right click on this key, choose "Modify"
5. Current 'Value data' shows: <db2path>\db2app.dll, modify it
to: <db2path>\db2app64.dll |
| available fix packs: |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in Version 9.7 Fix Pack 5 |
| Workaround |
Redirect the 32-bit XADLL reg key (at
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\XADLL) as below:
1. Run 'regedit' on command line.
2. Go to the registry key of:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\XADLL
3. It currently should have a registry key name of
<db2path>\db2app.dll
4. Right click on this key, choose "Modify"
5. Current 'Value data' shows: <db2path>\db2app.dll, modify it
to: <db2path>\db2app64.dll |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 09.08.2011
13.02.2012
13.02.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
