linux下自动备份db2脚本。把数据库备份到指定的目录下面并执行压缩,然后删除早期的备份,可以把这个脚本 设置在一个定式任务里面,每天晚上执行一次。 # !/bin/bash hostName = `hostname`MAX_BAKFILE_NUM = 4 db_bak_dir = " /home/db2inst1/data " if [ ! - d " $db_bak_dir " ] ; then mkdir $db_bak_dir fisu - db2inst1 << eof db2 force applications alldb2 backup db sino to $db_bak_dir eof cd / home / db2inst1 / datals - l | sort + 5 - 7 - r | awk ' $8 ~ /^(SINO)/ {cmd = "tar zcvf " ; cmd = cmd"B_" ; cmd = cmd" ' $hostName ' _" ; cmd = cmd$8".tar.gz" ; cmd = cmd" "$8; del_file_cmd = "rm "$8 print cmd ; system(cmd); system(del_file_cmd)} ' ;ls - l | grep ' B_ ' | sort + 5 - 7 - r | awk ' NR > " ' $MAX_BAKFILE_NUM ' "{ del_cmd = "rm "$8 ;system(del_cmd) } '