3rd Party Tools

[SJD]

I am looking for a freeware, 3rd party tool that is similar to TOAD
for Oracle. Does anyone know of any good free alternatives to running
queries on the DB2 1st party software?

Thanks.

[Buck Nuggets]

la******@excite.com (SJD) wrote in message news:<a9*************************@posting.google.c om>...

I am looking for a freeware, 3rd party tool that is similar to TOAD
for Oracle.

Here are a few options for third-party tools, though I'm unaware of
any that are free. Anyhow, here's what I'm aware of:

high end: Quest Central (Toad Vendor) is really good, but also very
expensive (can cost between $2-15k / cpu, depending on server size,
os, etc)

middle end: Quest Central is also supposed to be offering Toad for
DB2 sometime over the next year last I heard. I think it runs around
$1500.

low end: Advanced Query Tool (http://www.querytool.com/) is
surprisingly good. I've just finished testing it out and now I'm
going to sign up for the regular license ($125). I'll probably
purchase another six tools for the rest of the team by the end of the
year. Anyhow, this tool is much better than the regular db2 fat
clients (and probably only cost 1/1000th as much to write)

buck

[Ian]

Buck Nuggets wrote:

la******@excite.com (SJD) wrote in message news:<a9*************************@posting.google.c om>...

I am looking for a freeware, 3rd party tool that is similar to TOAD
for Oracle.

Here are a few options for third-party tools, though I'm unaware of
any that are free. Anyhow, here's what I'm aware of:

high end: Quest Central (Toad Vendor) is really good, but also very
expensive (can cost between $2-15k / cpu, depending on server size,
os, etc)

middle end: Quest Central is also supposed to be offering Toad for
DB2 sometime over the next year last I heard. I think it runs around
$1500.

Quest also has a "freeware" version of Quest Central. I use quotes
around freeware because it has a license that expires every few months
and you must get a new key from Quest, but you don't have to pay for
it.

It, of course, does not have as many features as the full version.

Other tools:

Embarcadero DBArtisan is also very good, but expensive (I think it's
over $2k per seat, but it's been a while).

WinSQL (commercial) or WinSQL Lite (free) aren't bad
(http://www.synametrics.com).

If you're adventurous, you can use Eclipse (http://eclipse.org). There
are a number of Eclipse plugins (http://eclipse-plugins.2y.net) that
support DB2. This is free.

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

[Joachim Mueller]

Paul,

I have no luck o get the site:

The requested URL could not be retrieved

----------------------------------------------------------------------------
----

While trying to retrieve the URL: http://chuzhoi_files.tripod.com/index.html

The following error was encountered:

Unable to determine IP address from host name for chuzhoi_files.tripod.com
The dnsserver returned:

DNS Domain 'chuzhoi_files.tripod.com' is invalid: Non recoverable errors.
This means that:

The cache was not able to resolve the hostname presented in the URL.
Check if the address is correct.

Regards,
Joachim Müller

"Paul Vernon" <pa*********@ukk.ibmm.com
schrieb im Newsbeitrag news:c9**********@gazette.almaden.ibm.com...

"SJD" <la******@excite.com> wrote in message
news:a9*************************@posting.google.co m...

I am looking for a freeware, 3rd party tool that is similar to TOAD
for Oracle. Does anyone know of any good free alternatives to running
queries on the DB2 1st party software?

Thanks.

DB2 Monitor by Dmitri Liakh is free and well worth having in your tools
collection.

http://chuzhoi_files.tripod.com/

From the website

"Small DB2 performance monitoring program, shows active connections with
lock information, sqls in db cache, database snapshots, database objects
information, list history.
Can help resolve locking problems, identify worst performing queries.
Tested on, client - Win2k, server - UDB 7.2, 8.1 Win2k & AIX
License : freeware"

Regards
Paul Vernon
Business Intelligence, IBM Global Services

[Mark A]

> Paul,

I have no luck o get the site:

The requested URL could not be retrieved

-------------------------------------------------------------------------- -- ----

While trying to retrieve the URL: http://chuzhoi_files.tripod.com/index.html
The following error was encountered:

Unable to determine IP address from host name for chuzhoi_files.tripod.com
The dnsserver returned:

DNS Domain 'chuzhoi_files.tripod.com' is invalid: Non recoverable errors.
This means that:

The cache was not able to resolve the hostname presented in the URL.
Check if the address is correct.

Regards,
Joachim Müller

Try this site. I just checked and it is working from my location:
http://members.tripod.com/chuzhoi_files/index.html

[Joachim Mueller]

Paul and Mark A,

thanks a lot.

Regards,
Joachim Müller

Joachim Müller
"Mark A" <[e-mail]> schrieb im Newsbeitrag
news:Ok**************@news.uswest.net...

Paul,

I have no luck o get the site:

The requested URL could not be retrieved

--------------------------------------------------------------------------
--

----

While trying to retrieve the URL:

http://chuzhoi_files.tripod.com/index.html

The following error was encountered:

Unable to determine IP address from host name for chuzhoi_files.tripod.com The dnsserver returned:

DNS Domain 'chuzhoi_files.tripod.com' is invalid: Non recoverable errors. This means that:

The cache was not able to resolve the hostname presented in the URL.
Check if the address is correct.

Regards,
Joachim Müller

Try this site. I just checked and it is working from my location:
http://members.tripod.com/chuzhoi_files/index.html

[Sy Borg]

You may also want to tryout Embarcadero's DBArtisan
(www.embarcadero.com) - They were releasing a
performance/space/capacity monitoring module for DB2 EEE sometime
later this month. One of thier SCs did a web demo for us - at least
from what he showed us - it looked like it had a lot more metrics and
analysis (memory, history, utility execution etc ) than quest central.