Any good third party query/admin tools for DB2 3

[ddiamond]

I'm currently using Quest's SQL-Navigator to manage our oracle database. Sadly, this wonderful tool only works with oracle. Are there any similar tools for DB2/UDB?

 

[rbod]

DBArtisan from Embarcadero Technologies.
Quest Central for DB2.

 

[ddiamond]

rbod, thanks for the recommendations. According to their website, DBArtisan currently supports IBM DB2 EE, EEE and ESE for Open Systems 7.1 - 8.x, What does EE, EEE, and ESE refer to? I didn't find any pricing information on their website. Do you know how much DBArtisan costs?

 

[blom0344]

This one is just about for free:

http://members.tripod.com/chuzhoi_files/

use it everyday, never ceases to marvel at some developer's competences!

Ties Blom
Information analyst

 

[rbod]

Enterprise Edition (EE)
Extended Enterprise Edition (EEE)
Enterprise Server Edition (ESE)

Most corporate installations will utilize either Enterprise
Edition (EE) or Enterprise Extended Edition (EEE) depending on the size of the applications. EEE is the database of choice for very large data warehouse type applications. Version 8 of DB2 combines EE/EEE
together into ESE or Enterprise Server edition.

I am not sure how much DBArtisan costs. You can download a trial version and try it out first.

Check out the following link for more info:

http://www-128.ibm.com/developerworks/db2/library/techarticle/0211zikopoulos/0211zikopoulos.html

 

[rbod]

Another free[for personal use]query/administration tool is Aqua Data Studio -

http://www.aquafold.com

Works with different databases. It has a query analyzer, can do explain plans, does auto completes, executes sql scripts. It is very useful for the developers.
Check it out.

 

[shew01]

We use Quest Central for DB2 here with DB2 UDB, and we are very pleased with the product. The site has a free trial:

http://www.quest.com/solutions/download.asp

Jon