Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Suggestions for a good IDE for DB2 [closed]

Tags:

db2

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 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!

like image 720
ken Avatar asked Jan 05 '11 15:01

ken


People also ask

Is Db2 still popular?

Db2 is available for both on-premise and cloud storage, making it a flexible and accessible RDBMS. In terms of popularity as a database management system, IBM's Db2 ranked seventh in 2022, after Oracle, MySQL, Microsoft SQL Server, PostgreSQL, MongoDB, and Redis [3].

Is Db2 better than SQL server?

The rating of IBM DB2 is less than MS SQL. MS SQL has high rating as compared to IBM DB2. 7. It supports FORTRAN and PERL programming language.

Which component of Db2 is responsible for handling the locking services?

Locking services are provided by Locking services component known as "Internal Resource Lock Manager" (IRLM) and manages concurrency issues and deadlocks.

Is Db2 data Studio free?

Available at no charge. IBM® Data Studio provides an integrated, modular environment to enable database development and administration of IBM Db2® for Linux®, UNIX and Microsoft Windows. It also offers collaborative database development tools for IBM Db2 for z/OS®, IBM Db2 for i, IBM Informix® and IBM Big SQL.


2 Answers

we use SQuirrel a java based database client

like image 121
Leslie Avatar answered Sep 22 '22 04:09

Leslie


DbVisualizer is fairly excellent and has a generous evaluation period.

like image 43
QueyJoh Avatar answered Sep 21 '22 04:09

QueyJoh