Suggestions for a good development environment for DB2

Question

I know, I know ... this is a terrible fate, but I have to work in an environment with DB2 on the back. OK, I'm just joking, but the truth is that I really like MSSQL data studio, and in my opinion, the IBM tool is sorda crummy ... I used the free version of Toad, but I just got a new 64-bit machine, which everything is good but there is no 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 look a lot at the database structure and queries to find out what I will return and how I want to return things, etc.

Thanks for any advice!

Answer 1

we use jQuirrel Squirrel database client

Answer 2

DbVisualizer is good enough and has a generous evaluation period.

Answer 3

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

Answer 4

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

And it's free.

Answer 5

I am using QMF for Windows . But I am not able to say that this is the best tool

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

The DB2 Query Management Tool (QMF) is a tightly integrated, powerful, and reliable tool that runs queries and reports for the IBM IBM family of relational database management systems.