DB2 - Problembeschreibung
Problem IC77552 | Status: Geschlossen |
-30020(SYNTAX ERROR) IS RETURNED WHEN MSDTC GETS A TIMEOUT WHILE STREAMING IS IN PROGRESS | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 980 - DB2 | |
Problembeschreibung: | |
Application will report sqlcode -30020. A binary dump is generated and the following message are logged in db2diag.log. 2010-08-12-11.39.47.473000-240 E1378F417 LEVEL: Error PID : 2928 TID : 2960 PROC : .... INSTANCE: DB2_02 NODE : 000 APPID : EDUID : 2960 FUNCTION: DB2 UDB, DRDA Application Requester, sqljrHandleErrorRm, probe:911 MESSAGE : ADM2503C A datastream parsing error has been detected. A dump has been generated. 2010-08-12-11.39.47.473000-240 I1797F823 LEVEL: Error PID : 2928 TID : 2960 PROC : BCom.exe INSTANCE: DB2_02 NODE : 000 APPID : EDUID : 2960 FUNCTION: DB2 UDB, DRDA Application Requester, sqljrHandleErrorRm, probe:911 MESSAGE : ZRC=0x8037008D=-2143879027=SQLJR_SYNTAX "SYNTAX ERROR" DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: -30020 sqlerrml: 17 sqlerrmc: 0x124C"("011D")" sqlerrp : sqljrerm sqlerrd : (1) 0x8037008D (2) 0x0000008D (3) 0x00000000 (4) 0x00000000 (5) 0x00000000 (6) 0x00000000 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Client using MSDTC * **************************************************************** * PROBLEM DESCRIPTION: * * Application will report sqlcode -30020. A binary dump is * * * * generated and the following message are logged in * * db2diag.log. * * * * * * * * * * 2010-08-12-11.39.47.473000-240 E1378F417 LEVEL: * * * * Error * * * * PID : 2928 TID : 2960 PROC : * * .... * * INSTANCE: DB2_02 NODE : 000 * * * * APPID : * * * * EDUID : 2960 * * * * FUNCTION: DB2 UDB, DRDA Application Requester, * * * * sqljrHandleErrorRm, probe:911 * * * * MESSAGE : ADM2503C A datastream parsing error has been * * * * detected. A dump has * * * * been generated. * * * * * * * * 2010-08-12-11.39.47.473000-240 I1797F823 LEVEL: * * * * Error * * * * PID : 2928 TID : 2960 PROC : * * * * BCom.exe * * * * INSTANCE: DB2_02 NODE : 000 * * * * APPID : * * * * EDUID : 2960 * * * * FUNCTION: DB2 UDB, DRDA Application Requester, * * * * sqljrHandleErrorRm, probe:911 * * * * MESSAGE : ZRC=0x8037008D=-2143879027=SQLJR_SYNTAX * * "SYNTAX * * ERROR" * * * * DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes * * * * sqlcaid : SQLCA sqlcabc: 136 sqlcode: -30020 * * * * sqlerrml: 17 * * * * sqlerrmc: 0x124C"("011D")" * * * * sqlerrp : sqljrerm * * * * sqlerrd : (1) 0x8037008D (2) 0x0000008D (3) * * * * 0x00000000 * * * * (4) 0x00000000 (5) 0x00000000 (6) * * * * 0x00000000 * * * * sqlwarn : (1) (2) (3) (4) (5) * * * * (6) * * * * (7) (8) (9) (10) (11) * **************************************************************** * RECOMMENDATION: * * Upgrade v9.8.4. * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.8 Fix Pack 4 for AIX and Linux | |
Lösung | |
Applicationrollback the transaction on streaming timeout condition. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 15.07.2011 12.09.2011 12.09.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.8.4 | |
Problem behoben lt. FixList in der Version | |
9.8.0.4 |