Free alternative of TOAD for DB2

views:

613

answers:

Free alternative of TOAD for DB2

I am currently using Toad for DB2 to work on my DB2 database. I just wanted to know is there any free alternative to Toad for DB2,

Note: Similar question is posted earlier, but it was for TOAD [ oracle ], none of the solution specified is for DB2 obviously.

+3 A:

Try AQT or SquirrelSQL (depending on your budget and patience).

Aaron Digulla 2009-10-07 12:42:03

why did u said *patience* :D

Rakesh Juyal 2009-10-07 12:48:51

Ah, well, Squirrel has code completion (which I like a lot) but the overall handling is a bit better in AQT. Squirrel sometimes likes to hang for a couple of second after restoring it from the task bar. It's nothing major and I do most of my work with Squirrel but I prefer AQT to browse the admin structures (grants, view definitions, active queries and locks, etc).

Aaron Digulla 2009-10-07 12:52:37

Aaron: On the other hand, Oracle's SQLDeveloper only allows one open connection at a time! So it doesn't allow structure browsing while another query is running. SQuirreL does.

tpdi 2009-10-07 13:02:45

Both AQT and SquirrelSQL can open several connections.

Aaron Digulla 2009-10-07 13:14:29

+1 A:

SQuirreL SQL Client works well. As far as its GUI, their are several different "Look&Feel"s to choose from. (But yeah, it's too busy to use ona netbook, I know.)

tpdi 2009-10-07 12:43:26

Actually earlier i used Squirrel but IMO it is not having good GUI and enough functionalities. But certainly i can switch back to it.

Rakesh Juyal 2009-10-07 12:54:02

Apparently the next version of Oracle SQL Developer can connect to some flavours of DB2. More info on the OTN forum (including a link to the Early Adopter release)

APC 2009-10-07 12:44:52

I like SQLDbx, which handles several flavours of database, including some DB2. I'm afraid that I'm not familiar with DB2, but their web site says it is compatible with IBM DB2 LUW ® 7.x - 9.x, IBM DB2® z/OS 7.x - 9.x and IBM DB2® iSeries 5.x - 6x. Some of the functionality for some of these are only available in their Professional edition, and not the free one.

kevinw 2009-10-07 14:18:05

+1 A:

I've used Embarcadero's DBArtisan in the past. It worked great on our DB2 environment, but was able to work against our SQLServer as well.

Nathan Koop 2009-10-07 14:33:54

Free!!! is it free? no..

Rakesh Juyal 2009-10-08 05:28:59

my apologies, I missed that portion of the question.

Nathan Koop 2009-10-08 14:56:30

I suggest Aqua Data Studio, it is cool database font end You can use Aqua Data Studio with many database such as DB2, Oracle, Ms. Access, and etc.

Fuangwith S. 2009-10-21 08:39:29

ansaurus

tags:

views:

answers:

Free alternative of TOAD for DB2

related questions