Cannot Connect to DB2

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Cannot Connect to DB2

Craig Mangum

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)

 

 

 

 

 

 

 

 

 

 

           


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Cannot Connect to DB2

Alex Malmyguine-2

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:[hidden email]]
Sent: Friday, July 14, 2017 10:20 AM
To: [hidden email]
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)

 

 

 

 

 

 

 

 

 

 

           


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Loading...