Troubleshooting
Problem
After upgrading the local DB2 server or IBM Data Server client, a Type 2 connection using the IBM Data Server Driver for JDBC and SQLJ may fail with an exception similar to the following:
Symptom
[jcc][2034][11148][3.53.70] Execution failed due to a distribution protocol error that caused deallocation of the conversation. A DRDA Data Stream Syntax Error was detected. Reason: 0x1. ERRORCODE=-4499, SQLSTATE=58009
Cause
For a Type 2 (native) connection, the driver JAR file (db2jcc.jar or db2jcc4.jar) and the local DB2 instance need to be at compatible product levels, since the DB2 native libraries are loaded by the driver. If this is not the case, unpredictable results, including the above protocol exception, may occur.
Resolving The Problem
Please take the following steps:
- Search the application class path for all copies of db2jcc.jar (or db2jcc4.jar). Only one (1) copy of the JAR file should be in the application class path. It is recommended that this file be loaded from <instance_home>sqllib/java on Linux/Unix, or from <DB2_install_path>\sqllib\java directory on Windows systems.
- Verify the version of the JDBC driver:
java -cp <classpath> com.ibm.jcc.DB2Jcc -version
- Verify the version and Fixpack level of the DB2 instance:
db2level
- Compare the JDBC driver level and the DB2 instance db2level to the list of compatible DB2 and JDBC driver versions
- Replace the current driver JAR file in order to match the DB2 instance's product level, if necessary.
Related Information
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21462154