adilsonrapozojr
2/10/2020 - 6:07 PM

Db2 top 5 cpu consuming app

while read -r p; do

valor=`echo $p | awk '{print $2}'`;
id=`echo $p | awk '{print $1}'`;
id=`echo $p | awk '{print $1}'`;
app=`echo "$p" | awk '{print $3}' | awk '$0 ~ /db2bm/ {print "backup"; next} $0 ~ /db2agent/ {print "agent"; next} {print "?"}'`;
[ "$app" == "agent" ] && app="apphandl("`db2pd -d asset -appl agent=$id | awk 'NR==6 {print $2}'`")";
echo "$app - $valor" ;

done < <(db2pd -edus interval=5 top=5 | awk -F '[[:space:]][[:space:]]+' 'NR>11 {print $1,$5,$4}' | sort -k2 -nr)