Originally posted by: niteshtheone

Hi,

I am trying to write a script which will fire alert mail to dba ( db2dba) when there process will
utilize CPU more than 90%. But I am unable to do so.

I am using following command to calucate CPU utilization be db2sysc process :
ps -eo pcpu,pid,comm | grep -i db2sysc | awk '{ SUM+=$1; } END { print SUM }'

But Result of above formula and topas output are not same its always different.
like I am finding from ps -eo , are you having any similar kind of command
=================
bash-3.2$ date
Tue Dec 13 22:39:53 PST 2011
bash-3.2$ ps -eo pcpu,pid,comm | grep -i db2sysc | awk '{ SUM+=$1; } END { print SUM }'
20
=================
Topas at this particular time (Tue Dec 13 22:39:53 PST 2011) is displaying 53% is utilized by db2sysc process.

So please let me know from where I can find correct real time CPU utilization of db2sysc process.
#AIX-Forum

Originally posted by: SystemAdmin

The ps command is pretty useless when running in a virtualized environment, I tend to rely on nmon when doing performance troubleshooting in AIX.
#AIX-Forum

Originally posted by: niteshtheone

I am a db2 dba... we dont have any access to nmon.
So I cant use nmon. There is any other way to get exact utilization ?
( what command TOPAS use in backupground to identify top 10 cpu utilized query ? )
#AIX-Forum

Originally posted by: DjRobin69

ps aug
#AIX-Forum

Originally posted by: DjRobin69

for top 10
ps aug | sort -rnk 3 | head -10
third column is cpu
#AIX-Forum

Originally posted by: niteshtheone

Any PS command option use to behave same.
I mean to say its output is always different compare to topas output.
So If you have any other solution please provide me information regarding that.
#AIX-Forum