SQL monitor software for DB2 on z/OS

Fred Edgar

SQL monitor software for DB2 on z/OS
All,

We're looking to maybe replace our current software and wondering what
people are recommending these days. Who has the best? Best value?

I appreciate any/all suggestions. Offline or online, whichever you prefer.

Thanks,
Fred


____________________________________________________________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Avram Friedman

Re: SQL monitor software for DB2 on z/OS
(in response to Fred Edgar)
If I might ask a few questions

1) Monitor just SQL and / or other stuff like Buffers, Response time etc?
2) What platform? (There is a suggested listserv protocall that says platform
should be the first key word in the subject line)
3) Real Time, Near Real Time, Historical, and / or predictive?
4) Static or Dyanamic SQL?
5) Monitor selected workloads on demand or all work?
6) Realitive Expertise of the users of the monitor.
7) In general why are you considering replacing your currently solution (no
obligation to identify the solution if you don't want too)

There is a long tradition of people asking for product recommendations. There
are lots of considerations that go beyond the technical bells and wissels. I
would just reviewing Craig Mullin's paper on choosing a software vendor
Here is a link http://www.craigsmullins.com/zjdp_016.htm

Best Wishes
Avram Friedman

On Tue, 8 Jan 2008 08:44:01 -0800, [login to unmask email] wrote:

>All,
>
>We're looking to maybe replace our current software and wondering what
>people are recommending these days. Who has the best? Best value?
>
>I appreciate any/all suggestions. Offline or online, whichever you prefer.
>
>Thanks,
>Fred
>
>
>
__________________________________________________________________
__________________
>Looking for last minute shopping deals?
>Find them fast with Yahoo! Search.
http://tools.search.yahoo.com/newsearch/category.php?category=shopping
>
>The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list
archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug
under the Listserv tab. While at the site, you can also access the IDUG
Online Learning Center, Tech Library and Code Place, see the latest IDUG
conference information, and much more. If you have not yet signed up for
Basic Membership in IDUG, available at no cost, click on Member Services at
http://www.idug.org/lsms

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Fred Edgar

Re: SQL monitor software for DB2 on z/OS
(in response to Avram Friedman)
Avram,
Sorry I didn't see your reply earlier. I've placed my answer after each
question.

Thanks,
Fred

--- Avram Friedman <[login to unmask email]> wrote:

> If I might ask a few questions
>
> 1) Monitor just SQL and / or other stuff like Buffers, Response time etc?

Mostly SQL.

> 2) What platform? (There is a suggested listserv protocall that says
> platform
> should be the first key word in the subject line)

Sorry I put it at the end of the subject line instead of the beginning. At
least it's there (unlike most posts). Sue me. <g>

> 3) Real Time, Near Real Time, Historical, and / or predictive?

Mainly interested in Near Real Time and maybe a weeks worth of History.

> 4) Static or Dyanamic SQL?

Both.

> 5) Monitor selected workloads on demand or all work?

All work.

> 6) Realitive Expertise of the users of the monitor.

From neophytes to experts, but more interested in helpful information being
there than a pretty interface.

> 7) In general why are you considering replacing your currently solution (no
> obligation to identify the solution if you don't want too)

It has crashed our DB2 subsystem multiple times and high CPU overhead are the
2 main reasons.

>
> There is a long tradition of people asking for product recommendations.
> There
> are lots of considerations that go beyond the technical bells and wissels. I
>
> would just reviewing Craig Mullin's paper on choosing a software vendor
> Here is a link http://www.craigsmullins.com/zjdp_016.htm
>
> Best Wishes
> Avram Friedman
>
> On Tue, 8 Jan 2008 08:44:01 -0800, [login to unmask email] wrote:
>
> >All,
> >
> >We're looking to maybe replace our current software and wondering what
> >people are recommending these days. Who has the best? Best value?
> >
> >I appreciate any/all suggestions. Offline or online, whichever you prefer.



____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms