| Latest versions | fixlist |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
DB2 - Problem description
| Problem IC77552 | Status: Closed |
-30020(SYNTAX ERROR) IS RETURNED WHEN MSDTC GETS A TIMEOUT WHILE STREAMING IS IN PROGRESS | |
| product: | |
DB2 FOR LUW / DB2FORLUW / 980 - DB2 | |
| 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)
sqlstate: | |
| Problem Summary: | |
****************************************************************
* 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: | |
| available fix packs: | |
DB2 Version 9.8 Fix Pack 4 for AIX and Linux | |
| Solution | |
Applicationrollback the transaction on streaming timeout condition. | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 15.07.2011 12.09.2011 12.09.2011 |
| Problem solved at the following versions (IBM BugInfos) | |
9.8.4 | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 9.8.0.4 |
|