Suggestions for a good IDE for DB2 [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

---

Questions asking us to recommend or find a book, tool, software library, tutorial or other off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it.

Closed 8 years ago.

Improve this question

I know, I know... it's a horrible fate but I am forced to work in an environment with DB2 on the back end. OK just kidding but the truth is I do like MSSQL's data studio开发者_JS百科 a lot, and well IBM's tool is sorda crummy in my opinion... I was using the free version of Toad but I just got a new 64bit machine which is nice and all but there isn't a free version of Toad that I can find for win7 64.

Does anyone have any suggestions for a good IDE to use with DB2? Being a developer I really just do a lot of looking at the DB structure and querying to see what I get back and how I want to get things back etc...

Thanks for any advice!

---

we use SQuirrel a java based database client

---

DbVisualizer is fairly excellent and has a generous evaluation period.

---

As a developer I like WinSQL from Synametrics a lot. For me this is the best tool available on the market and works with all major databases: http://www.synametrics.com/SynametricsWebApp/WinSQL.jsp

---

Have you tried IBM Optim Data Studio, and it is based on Eclipse, so it could be integrated with many existent plugins for this IDE http://www-01.ibm.com/software/data/optim/data-studio/

And it is free.

---

I am using QMF For Windows. But I am not in a position to say it is the best tool

From http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.qmf.doc.intro/gc187443.pdf?noframes=true

DB2 Query Management Facility (QMF) is a tightly integrated, powerful, and reliable tool that performs query and reporting for IBM’s DB2 relational database management system family.