What CLI commands are you issuing?
I have always used the IBM drivers over the SQUIRREL included drivers FWIW ==============================================Matt Ferreira
de...@ya...
From: Shilpa Kotiyan <sko...@zt...>
To: squ...@li...
Sent: Friday, August 26, 2016 8:21 AM
Subject: [Squirrel-sql-users] remote db2 connection over ssh tunnel
Hi, I am using squirrel 3.7 to connect to a db2 database on linux. I am tunneled to the DB server over ssh using putty. I confirmed that the tunnel is working as I can execute sql over the command line. However, when I attempt to connect via squirrel;, I get the error below:
Connection via DB2 universal driver. using the format "jdbc:db2://localhost:port/dbname"
Java.util.concurrent.ExecutionException: java.lang.RuntimeException: com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2057][11264][4.17.29] The application server rejected establishment of the connection.An attempt was made to access a database, AUTH, which was either not found or does not support transactions. ERRORCODE=-4499, SQLSTATE=08004 at java.util.concurrent.FutureTask.report(FutureTask.java:123) at java.util.concurrent.FutureTask.get(FutureTask.java:207) 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
Thanks,
------------------------------------------------------------------------------
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
|