BMC Apptune questions

Chad Walmer

BMC Apptune questions

Thanks Paul for the feedback. My main concern about sampling is the
possibility of missing SQL errors. As you stated, good error handling
routines should eliminate this need but we can’t (shouldn’t?) rely on the
developers to handle all errors and log them appropriately. We still use CA
Detector for one of our data sharing groups and have relied on this product
to provide SQL errors. Without these types of products, we would need to
turn on some expensive SQL performance traces to get all SQL codes unless we
could absolutely, 100%, rely on the application to log any DB2 errors it
encounters.



One other drawback which you alluded to below relates to the accounting
data. We do collect statistic and accounting data and store it in DB2
tables for historical purposes but we have relied on Detector (and now
Apptune) to provide package level detail that is only currently available at
the plan level using DB2 traces alone. We predominantly use packages
running under a couple of plans in CICS which makes it difficult to track
changes other than CPU and wait times (no details for buffer pools, SQL,
locks, etc.) Granted that sampling will still give us ¼ of the data that we
need, but it is not a complete picture of what is going on. I have also
heard that the package level accounting traces will include many of the plan
level fields in version 8, but as we are only converting to V7 now, I don’t
believe this will help us anytime soon.



Chad



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of [login to unmask email]
Sent: Wednesday, December 31, 2003 9:42 AM
To: [login to unmask email]
Subject: Re: BMC Apptune questions



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



----------------------------------------------------------------------------
----- 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

__________________________________________________________________________
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