RATE THIS ANSWER
0
Click to Vote:
- 0
0
Last Answered:
Feb 27 2008 11:50 AM GMT
by Bvining
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
COBOL, COBOL stored procedure, Performance/Tuning, Performance management, Stored procedures, CPU usage, MIPS, .NET application
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? 
