Home > IT Answers > Networking > Performance Tracking of Stored Procedures
Pcrum73
5 pts.
 Performance Tracking of Stored Procedures
Performance management, COBOL, Performance/Tuning, MIPS, Stored Procedures, .NET applications, CPU usage, COBOL 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: Feb 26, 2008  7:07 PM GMT
UPDATED: February 27, 2008  11:50:14 AM GMT
RELATED QUESTIONS
Bvining
5,870 pts.
Answer Wiki:
Not a general tool, but if you own the stored procedure and related subprograms then you might be interested in the Performance Explorer (PEX) APIs. 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 here. 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
http://www.brucevining.com/
Integrated solutions for the System i user community
Last Wiki Answer Submitted:  Feb 27, 2008  11:50 AM (GMT)  by  Bvining   5,870 pts.
To see other answers submitted to the Answer Wiki View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _