| 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 IC64525 | Status: Closed |
SQLCODE -30020 OR DRDA DATA STREAM SYNTAX ERROR REPORTED BY DB2 CONNECT SERVER after a TCP/IP error is reported. | |
| product: | |
DB2 CONNECT / DB2CONNCT / 970 - DB2 | |
| Problem description: | |
After reporting TCP/IP communication failure on gateway for one
connection, other application or connection can report sqlcode
-30020 or DRDA SYNTAX ERROR.
2009-11-06-22.03.32.435641-300 I10253A472 LEVEL: Error
PID : 1937502 TID : 23646 PROC : db2sysc
INSTANCE: svtdbm2 NODE : 000 DB : CSTDB2
APPHDL : 0-465 APPID:
9.26.76.196.2280.091107025116
AUTHID :
EDUID : 23646 EDUNAME: db2agent (EHQ3)
FUNCTION: DB2 UDB, common communication, sqlcctcpconnr,
probe:110
MESSAGE : DIA3202C The TCP/IP call "connect" returned an
errno="78".
2009-11-06-23.14.51.839574-300 I10726A472 LEVEL: Error
PID : 1937502 TID : 4885 PROC : db2sysc
INSTANCE: svtdbm2 NODE : 000 DB : CSTDB2
APPHDL : 0-464 APPID:
9.26.76.196.2279.091107025113
AUTHID :
EDUID : 4885 EDUNAME: db2agent (EHQ3)
FUNCTION: DB2 UDB, common communication, sqlcctcpconnr,
probe:110
MESSAGE : DIA3202C The TCP/IP call "connect" returned an
errno="78".
2009-11-06-23.14.52.139406-300 E11199A519 LEVEL: Error
PID : 1937502 TID : 4885 PROC : db2sysc
INSTANCE: svtdbm2 NODE : 000 DB : CSTDB2
APPHDL : 0-464 APPID:
9.26.76.196.2279.091107025113
AUTHID :
EDUID : 4885 EDUNAME: db2agent (EHQ3)
FUNCTION: DB2 UDB, DRDA Application Requester,
sqljrHandleErrorRm, probe:911
MESSAGE : ADM2503C A datastream parsing error has been
detected. A dump has
been generated.
2009-11-06-23.14.52.174285-300 E11719A524 LEVEL: Error
PID : 1937502 TID : 5142 PROC : db2sysc
INSTANCE: svtdbm2 NODE : 000 DB : CSTDB2
APPHDL : 0-448 APPID:
9.26.76.196.2263.091107024806
AUTHID :
EDUID : 5142 EDUNAME: db2agentg (CSTDB2 )
FUNCTION: DB2 UDB, DRDA Application Requester,
sqljrHandleErrorRm, probe:911
MESSAGE : ADM2503C A datastream parsing error has been
detected. A dump has
been generated.
2009-11-06-23.14.52.374871-300 I12244A917 LEVEL: Error
PID : 1937502 TID : 4885 PROC : db2sysc
INSTANCE: svtdbm2 NODE : 000 DB : CSTDB2
APPHDL : 0-464 APPID:
9.26.76.196.2279.091107025113
AUTHID :
EDUID : 4885 EDUNAME: db2agent (EHQ3)
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: *
* DB2 Connect *
****************************************************************
* PROBLEM DESCRIPTION: *
* After reporting TCP/IP communication failure on gateway for *
* one *
* connection, other application or connection can report *
* sqlcode *
* -30020 or DRDA SYNTAX ERROR. *
* *
* *
* *
* 2009-11-06-22.03.32.435641-300 I10253A472 LEVEL: *
* Error *
* PID : 1937502 TID : 23646 PROC : *
* db2sysc *
* INSTANCE: svtdbm2 NODE : 000 DB : *
* CSTDB2 *
* *
* *
* APPHDL : 0-465 APPID: *
* *
* 9.26.76.196.2280.091107025116 *
* *
* AUTHID : *
* *
* EDUID : 23646 EDUNAME: db2agent (EHQ3) *
* *
* FUNCTION: DB2 UDB, common communication, sqlcctcpconnr, *
* *
* probe:110 *
* *
* MESSAGE : DIA3202C The TCP/IP call "connect" returned an *
* *
* errno="78". *
* *
* *
* *
* 2009-11-06-23.14.51.839574-300 I10726A472 LEVEL: *
* Error *
* PID : 1937502 TID : 4885 PROC : *
* db2sysc *
* INSTANCE: svtdbm2 NODE : 000 DB : *
* CSTDB2 *
* *
* *
* APPHDL : 0-464 APPID: *
* *
* 9.26.76.196.2279.091107025113 *
* *
* AUTHID : *
* *
* EDUID : 4885 EDUNAME: db2agent (EHQ3) *
* *
* FUNCTION: DB2 UDB, common communication, sqlcctcpconnr, *
* *
* probe:110 *
* *
* MESSAGE : DIA3202C The TCP/IP call "connect" returned an *
* *
* errno="78". *
* *
* *
* *
* 2009-11-06-23.14.52.139406-300 E11199A519 LEVEL: *
* Error *
* PID : 1937502 TID : 4885 PROC : *
* db2sysc *
* INSTANCE: svtdbm2 NODE : 000 DB : *
* CSTDB2 *
* *
* *
* APPHDL : 0-464 APPID: *
* *
* 9.26.76.196.2279.091107025113 *
* *
* AUTHID : *
* *
* EDUID : 4885 EDUNAME: db2agent (EHQ3) *
* *
* FUNCTION: DB2 UDB, DRDA Application Requester, *
* *
* sqljrHandleErrorRm, probe:911 *
* *
* MESSAGE : ADM2503C A datastream parsing error has been *
* *
* detected. A dump has *
* *
* been generated. *
* *
* *
* *
* 2009-11-06-23.14.52.174285-300 E11719A524 LEVEL: *
* Error *
* PID : 1937502 TID : 5142 PROC : *
* db2sysc *
* INSTANCE: svtdbm2 NODE : 000 DB : *
* CSTDB2 *
* *
* *
* APPHDL : 0-448 APPID: *
* *
* 9.26.76.196.2263.091107024806 *
* *
* AUTHID : *
* *
* EDUID : 5142 EDUNAME: db2agentg (CSTDB2 ) *
* *
* FUNCTION: DB2 UDB, DRDA Application Requester, *
* *
* sqljrHandleErrorRm, probe:911 *
* *
* MESSAGE : ADM2503C A datastream parsing error has been *
* *
* detected. A dump has *
* *
* been generated. *
* *
* *
* *
* 2009-11-06-23.14.52.374871-300 I12244A917 LEVEL: *
* Error *
* PID : 1937502 TID : 4885 PROC : *
* db2sysc *
* INSTANCE: svtdbm2 NODE : 000 DB : *
* CSTDB2 *
* *
* *
* APPHDL : 0-464 APPID: *
* *
* 9.26.76.196.2279.091107025113 *
* *
* AUTHID : *
* *
* EDUID : 4885 EDUNAME: db2agent (EHQ3) *
* *
* 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: *
****************************************************************
* RECOMMENDATION: *
* Upgrade to the fixpack with APAR *
**************************************************************** | |
| Local Fix: | |
| available fix packs: | |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows | |
| Solution | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 12.11.2009 24.02.2010 24.02.2010 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 9.7.0.1 |
|