DB2 SUBSYSTEM MONITOR

Mary Pickett

DB2 SUBSYSTEM MONITOR
Hello all,

We are looking for a good DB2 activity monitor and subsystem analyzer.
We are currently using BMC's Activity Monitor and for most things it has
worked very well. However we have recently implemented a Powerbuilder application
that replaces most of our Accounting and Project Management programs and
this has caused us to be running mostly dynamic SQL. We are experiencing
some performance problems and the tracing capabilities for dynamic SQL has
not been satisfactory with our current monitor. The operating system is OS390 and
we are on version 5.1 of DB2.

Thanks for your comments on any experience you have had with this type product.


Mary Ann
ALDOT

[login to unmask email]

Re: DB2 SUBSYSTEM MONITOR
(in response to Mary Pickett)
Detector and Subsystem Analyzer work well for finding and tuning
Dynamic SQL problems your applications may be having. They
can report on both static and dynamic SQL very easily. I think you
would be very happy Detector and Subsystem Analyzer.

If you would like more information please let me know, I can get you
in touch with the correct people.

-Rob Crane

Senior DBA CA/Platinum
---------------------- Forwarded by Rob Crane/Pti on 10/07/99 03:26 PM
---------------------------


Mary Ann Pickett <[login to unmask email]> on 10/07/99 02:54:33 PM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

To: [login to unmask email]
cc:
Subject: DB2 SUBSYSTEM MONITOR




Note: Some recipients have been dropped due to syntax errors.
Please refer to the "$AdditionalHeaders" item for the complete headers.



Hello all,

We are looking for a good DB2 activity monitor and subsystem analyzer.
We are currently using BMC's Activity Monitor and for most things it has
worked very well. However we have recently implemented a Powerbuilder
application
that replaces most of our Accounting and Project Management programs and
this has caused us to be running mostly dynamic SQL. We are experiencing
some performance problems and the tracing capabilities for dynamic SQL has
not been satisfactory with our current monitor. The operating system is
OS390 and
we are on version 5.1 of DB2.

Thanks for your comments on any experience you have had with this type
product.


Mary Ann
ALDOT