IBM Support

What does SQLJC_ERROR_SYNTAX error mean and how to 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?

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Connectivity - DRDA","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.1;10.5;11.1;9.7;9.8","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
30 April 2025

UID

swg21994767

Page Feedback