chkagdict

ksh 实现的基于hpux下的性能数据以及故障的采集程序。可以作为新手练手使用

#!/bin/ksh

MYPATH=$HOME/dbadmin

rm -f $MYPATH/tmp.dat $MYPATH/dict.tmp $MYPATH/agent.dat

#将dict.dat空行和注释行过滤掉,生成一个临时文件
echo "正在生成不含注释行的数据字典文件"
seq=0
while read t1
do
   if [[ `expr length "$t1"` = 0 || `expr index "$t1" \#` = 1 ]] then
      continue
   else
     seq=`expr $seq + 1`
     echo $seq $t1 >> $MYPATH/dict.tmp
   fi
done < $HOME/dict/dict.dat
echo "不含注释行的数据字典文件生成完毕"

num=0
for f1 in `ls $MYPATH/*.txt`
do
   while read s1 s2
   do
      if [[ ${#s1} = 0 ]] then 
         continue
      fi

      if [ `expr index "$s1" \#` -eq 1 ]; then
         continue
      fi

      lookup2 $s1 "$MYPATH/dict.tmp" >> $MYPATH/tmp.dat
   done < $f1

   file=`basename $f1`;

   tab=`expr $file : '\(.*\)\..*'`;

   let num=$num+1;
   echo "table[$num] $tab has been checked"
done

echo "$num tables has all been checked!"

sort -n $MYPATH/tmp.dat | uniq > $MYPATH/agent.dat

rm -f $MYPATH/tmp.dat $MYPATH/dict.tmp