Performance Tracking of Stored Procedures

5 pts.
Tags:
.NET applications
COBOL
COBOL stored procedures
CPU usage
MIPS
Performance management
Performance/Tuning
Stored Procedures
we have a current system where a COBOL stored procedure is called by a .NET application. This COBOL SP then calls multiple COBOL subprograms which perform calculations and update files and then eventually return a value to the .NET app. We have a limitation in tracking the performance of each called subprogram, due to the CPU usage being lumped together for the entire DB2 thread started by the SP. Does anyone know of a way, or a tool that can show the CPU usage of all called programs from the SP?
ASKED: February 26, 2008  7:07 PM
UPDATED: February 27, 2008  11:50 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Not a general tool, but if you own the stored procedure and related subprograms then you might be interested in the <a href=”http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/apis/perfmgmt_pex.htm”>Performance Explorer (PEX) APIs</a>. These APIs allow you to capture application related performance data at points in the application that you choose and, as a “free” side benefit, also system tracked performance data — like CPU usage, IO activity, etc.

You can find some examples (RPG, CL, and COBOL) in my COMMON 2007 presentation Integrating Serviceability Into Your ILE Applications <a href=”http://www.brucevining.com/Presentations/LandingPresentations2.html”>here</a>. I do have an updated presentation that includes V6R1 content that will be available shortly, but the V6R1 changes are related to Watches and Tracing, not PEX.

Bruce Vining
<a href=”http://www.brucevining.com/”>http://www.brucevining.com/</a>
Integrated solutions for the System i user community

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following