DB2-日常巡检-查看latch

#DB2-日常巡检-查看latch
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 >/dev/null 
#SCPIPT     if [ $? -eq 0 ];then
#SCPIPT         db2pd -d  $i -latch|grep "SQLO_LT_sqe"|while read line
#SCPIPT         do
#SCPIPT                 Wait_num=$(echo ${line}|awk '{print $3}');
#SCPIPT                 Holder_num=$(echo ${line}|awk '{print $2}');
#SCPIPT                 if [ "${Wait_num}" == "0" -a "${Holder_num}" == "0" ];then
#SCPIPT                         echo "ERROR|${i}|${line}">>$1
#SCPIPT                 else
#SCPIPT                         echo "NORMAL|${i}|${line}">>$1<