home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
DB2 Version 9.8 Fix Pack 5 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 FixList