Shell Programming and Scripting

ps -eo pcpu,pid,comm | grep -i db2sysc | awk '{ SUM+=$1; } END { print SUM }'

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

ps --no-header -C db2sysc -o pcpu | awk ...

#! /bin/bash
#List processes based on %cpu and memory usage

echo "Start Time" `date`
# By default, it display the list of processes based on the cpu and memory usage #
if [ $# -eq 0 ]
then

    echo "List of processes based on the %cpu Usage"
    ps -e -o pcpu,cpu,nice,state,cputime,args --sort pcpu  # sorted based on %cpu
    echo "List of processes based on the memory Usage"
    ps -e -orss=,args= | sort -b -k1,1n # sorted bases rss value

# If arguements are given (mem/cpu)
else
    case "$1" in
    mem)
     echo "List of processes based on the memory Usage"
      ps -e -orss=,args= | sort -b -k1,1n
     ;;
     cpu)
     echo "List of processes based on the %cpu Usage"
     ps -e -o pcpu,cpu,nice,state,cputime,args --sort pcpu
     ;;
     *)
        echo "Invalid Argument Given \n"
        echo "Usage : $0 mem/cpu"
        exit 1
     esac    

fi
echo "End Time" `date`
exit 0

Name            PID  CPU%  PgSp Owner
db2sysc      430216  44.3  20.7 db2pep
db2sysc     4124690   6.8  23.8 db2pep
db2sysc     2568260   2.3  18.9 db2pep
db2sysc     1433794   2.0  19.5 db2pep
db2sysc     3211462   1.5  23.5 db2pep
db2sysc     1847436   1.1  17.7 db2pep
db2sysc     2162884   0.8  19.6 db2pep
db2sysc     2048248   0.6   1.5 db2pep
db2sysc     1884282   0.5  21.4 db2pep
db2sysc     1359954   0.5  13.9 db2pep
db2sysc     1810564   0.5   1.5 db2pep

ps -e -o pcpu,cpu,nice,state,cputime,args | grep -i db2agent | awk '{ SUM+=$1; } END { print SUM }'
18.5

prstat -a 1 1 | grep <dba group> | tail -1