DB2 database IDE

Warren

Hi, DBAs and application developers out there,

which IDE is the best for DB2? I've been used to TOAD on Oracle, but
the new project uses DB2 and I hope to hear some good suggestions.

I've tried Toad for DB2 free, but it is buggy and hangs and disappears
out of nowhere when I run queries sometimes. Aqua studio 4.x free
version just doesn't run well on my Vista + Java(bad combination). DB
Visualizer personal edition is only 30 days and it can't even do
simple little things after the licence expired.
Suggestions please!

Thank you.

Sep 7 '07 #1

Serge Rielau

Warren wrote:

Hi, DBAs and application developers out there,

which IDE is the best for DB2? I've been used to TOAD on Oracle, but
the new project uses DB2 and I hope to hear some good suggestions.

I've tried Toad for DB2 free, but it is buggy and hangs and disappears
out of nowhere when I run queries sometimes. Aqua studio 4.x free
version just doesn't run well on my Vista + Java(bad combination). DB
Visualizer personal edition is only 30 days and it can't even do
simple little things after the licence expired.
Suggestions please!

Have you taken a look at the Rational Toolset (E.g. Rational App Developer)?
Then there is the free Developer Workbench.
If you are a .NET person DB2 has exceptionally deep plug-ins ... (At
least that's what our tools team says :-)

If you go to the DB2 Viper 2 download site you should also find a
refresh of DWB (in beta) which is quite nice.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Sep 7 '07 #2

Juan Singh

Try WinSQL (synametrics.com)

Warren wrote:

Hi, DBAs and application developers out there,

which IDE is the best for DB2? I've been used to TOAD on Oracle, but
the new project uses DB2 and I hope to hear some good suggestions.

I've tried Toad for DB2 free, but it is buggy and hangs and disappears
out of nowhere when I run queries sometimes. Aqua studio 4.x free
version just doesn't run well on my Vista + Java(bad combination). DB
Visualizer personal edition is only 30 days and it can't even do
simple little things after the licence expired.
Suggestions please!

Thank you.

Sep 7 '07 #3

MeBuggyYouJane

Warren wrote:

Hi, DBAs and application developers out there,

which IDE is the best for DB2? I've been used to TOAD on Oracle, but
the new project uses DB2 and I hope to hear some good suggestions.

I've tried Toad for DB2 free, but it is buggy and hangs and disappears
out of nowhere when I run queries sometimes. Aqua studio 4.x free
version just doesn't run well on my Vista + Java(bad combination). DB
Visualizer personal edition is only 30 days and it can't even do
simple little things after the licence expired.
Suggestions please!

Thank you.

I've been using Advanced Query Tool (AQT) for some years. Two versions:
base is $150, DBA is $300. Less expensive than most. Runs only on
Windoze, but works with almost all databases. Runs some, not all, DB2
utilities natively; equally Oracle and SQLServer, though I've not used
them much. There is a trial version. Not sure whether the admin/DBA
parts are available there.

Sep 8 '07 #4

Vera.Kruglova

On Sep 8, 9:58 am, MeBuggyYouJane <gnuo...@rcn.comwrote:

Warren wrote:

Hi, DBAs and application developers out there,

which IDE is the best for DB2? I've been used to TOAD on Oracle, but
the new project uses DB2 and I hope to hear some good suggestions.

I've tried Toad for DB2 free, but it is buggy and hangs and disappears
out of nowhere when I run queries sometimes. Aqua studio 4.x free
version just doesn't run well on my Vista + Java(bad combination). DB
Visualizer personal edition is only 30 days and it can't even do
simple little things after the licence expired.
Suggestions please!

Thank you.

I've been using Advanced Query Tool (AQT) for some years. Two versions:
base is $150, DBA is $300. Less expensive than most. Runs only on
Windoze, but works with almost all databases. Runs some, not all, DB2
utilities natively; equally Oracle and SQLServer, though I've not used
them much. There is a trial version. Not sure whether the admin/DBA
parts are available there.

Try SqlDbx from www.sqldbx.com.

Sep 20 '07 #5

Warren

Thank you for all suggestions given.

I'll try these out.

Sep 20 '07 #6