Re: RPG Program Profiling

["Rory Hewitt" <roryhewitt@xxxxxxxxx>]

Mihael,

In cases like these, I often find it's easiest to use TRCJOB. As long as you
output the results to a database file, you can run a query or SQL over it to
find out the information you need. I use the following statement in
interactive SQL:

"SELECT SCTIME, SCCPU, SCMODU,SCMODL, SCPROC,
SCEST1, SCEST2, SCEST3, SCXST1, SCXST2, SCXST3, SCLPRO, SCTHRD FROM
QGPL/TRCJOBOUTP ORDER BY SCCPU"

where QTEMP/TRCJOBOUTP is my TRCJOB output file. It's very good at
identifying any procedures which are consistently long-running

Rory