Shell script

erp check shell-070215

efrit 2007. 3. 16. 14:49

################################################
erpchk.sh
################################################

#./erpchk 2> /dev/null 1>/dev/null
/tmp/syschk/erpwas_chk 2>1 > /dev/null
rsh erpwas2 /tmp/syschk/erpwas_chk 2 >1 >/dev/null
rsh erptmax1 /tmp/syschk/erptmax_chk 2>1 >/dev/null
rsh erptmax2 /tmp/syschk/erptmax_chk 2>1 >/dev/null
rsh erpdb /tmp/syschk/erpdb_chk 2>1 >/dev/null
#sleep 3
clear
echo "1:erpwas  2:erptmax  3:erpdb  4:exit"

logdir="/tmp/syschk/erp"
while true
do
read a

case $a in
1 )
clear
echo "#### erpwas1 ####"
http=`head -1 $logdir/erpwas1.log`
echo "[http]   :  "$http
web=`tail -1 $logdir/erpwas1.log`
echo "[WebSphere] : "$web

echo ""
echo "#### erpwas2 ####"
http=`head -1 $logdir/erpwas2.log`
echo "[http]   :  "$http
web=`tail -1 $logdir/erpwas2.log`
echo "[WebSphere] : "$web
;;
2 )
clear
echo "#### erptmax1 ####                               #### erptmax2 ####"
cat $logdir/erptmax1.log

#echo "#### erptmax2 ####"
#cat $logdir/erptmax2.log
;;
3 )
clear
echo "#### erpdb ####"
cat $logdir/erpdb.log
;;
4 )
exit
;;
esac
echo ""
echo "1:erpwas  2:erptmax  3:erpdb  4:exit"
done



################################################
erpwas_chk
################################################

host=`hostname`

ps -ef|grep IBMHttp|grep -v grep|wc -l > /tmp/syschk/$host.log
ps -ef|grep java|grep -v grep|wc -l >> /tmp/syschk/$host.log

###### erpwas1은 없음 ###
cd /tmp/syschk
ftp -n erpwas1 << END
user root sysmaster

cd /tmp/syschk/erp
put $host.log

bye
END

rm -f $host.log



################################################
erptmax_chk
################################################
#!/bin/sh
host=`hostname`
dir="/tmp/syschk"
log=$dir/$host.log

####### racd check #######
echo "---- racd ----" > $log
racd_id=`ps -ef|grep racd|grep -v grep|awk '{print $1}'`
racd_no=`ps -ef|grep racd|grep -v grep|wc -l`
t2_racdid=`rsh erptmax2 ps -ef|grep racd|grep -v grep|awk '{print $1}'`
t2_racdno=`rsh erptmax2 ps -ef|grep racd|grep -v grep|wc -l`
echo "racd : "$racd_no " ( "$racd_id" )                      racd : "$t2_racdno" ( "$t2_racdid" )" >> $log

####### checkproc process ( tmm, cl, cll, tms ) check ######
echo "---- chkproc ----" >> $log

#touch $dir/t1
#for t in tmm cll clh
#do
#  a=`ps -ef|grep $t|grep -v grep|awk -F: '{print $2}'|head -1|cut -c 4-`
#  a_no=`ps -ef|grep $t|grep -v grep|awk -F: '{print $2}'|cut -c 4-|wc -l`
#  a_id=`ps -ef|grep $t|grep -v grep|awk '{print $1}'`
#  b=`rsh erptmax2 ps -ef|grep $t|grep -v grep|awk -F: '{print $2}'|head -1|cut -c 4-`
#  b_no=`rsh erptmax2 ps -ef|grep $t|grep -v grep|awk -F: '{print $2}'|cut -c 4-|wc -l`
#  b_id=`ps -ef|grep $t|grep -v grep|awk '{print $1}'`
#  echo $a_id" "$a":"$a_no"  "$b_id" "$b":"$b_no >> $dir/t1
#done

#### tmm cll clh (070504)
touch $dir/ps

for t in tmm cll clh
do
        a_ps=`ps -ef|grep $t|grep -v grep|head -1|sed "s/://g"|awk -F"-" '{print $2,$3,$4}'|cut -c 7-`
        a_id=`ps -ef|grep $t|grep -v grep|awk '{print $1}'`
        a_no=`ps -ef|grep $t|grep -v grep|sed "s/://g"|awk -F"-" '{print $2,$3,$4}'|cut -c 7-|wc -l`

        b_ps=`rsh erptmax2 ps -ef|grep $t|grep -v grep|head -1|sed "s/://g"|awk -F"-" '{print $2,$3,$4}'|cut -c 7-`
        b_id=`rsh erptmax2 ps -ef|grep $t|grep -v grep|awk '{print $1}'`
        b_no=`rsh erptmax2 ps -ef|grep $t|grep -v grep|sed "s/://g"|awk -F"-" '{print $2,$3,$4}'|cut -c 7-|wc -l`

        echo $a_id" : "$a_ps" : "$a_no"    "$b_id" : "$b_ps" : "$b_no >> $dir/ps

done

#touch $dir/t1tms

#ps -ef|grep tms|grep -v grep|awk '{print $1,$9,$10,$11,$12,$13,$14}' >> $dir/t1tms
#rsh erptmax2 ps -ef|grep tms|grep -v grep|awk '{print $1,$9,$10,$11,$12,$13,$14}' >> $dir/t2tms

#t1_3=`awk '$6 < 4 {print $0}' $dir/t1tms|head -1`
#t1_3_no=`awk '$6 < 4 {print $0}' $dir/t1tms|wc -l`
#t1_15=`awk '$6 < 16 {print $0}' $dir/t1tms|awk '$6 > 14 {print $0}'|head -1`
#t1_15_no=`awk '$6 < 16 {print $0}' $dir/t1tms|awk '$6 > 14 {print $0}'|wc -l`
#t1_17=`awk '$6 > 16 {print $0}' $dir/t1tms|awk '$6 < 18 {print $0}'|head -1`
#t1_17_no=`awk '$6 > 16 {print $0}' $dir/t1tms|awk '$6 < 18 {print $0}'|wc -l`
#t1_23=`awk '$6 > 22 {print $0}' $dir/t1tms|head -1`
#t1_23_no=`awk '$6 > 22 {print $0}' $dir/t1tms|wc -l`

#t2_3=`awk '$6 < 4 {print $0}' $dir/t2tms|head -1`
#t2_3_no=`awk '$6 < 4 {print $0}' $dir/t2tms|wc -l`
#t2_15=`awk '$6 < 16 {print $0}' $dir/t2tms|awk '$6 > 14 {print $0}'|head -1`
#t2_15_no=`awk '$6 < 16 {print $0}' $dir/t2tms|awk '$6 > 14 {print $0}'|wc -l`
#t2_17=`awk '$6 > 16 {print $0}' $dir/t2tms|awk '$6 < 18 {print $0}'|head -1`
#t2_17_no=`awk '$6 > 16 {print $0}' $dir/t2tms|awk '$6 < 18 {print $0}'|wc -l`
#t2_23=`awk '$6 > 22 {print $0}' $dir/t2tms|head -1`
#t2_23_no=`awk '$6 > 22 {print $0}' $dir/t2tms|wc -l`

#touch $dir/tms
#echo $t1_3" : "$t1_3_no"           "$t2_3" : "$t2_3_no >> $dir/tms
#echo $t1_15" : "$t1_15_no"           "$t2_15" : "$t2_15_no >> $dir/tms
#echo $t1_17" : "$t1_17_no"           "$t2_17" : "$t2_17_no >> $dir/tms
#echo $t1_23" : "$t1_23_no"           "$t2_23" : "$t2_23_no >> $dir/tms

#### tms_db2 check (070508) ###

touch $dir/t1tms
for ps in  15 17 23
do
                tms_ps=`ps -efo "%u %a"|grep tms_db2|awk -v ps=$ps '{if ($6==ps) print $0}'|head -1`
                tms_sum=`ps -efo "%u %a"|grep tms_db2|awk -v ps=$ps '{if ($6==ps) print $0}'|wc -l`

                echo $tms_ps " : "$tms_sum >> $dir/t1tms
done

cat $dir/ps >> $log
rsh erptmax2 /tmp/syschk/erptmax2_chk

for i in 15 17 23
do
        t1=`cat $dir/t1tms|awk -v i=$i '{if($6==i) print $0}'`
        t2=`cat $dir/t2tms|awk -v i=$i '{if($6==i) print $0}'`
        echo $t1"         "$t2 >> $log

done

rm -f $dir/ps $dir/t1tms $dir/t2tms

####### Fabt process check #######
echo "---- Fabt ----" >> $log
ps -ef|grep -i fabt*|grep -v grep|cut -c 6-80 >> $log

echo "---- erp_sbsi----" >> $log
ps -ef|grep erp_sbsi|grep -v grep >> $log

####### tm_chk execute #######
su - sbserp << END
./tm_chk
END
tmlog="/sbserp/tmchk.log"

#### tmchk log Tmadmin
echo "---- TMadmin ----" >> $log
echo "      RDY   NRDY   RUN" >> $log
for tm in ci stv stp sts
do
    a=`grep $tm $tmlog|awk '{print $2}'`
    b=`grep $tm $tmlog|awk '{print $3}'`
    c=`grep $tm $tmlog|awk '{print $4}'`
    printf "%-5s %-7s %-6s %-5s \n" $tm $a $b $c >> $log
done
rm -f /sbserp/tmchk.log

####### log file transfer #######
cd /tmp/syschk
ftp -n erpwas1 << END
user root sysmaster
cd /tmp/syschk/erp
put $host.log

END
rm -f $host.log


################################################
erptmax2_chk
################################################
#!/bin/sh

dir="/tmp/syschk"
touch $dir/t2tms
for ps in 15 17 23
do
        tms2_ps=`ps -efo "%u %a"|grep tms_db2|awk -v ps=$ps '{if ($6==ps) print $0}'|head -1`
        tms2_sum=`ps -efo "%u h%a"|grep tms_db2|awk -v ps=$ps '{if ($6==ps) print $0}'|wc -l`
        echo $tms2_ps" : "$tms2_sum >> $dir/t2tms
done

ftp -n erptmax1 << END
user root sysmaster

cd /tmp/syschk
put $dir/t2tms

bye
END
rm -f $dir/t2tms


################################################
erpdb_chk
################################################

log="/tmp/syschk/erpdb.log"
day=`date +%Y%m%d`
dblog="/home/sbsinst/db_connect"
su - sbsinst << END
db2 connect to sbsdb > db_connect
db2 connect to musicdb >> db_connect
END
echo "---- db connection ----" >> $log
#cat /home/sbsinst/db_connect >> $log

echo "## SBS DB ##" >> $log
head -6 $dblog|tail -3 >> $log
echo "## MUSIC DB ##" >> $log
tail -4 $dblog|head -3 >> $log
rm -f $dblog

echo "---- asn ---" >> $log
ps -ef|grep -i asn|grep -v grep|awk '{print $1,$5,$6,$8,$9,$10,$11}' >> $log
echo "---- applyy log ---" >> $log
tail -4 /sbsdata/APPLY/sbsinst.SBSDB.SBSAPPLY.APP.log|head -3 >> $log
echo "---- erp_schd log ----" >> $log
tail -3 `ls -rtl /sbserp/daemon/log/erp_schd*log|tail -1|awk '{print $9}'`|head
-3 >> $log
"erpdb_chk" 37 lines, 1010 characters
log="/tmp/syschk/erpdb.log"
day=`date +%Y%m%d`
dblog="/home/sbsinst/db_connect"
su - sbsinst << END
db2 connect to sbsdb > db_connect
db2 connect to musicdb >> db_connect
END
echo "---- db connection ----" >> $log
#cat /home/sbsinst/db_connect >> $log

echo "## SBS DB ##" >> $log
head -6 $dblog|tail -3 >> $log
echo "## MUSIC DB ##" >> $log
tail -4 $dblog|head -3 >> $log
rm -f $dblog

echo "---- asn ---" >> $log
ps -ef|grep -i asn|grep -v grep|awk '{print $1,$5,$6,$8,$9,$10,$11}' >> $log
echo "---- applyy log ---" >> $log
tail -4 /sbsdata/APPLY/sbsinst.SBSDB.SBSAPPLY.APP.log|head -3 >> $log
echo "---- erp_schd log ----" >> $log
tail -3 `ls -rtl /sbserp/daemon/log/erp_schd*log|tail -1|awk '{print $9}'`|head -3 >> $log
echo "---- erp_schd erp_pw process ----" >> $log
ps -ef|grep erp_schd|grep -v grep >> $log
ps -ef|grep erp_pw|grep -v grep >> $log

#### ftp transfer ####
cd /tmp/syschk
ftp -n erpwas1 << END
user root sysmaster
cd /tmp/syschk/erp
put erpdb.log

bye

END
rm -f /tmp/syschk/erpdb.log