What are DB2 people using for a query tool?

chulett · Post by **chulett** » Tue May 11, 2010 9:48 am

Just wondering as DB2 will be a new source for everyone here and getting software approved is a long and arduous process. So, I know most clients come with their own tools, like sqlplus for Oracle, and Toad probably has a 'for DB2' version but wondering what else might be out there that people have used and would recommend?

Thanks!

IBM Analytics Champion 2009 - 2020 · Post by **asorrell** » Tue May 11, 2010 9:59 am

Toad for DB2 is VERY nice and has a lot of add-on packages that do very neat stuff. Highly recommended.

Note: Serious $

Quick and Easy? Free? QTODBC. Not so Neat. Good price.

chulett · Post by **chulett** » Tue May 11, 2010 10:35 am

Cool, thanks. Trying to find out what "they" are currently using, other than "Business Objects" which is the answer I've gotten so far.

MT · Post by MT » Tue May 11, 2010 11:26 am

Hi chulett,

I use DB2 own tools like Command Editor most of the time but it is not longer strategic - even deprecated. IBM suggests DataStudio (eclipse) which is free (there are also OPTIM tools which are not free but based on the same plattform) and has some neat features.

A very nice non-IBM tool is AQT - not free but very flexible and powerful...
You can check it out on
www.querytool.com/

kind regards
Michael

chulett · Post by **chulett** » Tue May 11, 2010 1:24 pm

Thanks!

ray.wurlod · Post by **ray.wurlod** » Tue May 11, 2010 4:41 pm

DB2 Control Center (which installs from the DB2 client software media) or DB2 Data Studio - the newer tool. Both support through to DB2 v9.7, which is the version of InfoSphere Warehouse.

munch9 · Post by **munch9** » Wed May 12, 2010 4:38 am

Aqua data studio is used by a number of people here.

http://www.aquafold.com/

It has all the basic features and works with lots of rdbms's. Looking at the site there are newer versions available than the one we have so i guess more features too.

Not sure about the cost for licenses but they are all available for free evaluation.

kduke · Post by **kduke** » Wed May 12, 2010 3:02 pm

A lot of DB2 sites have Teradata. I used its client a lot of places.

Terala · Post by **Terala** » Wed May 12, 2010 3:48 pm

AQT - Advance Query Tool.
Toad for DB2

chulett · Post by **chulett** » Wed May 12, 2010 5:51 pm

No TeraData here, not sure if that's good or bad.

Thanks for all the suggestions, we'll see what comes of all this.

vivekgadwal · Post by **vivekgadwal** » Fri May 14, 2010 1:31 pm

chulett wrote:No TeraData here, not sure if that's good or bad.

Thanks for all the suggestions, we'll see what comes of all this.

Craig,

We use DB Visualizer, which is available for FREE as well as for paid. It uses JDBC drivers and it is a decent tool that is available for FREE. You can also try their evaluation license which is valid for 26 days to see if you are interested in their full version.

Toad for DB2 is a decent one, although the one I used before was kind of buggy.

- Vivek.

chulett · Post by **chulett** » Fri May 14, 2010 9:01 pm

Thanks. Problem I'm finding is that working for the Gov't on a GI laptop means the only software that can be installed is something from their 'approved list'. And it's not a long list. And my pc is locked down so tight, not only can I not install any software on my own, I can't plug in a flashdrive nor edit any file I did not create myself. Loverly.

So now we're trying to find out what is "approved" that they'll let us have.

ray.wurlod · Post by **ray.wurlod** » Fri May 14, 2010 9:20 pm

In the same boat, but working for some high powered (three star) officers, so slightly better chance of getting things approved. Like Information Server client, for example. (Sheesh.)

However, we DO have both Control Center and its younger cousin Data Studio installed.

vivekgadwal · Post by **vivekgadwal** » Sat May 15, 2010 9:05 am

chulett wrote:Thanks. Problem I'm finding is that working for the Gov't on a GI laptop means the only software that can be installed is something from their 'approved list'. And it's not a long list. And my pc is locked down so tight, not only can I not install any software on my own, I can't plug in a flashdrive nor edit any file I did not create myself. Loverly.

So now we're trying to find out what is "approved" that they'll let us have.

Hmm...then I guess you might be stuck with using DB2 native Command line tools. Good luck with that!

chulett · Post by **chulett** » Sat May 15, 2010 10:29 am

Ummm... yah. Thanks. I'll let you know.

DSXchange

What are DB2 people using for a query tool?

What are DB2 people using for a query tool?

Re: What are DB2 people using for a query tool?