IC64525: SQLCODE -30020 OR DRDA DATA STREAM SYNTAX ERROR REPORTED BY DB2 CONNECT SERVER after a TCP/IP error is reported.
-
After reporting TCP/IP communication failure on gateway for one
Show more
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
MES...
-
****************************************************************
* 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 *
****************************************************************
Show less
Status
Closed
Fixed if Next (FIN)
-
Product
Db2 Connect
Software version
9.7.0
Document number
DT170300
Last modified
2022年11月30日 GMT+8 19:14
------------------------------------------------------------------------------------------
如果你觉得文章有用,欢迎打赏