IBM Support

ERRORCODE=-4499, SQLSTATE=58009 may occur against DB2 zOS v10 CM8.

Troubleshooting


Problem

When running aginst DB2 zOS v10 CM8, an SQL exception with error code -4499 may happen if the setBigDecimal method of PreparedStatement/CallableStatement is used or registerOutParameter method of CallableStatement is used to register a OUT parameter of type java.sql.Types.DECIMAL

Symptom

Following errors can be seen in this case.

Trace file shows something like below:

[6/12/12 18:22:37:923 ] 00000032 logwriter 3 [jcc][t4]
[6/12/12 18:22:38:091 ] 00000032 logwriter 3 [jcc][t4] [time:2012-06-12-18:22:38.091][thread:WebContainer : 1][tracepoint:202] closing non-pooled Transport:
[6/12/12 18:22:38:091 ] 00000032 logwriter 3 [jcc][Connection@1363c8e] DB2 LUWID: GA12011E.B5E0.120612102237.0001
[6/12/12 18:22:38:093 ] 00000032 WSRdbManagedC 1 statementClosed
Notification of statement closed received from the JDBC driver.
WSRdbManagedConnectionImpl@131d9f8
com.ibm.db2.jcc.DB2PooledConnection@1c19983
com.ibm.db2.jcc.a.km@fe5f5d
[6/12/12 18:22:38:093 ] 00000032 WSRdbManagedC 1 statementClosed
Notification of statement closed received from the JDBC driver.
WSRdbManagedConnectionImpl@131d9f8
com.ibm.db2.jcc.DB2PooledConnection@1c19983
com.ibm.db2.jcc.a.lm@67dbc3
[6/12/12 18:22:38:101 ] 00000032 logwriter 3 [jcc] BEGIN TRACE_DIAGNOSTICS
[6/12/12 18:22:38:107 ] 00000032 logwriter 3 [jcc][Thread:WebContainer : 1][SQLException@187a5e9] java.sql.SQLException
[6/12/12 18:22:38:107 ] 00000032 logwriter 3 [jcc][Thread:WebContainer : 1][SQLException@187a5e9] SQL state = 58009
[6/12/12 18:22:38:107 ] 00000032 logwriter 3 [jcc][Thread:WebContainer : 1][SQLException@187a5e9] Error code = -4499
[6/12/12 18:22:38:112 ] 00000032 logwriter 3 [jcc][Thread:WebContainer : 1][SQLException@187a5e9] Message = [jcc][2034][11148][4.3.111] Execution failed due to a distribution protocol error that caused deallocation of the conversation.
[6/12/12 18:22:38:113 ] 00000032 logwriter 3 A DRDA Data Stream Syntax Error was detected. Reason: 0x12. ERRORCODE=-4499, SQLSTATE=58009
[6/12/12 18:22:38:113 ] 00000032 logwriter 3 [jcc][Thread:WebContainer : 1][SQLException@187a5e9] Stack trace follows
[6/12/12 18:22:38:113 ] 00000032 logwriter 3 com.ibm.db2.jcc.a.ho: [jcc][2034][11148][4.3.111] Execution failed due to a distribution protocol error that caused deallocation of the conversation.
[6/12/12 18:22:38:113 ] 00000032 logwriter 3 A DRDA Data Stream Syntax Error was detected. Reason: 0x12. ERRORCODE=-4499, SQLSTATE=58009

Host DB2 server shows something like below:

DSNL032I - DSNLZDJN DRDA EXCEPTION CONDITION IN
REQUEST FROM REQUESTOR LOCATION=::10.18.1.30 FOR THREAD WITH
LUWID=GA12011E.P4ED.120611030144=3665
REASON=00D35B16
ERROR ID=DSNLZSDT002C
IFCID=0191
SEE TRACE RECORD WITH IFCID SEQUENCE NUMBER=00000001

[{"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":"9.7;9.5;9.1;10.1","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

swg21598736

Page Feedback