By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,925 Members | 1,778 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,925 IT Pros & Developers. It's quick & easy.

DB2 database IDE

P: n/a
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
Share this Question
Share on Google+
5 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
Thank you for all suggestions given.

I'll try these out.

Sep 20 '07 #6

This discussion thread is closed

Replies have been disabled for this discussion.