欢迎光临
我们一直在努力

db2定时任务、备份脚本

[db2inst1@db2 ~]$ crontab -l

30 02 * * *  /bin/sh  /home/db2inst1/backup/backup.sh

[db2inst1@db2 ~]$ cat /home/db2inst1/backup/backup.sh

#!/bin/bash

bakdir=/home/db2inst1/backup

time1=`date  +”%Y-%m-%d %H:%M:%S”`

cd $bakdir

echo $time1 >> $bakdir/backup.log

/home/db2inst1/sqllib/bin/db2 backup db devdb104 online

if [ $? -eq 0 ];then

time2=`date  +”%Y-%m-%d %H:%M:%S”`

echo “the database backup is successfully completed at $time2” >> $bakdir/backup.log

else

echo “the database backup is failed” >> $bakdir/backup.log

fi

/bin/find /home/db2inst1/backup/ -type f -iname “devdb104.0.db2inst1.NODE0000.CATN0000*” -mtime +1 -exec rm -rf {} \; 

赞(0)
【声明】:本博客不参与任何交易,也非中介,仅记录个人感兴趣的主机测评结果和优惠活动,内容均不作直接、间接、法定、约定的保证。访问本博客请务必遵守有关互联网的相关法律、规定与规则。一旦您访问本博客,即表示您已经知晓并接受了此声明通告。