https://github.com/famousdraw

What does SQLJC_ERROR_SYNTAX error mean and how to resolve it?

IBM Support

What does SQLJC_ERROR_SYNTAX error mean and how to resolve it?

https://www.ibm.com/support/pages/what-does-sqljcerrorsyntax-error-mean-and-how-resolve-it

Question & Answer


Question

db2diag.log reports a lot of SQLJC_ERROR_SYNTAX error like below: 2016-11-02-09.06.21.986732+480 I7712902E491 LEVEL: Severe PID : 1380 TID : 47356997265728PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : TEST APPHDL : 0-202 APPID: 192.168.1.10.53764.161102010601 AUTHID : TEST EDUID : 284 EDUNAME: db2agent (TEST) 0 FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReadDssHdr, probe:20 MESSAGE : ZRC=0x8036008D=-2143944563=SQLJC_ERROR_SYNTAX "SYNTAX ERROR" 2016-11-02-09.06.21.987028+480 I7713394E196 LEVEL: Severe PID:1380 TID:47356997265728 NODE:000 Title: **** DRDA CMNMGR CB **** Dump File: /home/db2inst1/sqllib/db2dump/1380.284.000.dump.bin 2016-11-02-09.06.21.987286+480 I7713591E193 LEVEL: Severe PID:1380 TID:47356997265728 NODE:000 Title: **** DSS SEGMENT **** Dump File: /home/db2inst1/sqllib/db2dump/1380.284.000.dump.bin 2016-11-02-09.06.21.987411+480 I7713785E196 LEVEL: Severe PID:1380 TID:47356997265728 NODE:000 Title: **** RECEIVE BUFFER **** Dump File: /home/db2inst1/sqllib/db2dump/1380.284.000.dump.bin 2016-11-02-09.06.21.987491+480 I7713982E194 LEVEL: Severe PID:1380 TID:47356997265728 NODE:000 Title: **** SEND BUFFERS **** Dump File: /home/db2inst1/sqllib/db2dump/1380.284.000.dump.bin 2016-11-02-09.06.21.987575+480 I7714177E515 LEVEL: Warning PID : 1380 TID : 47356997265728PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : TEST APPHDL : 0-202 APPID: 192.168.1.10.53764.161102010601 AUTHID : TEST EDUID : 284 EDUNAME: db2agent (TEST) 0 FUNCTION: DB2 UDB, common communication, sqlcctcplogIPAddress, probe:50 MESSAGE : DIA3220W Client sent data from IP address = "192.168.1.10", port = "1234". 2016-11-02-09.06.21.987822+480 I7714693E491 LEVEL: Severe PID : 1380 TID : 47356997265728PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : TEST APPHDL : 0-202 APPID: 192.168.1.10.53764.161102010601 AUTHID : TEST EDUID : 284 EDUNAME: db2agent (TEST) 0 FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReadDssHdr, probe:20 MESSAGE : ZRC=0x8036008D=-2143944563=SQLJC_ERROR_SYNTAX "SYNTAX ERROR" What does it mean and how to resolve it?

Answer

This error means the received buffer does not conform to DRDA structure which is the protocol used for the communication between db2 client and server. The possible cause is that a program on the client machine identified by APPID or displayed in DIA3220W message is trying to scan the port used by db2 server, or captured the db2 package and modified it wrongly.

 
 

Document Information

More support for:
Db2 for Linux, UNIX and Windows

Software version:
10.1, 10.5, 11.1, 9.7, 9.8

Operating system(s):
AIX, HP-UX, Linux, Solaris, Windows

Document number:
285993

Modified date:
16 June 2018

 
 
 
 
 
Manage My Notification Subscriptions
 
Contact IBMPrivacyTerms of useAccessibility
 
 
 
 

posted on 2022-12-07 09:11  红色MINI  阅读(32)  评论(0)  编辑  收藏  举报

导航