Re: [Squirrel-sql-users] Cannot Connect to DB2

[Alex M. <ale...@bl...>]

And you tried using both db2jcc.jar and db2jcc4.jar?
I do not recall any problems connecting, but also can't recall which JAR I have used, as it's been years since configuring and I am away from the datacenter now.
Years ago when I was starting to use Squirrel with DB2 and DB/400 I used this link to set up: https://www.ibm.com/developerworks/data/library/techarticle/dm-0312bhogal/index.html

Thank you
Alex


From: Craig Mangum [mailto:Cra...@sa...]
Sent: Friday, July 14, 2017 10:20 AM
To: squ...@li...
Subject: [Squirrel-sql-users] Cannot Connect to DB2

I am unsuccessful trying to connect to DB2 using Squirrel SQL Client Version 3.7.1  I can connect to Greenplum, Oracle, Postgres, SQL Server and Teradata with no problems.

My setup is this:

Squirrel SQL Client Version 3.7.1
Java Runtime Version: 1.8.0_131-b11
OS System: Windows Server 2012 R2 64-bit
Java Class Version: 52.0
DB2 Version: DB2 V10.5.0.420, Fix Pack 0
JDBC Driver Version: 4.16.53 to match DB2 V10.5 FP0 and FP1

I have tried multiple versions of JDBC and I always get the following slack trace output. This seems to be some sort of mis-match between versions of DB2 and JDBC.  Does anyone know the proper JDBC jar for my setup above?

java.util.concurrent.ExecutionException: java.lang.RuntimeException: com.ibm.db2.jcc.am.DisconnectNonTransientException: [jcc][t4][2034][11148][4.16.53] Execution failed due to a distribution protocol error that caused deallocation of the conversation.
A DRDA Data Stream Syntax Error was detected.  Reason: 0x13. ERRORCODE=-4499, SQLSTATE=58009
    at java.util.concurrent.FutureTask.report(Unknown Source)
    at java.util.concurrent.FutureTask.get(Unknown Source)
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.awaitConnection(OpenConnectionCommand.java:132)
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$100(OpenConnectionCommand.java:45)
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$2.run(OpenConnectionCommand.java:115)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.RuntimeException: com.ibm.db2.jcc.am.DisconnectNonTransientException: [jcc][t4][2034][11148][4.16.53] Execution failed due to a distribution protocol error that caused deallocation of the conversation.
A DRDA Data Stream Syntax Error was detected.  Reason: 0x13. ERRORCODE=-4499, SQLSTATE=58009
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:171)
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$000(OpenConnectionCommand.java:45)
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$1.run(OpenConnectionCommand.java:104)
    ... 5 more
Caused by: com.ibm.db2.jcc.am.DisconnectNonTransientException: [jcc][t4][2034][11148][4.16.53] Execution failed due to a distribution protocol error that caused deallocation of the conversation.
A DRDA Data Stream Syntax Error was detected.  Reason: 0x13. ERRORCODE=-4499, SQLSTATE=58009
    at com.ibm.db2.jcc.am.fd.a(fd.java:322)
    at com.ibm.db2.jcc.am.fd.a(fd.java:428)
    at com.ibm.db2.jcc.t4.x.j(x.java:998)
    at com.ibm.db2.jcc.t4.x.c(x.java:496)
    at com.ibm.db2.jcc.t4.x.v(x.java:1201)
    at com.ibm.db2.jcc.t4.y.d(y.java:150)
    at com.ibm.db2.jcc.t4.b.k(b.java:1385)
    at com.ibm.db2.jcc.t4.b.b(b.java:1297)
    at com.ibm.db2.jcc.t4.b.a(b.java:6433)
    at com.ibm.db2.jcc.t4.b.b(b.java:848)
    at com.ibm.db2.jcc.t4.b.a(b.java:765)
    at com.ibm.db2.jcc.t4.b.a(b.java:423)
    at com.ibm.db2.jcc.t4.b.a(b.java:398)
    at com.ibm.db2.jcc.t4.b.<init>(b.java:336)
    at com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(DB2SimpleDataSource.java:233)
    at com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(DB2SimpleDataSource.java:199)
    at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:474)
    at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:115)
    at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:167)