DB2 SUBSYSTEM MONITOR -Reply

Jeff Schade

DB2 SUBSYSTEM MONITOR -Reply
I believe that BMC has an application monitor called
APPTUNE which would provide the SQL analysis you are
looking for but I have never seen it in action.

Jeff Schade
Publishers Clearing House
516-944-2673
[login to unmask email]

>>> Mary Ann Pickett <[login to unmask email]>
10/07/99 03:54pm >>>
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

Philip Gunning

Re: DB2 SUBSYSTEM MONITOR
(in response to Jeff Schade)
Mary Ann, We use Platinum Detector. We trialed BMC Apptune and Detector
and found them to both do a good job. We have VB, Powerbuilder, and
Peoplesoft and a tool to capture dynamic sql is a must. HTH Phil

Phil Gunning
Assoc List Owner
DB2 DBA
IBM Certified Solutions Expert -- DB2 UDB
IBM Certified Solutions Expert -- CICS TS

-----Original Message-----
From: Mary Ann Pickett [SMTP:[login to unmask email]
Sent: Thursday, October 07, 1999 3:55 PM
To: [login to unmask email]
Subject: 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
<< File: ATT00009.htm >>

Craig Mullins

Re: DB2 SUBSYSTEM MONITOR
(in response to Philip Gunning)
Mary Ann:

A good complement to BMC's Activity Monitor is BMC's Apptune solution.

APPTUNE quickly identifies the largest, resource-consuming,
performance-constrained
or error-prone SQL statements. It delivers a precise assessment of SQL
statement
performance by providing data that has been collected and correlated to the
time DB2
spent processing the SQL statement.

Apptune will work well to help you find and fix the problems you are having
with your
dynamic SQL (static SQL, too).

BMC has a white paper on DB2 performance tuning with Apptune at:
http://www.bmc.com/rs-bin/RightSite/getcontent/bmcdoc.html?dmw_objectid=0900
32018000163b&dmw_format=html

For more info on Apptune:
http://www.bmc.com/products/proddocview.html?id=2006&r=Americas&l=en

Craig S. Mullins
Director, DB2 Technology Planning
BMC Software
[login to unmask email]

<-------------------ORIGINAL MESSAGE FOLLOWS------------------->
To: [login to unmask email]
cc:
Subject: 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

Craig Mullins

Re: DB2 SUBSYSTEM MONITOR
(in response to Craig Mullins)
Mary Ann:

A good complement to BMC's Activity Monitor is BMC's Apptune solution.

APPTUNE quickly identifies the largest, resource-consuming,
performance-constrained or error-prone SQL statements. It delivers a precise
assessment of SQL statement performance by providing data that has been
collected and correlated to the time DB2 spent processing the SQL statement.

Apptune will work well to help you find and fix the problems you are having
with your dynamic SQL (static SQL, too).

BMC has a white paper on DB2 performance tuning with Apptune at:
http://www.bmc.com/rs-bin/RightSite/getcontent/bmcdoc.html?dmw_objectid=0900
32018000163b&dmw_format=html

For more info on Apptune:
http://www.bmc.com/products/proddocview.html?id=2006&r=Americas&l=en

Craig S. Mullins
Director, DB2 Technology Planning
BMC Software
[login to unmask email]

<-------------------ORIGINAL MESSAGE FOLLOWS------------------->
To: [login to unmask email]
cc:
Subject: 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

Gregg Willhoit

Re: DB2 SUBSYSTEM MONITOR
(in response to Craig Mullins)
Gregg [login to unmask email]
10/08/99 03:41 PM


Shadow Direct from NEON Systems (where I work) has a comprehensive
performance monitor built-in for Client/Server and Web applications. This
feature provides detailed tracing and diagnostic information on a
per-session and per-SQL statement basis. Using this facility, all of the
SQL, network I/O operations, buffers, etc. for one session and/or
application can be easily isolated and analyzed as need be. Precise CPU
time, Tiimeron, and clock time information is readily available.

The diagnostic, performance monitoring, and analysis facilities of Shadow
Direct are provide by an ISPF application, a Browser application, and/or a
Client/Server GUI application. All three interfaces can be used together if
need be. Detailed client-side tracing information is also available for
problem analysis/diagnosis if need be.

These tools have already been successfully used at the State of Alabama to
identify SQL hot spots and other potential problems. Using the
Shadow tools, a frequently executed CPU intensive 4-way join which returned
greater than 8,000 rows was identified.

Thank you

Gregg Willhoit


To: [login to unmask email]
cc: (bcc: Gregg Willhoit/Dev/Neon)
Subject: 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