DB2 - Problembeschreibung
Problem IC78007 | Status: Geschlossen |
32 BIT XA APPLICATION RUNNING ON WINDOWS/ DB2 64 BITS FAILS WITH SQL0998N | |
Produkt: | |
DB2 CONNECT / DB2CONNCT / 970 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * 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 | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows | |
Lösung | |
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 | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 09.08.2011 13.02.2012 13.02.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP5 | |
Problem behoben lt. FixList in der Version | |
9.7.0.5 |