db2squirrel-sql

Connecting Squirrel Client to DB2 Server over SSL Connection

I am using Squirrel 3.5.0 client to connect to DB2 Database. Recently I have changed my DB2 to run on SSL instead of normal TCS/IP. Now I want Squirrel to connect to my DB2 server using SSL port. So I updated the port number in the connection string. Now I need to add the server certificate into the Squirrel client truststore so that it can trust the server connection but I don't know how to do it? Does anyone have any idea over it?

Solution

  • Just in case if anyone else is looking trying to accomplish the same stuff:

    1. Find out the JAVA_HOME path.

    2. Run the following command

      keytool -importcert -file e:/certificateName.ext -keystore \jre\lib\security\cacerts

    3. Open Squirrel, and modify the connection aliase. At the end of connection string append the following :sslConnection=true;

    4. That's it, now you can connect with the database over SSL.