DB2-日常巡检-查看锁等待

#DB2-日常巡检-查看锁等待
date=$(date +%Y%m%d%H%M%S)
log=/tmp/db_EVO_DB2_CHECK${date}.txt
rm -f ${log}
#SCPIPT dbname=`db2 list db directory |grep "Database name" |awk '{print $4}'`
#SCPIPT for i in ${dbname}
#SCPIPT do
#SCPIPT     db2 connect to $i 1>/dev/null 2>&1
#SCPIPT     if [ $? -eq 0 ];then
#SCPIPT         info=$(db2pd -d  $i -wlock |grep -v "Database $i"|tr -s '\n')
#SCPIPT         if [ -z "$info" ];then
#SCPIPT             echo "NORMAL|$i|无锁等待">>$1
#SCPIPT         else
#SCPIPT             echo "ERROR|$i|$info">>$1
#SCPIPT         fi
#SCPIPT     else
#SCPIPT         echo "ERROR|${i}|数据库连接失败">>$1
#SCPIPT     fi
#SCPIPT done
grep '^#SCPIPT' $0 | sed 's/#SCPIPT //g' >/tmp/db_$$.sh;chmod 777 /tmp/db_$$.sh
touch ${log};chmod 777 ${log}
for dbuser in `ps -ef | grep db2sysc |grep -v grep | awk '{print $1}'`
do
        su - $dbuser -c "/tmp/db_$$.sh ${log}">/dev/null
done
cat ${log}
rm -f /tmp/db_$$.sh
rm -f ${log}