Possible to capture CPU Usage by User?

Just wondering if anyone knew a solution for this...

Have a Redhat server which has DB2 running on it. I have the sar stats being produced each day so I can see the total cpu, user, IO wait etc..

There are 3 main users on the system, a production account, a read only account used by the production system and a third account used to run reports.

What I want to do is capture similar stats (minimum would be the total) say every minute so I can determine how much of the total cpu each of the users is using. So I can confirm my suspicisions as to which is using the majority of the cpu.

Any ideas how to do this?

Thanks in advance

 

You could have a look at http://bashcurescancer.com/monitor-cpu-abusers-with-this-simple-script.html and perhaps poll every n minutes and record the output

 

Thanks for that, looks exactly like what I need.