DB2 V7 on Z/OS Monitoring tools comparison

Vamsi Gonella

DB2 V7 on Z/OS Monitoring tools comparison
Esteemed Listers,

We are DB2 V7 on Z./OS.

Could any one please share their experience (comparisons, advantages, over heads and s/w issues etc) with monitoring tools TMON DB2 V4.0 vs IBM PM vs BMC Apptune.


Thanks in advance,
Vamsi


***********************************************************************
This e-mail and any files transmitted with it are intended
solely for the use of the addressee. This e-mail may
contain confidential and/or legally privileged information.
Any review, transmission, disclosure, copying, or any action
taken or not taken, by other than the intended recipient, in
reliance on the information, is prohibited. If you received
this e-mail in error, notify the sender and delete this e-mail
(and any accompanying material) from your computer and
network. In addition, please be advised that 21st Century
Insurance Group reserves the right to monitor, access and
review all messages, data and images transmitted through
our electronic mail system. By using our e-mail system, you
consent to this monitoring.
***********************************************************************


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Avram Friedman

Re: DB2 V7 on Z/OS Monitoring tools comparison
(in response to Vamsi Gonella)
First off your list is not fair
BMC APPTUNE is a different sort of product than TMON or PM.
APPTUNE is a DB2 SQL analyzer. TMON and PM monitor the entire DB2
environment.
If you choose to be fair replace APPTUNE with MAINVIEW.
There are also fine products from other vendors like Candle (now part of
IBM) and CA.

All products rely mostly on DB2 trace data so in theory all provide the
same basic functionality and the same basic weakness. They are
dependent on the health of DB2 to do there job ... That is at the time
you need them the most (DB2 is sick) they will do you the least good.
In spite of this most shops should have products in this class.

Products can be evaluated on the basis of many criteria
1. Cost
2. Vendor support
3. Ease of use
4. Exception support
5. Near term history
6. Long term history
7. Overhead
8. Special trace availability
9. extensions in to non monitoring areas (examples DDL, Explain)
10. Compatibility with a broader family of products both DB2 and non DB2
(MVS CICS etc) related
11. etc

Your general question is a bit to general to answer.
Any area you would like to concentrate on, for example "Who has the
best active thread display?"

_____

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Gonella, Vamsi
Sent: Tuesday, December 14, 2004 2:35 PM
To: [login to unmask email]
Subject: DB2 V7 on Z/OS Monitoring tools comparison


Esteemed Listers,

We are DB2 V7 on Z./OS.

Could any one please share their experience (comparisons, advantages,
over heads and s/w issues etc) with monitoring tools TMON DB2 V4.0 vs
IBM PM vs BMC Apptune.


Thanks in advance,
Vamsi


***********************************************************************
This e-mail and any files transmitted with it are intended
solely for the use of the addressee. This e-mail may
contain confidential and/or legally privileged information.
Any review, transmission, disclosure, copying, or any action
taken or not taken, by other than the intended recipient, in
reliance on the information, is prohibited. If you received
this e-mail in error, notify the sender and delete this e-mail
(and any accompanying material) from your computer and
network. In addition, please be advised that 21st Century
Insurance Group reserves the right to monitor, access and
review all messages, data and images transmitted through
our electronic mail system. By using our e-mail system, you
consent to this monitoring.
***********************************************************************
------------------------------------------------------------------------
--------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the
archives and home page at http://www.idugdb2-l.org/archives/db2-l.html.
From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm
--------------------------------------------------------

NOTICE: If received in error, please destroy and notify sender. Sender does not waive confidentiality or privilege, and use is prohibited.


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

DB2-L

Re: DB2 V7 on Z/OS Monitoring tools comparison
(in response to Avram Friedman)
Thread/STOPPER from my company, RAI, allows you to display and cancel
threads even if DB2 is not fully operational.

Steve Gold
RAI
https://www.relarc.com

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]
On Behalf Of Friedman, Avram (IT)
Sent: Tuesday, December 14, 2004 2:53 PM
To: [login to unmask email]
Subject: Re: DB2 V7 on Z/OS Monitoring tools comparison


First off your list is not fair
BMC APPTUNE is a different sort of product than TMON or PM.
APPTUNE is a DB2 SQL analyzer. TMON and PM monitor the entire
DB2 environment.
If you choose to be fair replace APPTUNE with MAINVIEW.
There are also fine products from other vendors like Candle (now
part of IBM) and CA.

All products rely mostly on DB2 trace data so in theory all
provide the same basic functionality and the same basic weakness. They
are dependent on the health of DB2 to do there job ... That is at the
time you need them the most (DB2 is sick) they will do you the least
good. In spite of this most shops should have products in this class.

Products can be evaluated on the basis of many criteria
1. Cost
2. Vendor support
3. Ease of use
4. Exception support
5. Near term history
6. Long term history
7. Overhead
8. Special trace availability
9. extensions in to non monitoring areas (examples DDL, Explain)
10. Compatibility with a broader family of products both DB2 and
non DB2 (MVS CICS etc) related
11. etc

Your general question is a bit to general to answer.
Any area you would like to concentrate on, for example "Who
has the best active thread display?"

________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email]
On Behalf Of Gonella, Vamsi
Sent: Tuesday, December 14, 2004 2:35 PM
To: [login to unmask email]
Subject: DB2 V7 on Z/OS Monitoring tools comparison



Esteemed Listers,

We are DB2 V7 on Z./OS.

Could any one please share their experience (comparisons,
advantages, over heads and s/w issues etc) with monitoring tools TMON
DB2 V4.0 vs IBM PM vs BMC Apptune.


Thanks in advance,
Vamsi



***********************************************************************
This e-mail and any files transmitted with it are intended
solely for the use of the addressee. This e-mail may
contain confidential and/or legally privileged information.
Any review, transmission, disclosure, copying, or any action
taken or not taken, by other than the intended recipient, in
reliance on the information, is prohibited. If you received
this e-mail in error, notify the sender and delete this e-mail
(and any accompanying material) from your computer and
network. In addition, please be advised that 21st Century
Insurance Group reserves the right to monitor, access and
review all messages, data and images transmitted through
our electronic mail system. By using our e-mail system, you
consent to this monitoring.

***********************************************************************

------------------------------------------------------------------------
--------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the
archives and home page at http://www.idugdb2-l.org/archives/db2-l.html.
From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm
________________________________


NOTICE: If received in error, please destroy and notify sender.
Sender does not waive confidentiality or privilege, and use is
prohibited.


------------------------------------------------------------------------
--------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the
archives and home page at http://www.idugdb2-l.org/archives/db2-l.html.
From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

jwkwan2000

Re: DB2 V7 on Z/OS Monitoring tools comparison
(in response to DB2-L)
Vamsi,

You should be comparing IBM Query Monitor against BMC Apptune instead of using TMON.

James Kwan
----- Original Message -----
From: Gonella, Vamsi
Newsgroups: bit.listserv.db2-l
To: [login to unmask email]
Sent: Tuesday, December 14, 2004 1:34 PM
Subject: DB2 V7 on Z/OS Monitoring tools comparison


Esteemed Listers,

We are DB2 V7 on Z./OS.

Could any one please share their experience (comparisons, advantages, over heads and s/w issues etc) with monitoring tools TMON DB2 V4.0 vs IBM PM vs BMC Apptune.


Thanks in advance,
Vamsi


***********************************************************************
This e-mail and any files transmitted with it are intended
solely for the use of the addressee. This e-mail may
contain confidential and/or legally privileged information.
Any review, transmission, disclosure, copying, or any action
taken or not taken, by other than the intended recipient, in
reliance on the information, is prohibited. If you received
this e-mail in error, notify the sender and delete this e-mail
(and any accompanying material) from your computer and
network. In addition, please be advised that 21st Century
Insurance Group reserves the right to monitor, access and
review all messages, data and images transmitted through
our electronic mail system. By using our e-mail system, you
consent to this monitoring.
***********************************************************************
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm