Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Configure SQuirreL for DB2

Tags:

db2

squirrel-sql

How to configure SQuirreL for DB2 access.

In SQuirreL I do see two DB2 drivers. But they are both marked with an red X.

I checked with Start Page but did not find an easy solution :/

like image 670
Thorsten Niehues Avatar asked Feb 10 '17 15:02

Thorsten Niehues

People also ask

What is db2jcc_license_cisuz jar?

The db2jcc_license_cisuz. jar file is included in all DB2 Connect server editions including DB2 Connect Personal Edition. The license is also part the IBM Database Enterprise Developer Edition. If you already have one of these products, then please use the license file from the DB2 Connect Activation CD.

1 Answers

  1. Download the DB2 Driver from the IBM Website and extract the ZIP archive.
    Optionally you may want to copy it from the DB2 Server installation path:
    /opt/ibm/db2/V11.1/java/db2jcc4.jar
  2. Use db2jcc4.jar and copy it into the squirrel folder e.g. plugins/db2
  3. In der Driver in the tab "Extra Class Path" add the db2jcc4.jar file
  4. Change the class name to com.ibm.db2.jcc.DB2Driver

enter image description here

like image 150
Thorsten Niehues Avatar answered Oct 14 '22 01:10

Thorsten Niehues
Sign in to Comment

Related questions

How Do I Use Case Statement Column In Group By
How to CREATE PROCEDURE in H2
sort query result without selecting that column but sort by that column?
SQL1159 Initialization error with DB2 .NET Data Provider, reason code 2
Different NuGet package based on operating system
DB2 SQL error sqlcode=-104 sqlstate=42601
Calculating how many days are between two dates in DB2?
Why do I get SQLCODE=-204, SQLSTATE=42704 with DB2 LUW and WebSphere App Server?
Is there a good in-memory database that would act like DB2 [closed]
How to use NOT EXISTS with COMPOSITE KEYS in SQL for inserting data from POJO
How to find all open/active connections in DB2 (8.x)
how to connect hibernate and DB2
How can I update top 100 rows in DB2
db2 query to select the first row fetched
Regular Expressions in DB2 SQL
DB2 SQL error: SQLCODE: -206, SQLSTATE: 42703 [closed]
ERRORCODE=-4461, SQLSTATE=42815 in DB2
How to prevent SQL injection when the statement has a dynamic table name?
how do i get the current schema on DB2 if i have a JDBC conneciton?
How to use LIKE with IN in DB2?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!