#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 >/dev/null
#SCPIPT if [ $? -eq 0 ];then
#SCPIPT db2pd -d $i -hadr |grep "HADR_STATE">/dev/null
#SCPIPT if [ $? -eq 0 ];then
#SCPIPT Ptime=$(db2pd -d $i -hadr | grep -w "PRIMARY_LOG_TIME" |awk '{print $5}'|tr -d [:punct:])
#SCPIPT Stime=$(db2pd -d $i -hadr | grep -w "STANDBY_LOG_TIME" |awk '{print $5}'|tr -d [:punct:])
#SCPIPT S_Ptime=$(db2pd -d $i -hadr | grep -w "STANDBY_REPLAY_LOG_TIME" |awk '{print $5}'|tr -d [:punct:])
#SCPIPT state=$(db2pd -d $i -hadr | grep -w "HADR_STATE&
DB2-日常巡检-同步状态
最新推荐文章于 2024-08-09 21:25:57 发布