BMC Apptune questions

Chad Walmer

BMC Apptune questions

I have a couple of questions for any current BMC Apptune users:

1. Do you use the sampling feature for collection of data? If so, have you
had any problems with missing SQL statements or SQL errors?

2. If you don't have sampling turned on, has the CPU overhead of the
product been a concern?



Please feel free to email me directly. TIA.



Chad Walmer

DB2 Systems Programmer

Rite Aid Corporation

(717) 730-7718




__________________________________________________________________________
Disclaimer: This e-mail message is intended only for the personal use of
the recipient(s) named above. If you are not an intended recipient, you
may not review, copy or distribute this message. If you have received this
communication in error, please notify us immediately by e-mail and delete
the original message.
This e-mail expresses views only of the sender, which are not to be
attributed to Rite Aid Corporation and may not be copied or distributed
without this statement.

---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

Paul Weissman

Re: BMC Apptune questions
(in response to Chad Walmer)
Chad,

We have BMC Apptune and have implemented sampling to reduce the CPU overhead. With sampling the traces are only turned on about 25% of the time. As a ROT, for frequently used SQL, the relative stats like CPU%, getpages per open, etc. are still reliable, but the "absolute" CPU-time, counts, etc. need to be multiplied by 4. It is quite possible to completely miss infrequent SQL errors or statements when sampling is turned on. It's a good tool but not a replacement for DB2 accounting, traces or a good error-handling routine.

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of Chad Walmer
Sent: Tuesday, December 30, 2003 3:50 PM
To: [login to unmask email]
Subject: BMC Apptune questions



I have a couple of questions for any current BMC Apptune users:

1. Do you use the sampling feature for collection of data? If so, have you had any problems with missing SQL statements or SQL errors?

2. If you don't have sampling turned on, has the CPU overhead of the product been a concern?



Please feel free to email me directly. TIA.



Chad Walmer

DB2 Systems Programmer

Rite Aid Corporation

(717) 730-7718




__________________________________________________________________________

Disclaimer: This e-mail message is intended only for the personal use of

the recipient(s) named above. If you are not an intended recipient, you

may not review, copy or distribute this message. If you have received this

communication in error, please notify us immediately by e-mail and delete

the original message.

This e-mail expresses views only of the sender, which are not to be

attributed to Rite Aid Corporation and may not be copied or distributed

without this statement.


--------------------------------------------------------------------------------- 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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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



Visit our website at http://www.ubs.com

This message contains confidential information and is intended only
for the individual named. If you are not the named addressee you
should not disseminate, distribute or copy this e-mail. Please
notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system.

E-mail transmission cannot be guaranteed to be secure or error-free
as information could be intercepted, corrupted, lost, destroyed,
arrive late or incomplete, or contain viruses. The sender therefore
does not accept liability for any errors or omissions in the contents
of this message which arise as a result of e-mail transmission. If
verification is required please request a hard-copy version. This
message is provided for informational purposes and should not be
construed as a solicitation or offer to buy or sell any securities or
related financial instruments.

---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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