Need Help Interpreting TPROF Reports

[dnepr]

Has anyone had any experience interpreting the various TPROF reports? We are running Sybase and we have a job that appears to be CPU bound, but I suspect that other things are using the CPU besides 'real' work due to low I/O time.

We are on an S80 with 18 CPU's and 16 gb of RAM and AIX 4.3.3.9.

I understand the prof.all report, but the other reports (like tmp.k) are 'Greek' to me.

How do I interpret these detailed reports? There is nothing specific in MAN pages or in the IBM performance and tuning quide.

Thanks in advance, Steve

 

[nwardez]

Hi,

Maybe it can help you:

http://publibn.boulder.ibm.com/doc_link/en_US/a_doc_lib/aixbman/prftungd/prftungd02.htm#ToC

 

[aixat]

Hello,
lslpp -l bos.rte.libc and lslpp -l bos.rte.libpthread.
if this at 4.3.3.75 then update to latest level.

It will fix the problem you see.

 

[dnepr]

I upgraded to ML 4.3.3.10 which upgraded my libc and libpthreads. We reran the test, and saw no difference in performance (decreased by 50 seconds over 1+ hours). Any other suggestions?