RE: Program profiling

Jevgeni,

I have a tool similar to iDoctor JobWatcher - it collects
"snapshot"-type statistics that you can later analyse. The tool is free;
however, it does not have a front-end, so you'll have to run queries to
find out what's going on, but it's relatively straightforward; if you're
interested you can contact me offline.

One obvioius question is whether you use native I/O or SQL. For if it's
SQL, you can then use SQL monitor (from OpsNav) to collect the SQL
trace. I would not expect too much from an SQL trace, but that at least
would be something. Yet another option would be PEX program profiling,
but it's not particularly useful for this type of analysis. Nor is it
particularly well described in the Performance Tools manual.

Lo

-----Original Message-----
From: Jevgeni Astanovski [mailto:J.Astanovski@xxxxxxxxxxxx]
Sent: Thursday, May 06, 2004 4:49 PM
To: C400-L@xxxxxxxxxxxx
Subject: [C400-L] Program profiling


Some help from skilled professionals is badly needed :-(
I've got a ILE/C program (wrote myself), that makes some pretty
complicated data base processing. And it is somehow too-oo-ooooo slow. I
suspected some pieces of code, applied some optimization to it, but
without real effect. 

It is still slow.

What I'd like to do is to make some profiling - for example at function
call level. It would at least allow me to concentrate on the bottleneck
and not to spend time on unimportant code.

Never did that in this environment. Can someone direct me to a simple
guide on how to apply and analyze profiling data?

TIA,

Jevgeni Astanovski
Sampo Bank,
Tallinn, Estonia.

_______________________________________________
This is the C programming iSeries / AS400 (C400-L) mailing list
To post a message email: C400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/c400-l
or email: C400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/c400-l.