RE: Where is all that CPU going?

One thing you are definitely looking at, is a too-short time span for any
realistic measure of what's going on. Use F5 instead of F10 until you get
at least 30 seconds of history. Even that is short, but it's MUCH better
than 0:00:02.

Performance tuning in general cannot be knee-jerk reaction, which short time
spans demands.

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"Democracy is the worst system devised by the wit of man, except for all the
others."
-- Winston Churchill

Thanks to all who suggested WRKSYSACT (I'd never heard of it, but the
customer has it).

As to high disk storage, it doesn't look like it; WRKSYSSTS shows the
system ASP at just under 51%

I don't see any difference from F14 on WRKACTJOB.

As to what WRKSYSACT shows, well, here's the top:

Elapsed time . . . . : 00:00:02 Average CPU util . . : 139.0
Number of CPUs . . . : 3 Maximum CPU util . . : 142.0
Overall DB CPU util : 13.3 Minimum CPU util . . : 136.4
Current processing capacity: 1.50

and no one job shows more than 6.2 for CPU Util.

But I'm not sure what I'm even looking at here.