Performance Tracking of Stored Procedures
.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?
Software/Hardware used:
Software/Hardware used:
ASKED:
February 26, 2008 7:07 PM
UPDATED:
February 27, 2008 11:50 AM
Answer Wiki:
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
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
