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.
Integrated solutions for the System i user community