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
------------------------------------------------------------------------------------------
如果你觉得文章有用，欢迎打赏
【推荐】国内首个AI IDE，深度理解中文开发场景，立即下载体验Trae
【推荐】编程新体验，更懂你的AI，立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包，你的智能百科全书，全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell：AI 加持，快人一步
· 被坑几百块钱后，我竟然真的恢复了删除的微信聊天记录！
· 没有Manus邀请码？试试免邀请码的MGX或者开源的OpenManus吧
· 【自荐】一款简洁、开源的在线白板工具 Drawnix
· 园子的第一款AI主题卫衣上架——"HELLO! HOW CAN I ASSIST YOU TODAY
· Docker 太简单，K8s 太复杂？w7panel 让容器管理更轻松！