Is there any opensource DB2 client?

Question

I am using db2 version 7 , i need an windows application (similar to MSSQL) to do the database operations.

Does it have to be open source? Isn't there an official DB2 client for Windows? And also things like JDBC drivers? — Thilo, Dec 22 '11 at 07:43
In my view Plotly Falcon is a great open source SQL editor for Db2: https://plot.ly/free-sql-client-download/ — SilentSteel, Jan 15 '18 at 14:11

Faisal · Answer 1 · 2019-12-19T13:13:33.870

16

You can use Oracle's SQL Developer, its quite good and its FREE.

But you will need to download and import db2jcc.jar in the under tools>preferences>database>third party JDBC drivers option.

Hope this helped :)

edited Dec 19 '19 at 13:13

answered Jul 02 '14 at 08:12

Faisal

442
5
13

2

The db2jcc.jar link doesn't work anymore. It says Not Found when trying to download it. – Bobe Kryant Mar 08 '17 at 08:40
2

DB2 JDBC Driver Versions and Downloads: https://www-01.ibm.com/support/docview.wss?uid=swg21363866 – Robert Hume Aug 02 '18 at 09:02

score 10 · Answer 2 · answered Jan 24 '13 at 18:33

10

Came across this thread as I was doing research on this question. Figured I'd add my two cents in case someone else swings through via the Googles

I've found two Open-Source clients:

Squirrel: http://www.squirrelsql.org/
Eclipse: http://eclipsesql.sourceforge.net/index.php

I've not used either, but they both look fairly solid. The recommendations I've gotten have steered me towards Squirrel, but it seems to be more personal preference than anything.

answered Jan 24 '13 at 18:33

Gyrfalcon2138

352
3
14

So, over the time I've used it - the free version of Eclipse is almost unusable. I'm sure it's great if you can pay for it, but I'm definitely happier with Squirrel. – Gyrfalcon2138 May 29 '13 at 17:09

score 6 · Answer 3 · edited Mar 13 '18 at 15:52

6

Personally I recommend DBVisualizer (Java client) or IBM Data Studio (eclipse based). Both are free ;-)

edited Mar 13 '18 at 15:52

Doug Porter

7,721
4
40
55

answered Jul 07 '14 at 09:24

Seb.B.

151
1
3

score 3 · Answer 4 · answered Dec 29 '11 at 05:42

I'm fairly certain even if you have an open-source client, you still have to download the DB2 driver which only comes through IBM.

The official clients are free to download and use.

You may want to consult this page to determine which of the download options you want.

Is there any opensource DB2 client?

4 Answers4