#!/bin/bash#db2自动备份脚本# create at 2013-07-24#---------------------------#参数dblist1=BOYA #要备份的数据库 dblist2=BOYACZbkrootpath=~/backup #备份路径bkdate=`date +%Y%m%d` #备份时间bkpath=${
bkrootpath}
/${
bkdate}
log=${
bkdate}
.log #日志date=`date +%Y%m%d%k%M%S`backfile1=${
dblist1}
.0.db2inst1.NODE0000.CATN0000.${
date}
backfile2=${
dblist2}
.0.db2inst1.NODE0000.CATN0000.${
date}
#初始化db2环境if [ -f ${
HOME}
/sqllib/db2profile ];
then . ${
HOME}
/sqllib/db2profilefi#创建备份路径if [ -d ${
bkrootpath}
];
then echo ""else mkdir ${
bkrootpath}
fiif [ -d ${
bkpath}
];
then cd ${
bkpath}
echo "今天已备份">>${
log}
else mkdir ${
bkpath}
cd ${
bkpath}
fidb2stop force #停止db2数据库db2start #重启db2数据库,以保证备份正常进行echo "----------------------">${
log}
echo "${
bkdate}
">>${
log}
echo "">>${
log}
echo "所要备份数据库列表">>${
log}
echo "${
dblist1}
,${
dblist2}
">>${
log}
#连接备份数据库1db2set db2codepage=1386db2 connect to ${
dblist1}
echo "开始备份${
dblist1}
">>${
log}
echo "正在备份......">>${
log}
db2 backup db ${
dblist1}
to "${
bkpath}
"if [ -d "${
backfile1}
" ];
then echo "成功备份数据库${
dblist1}
">>${
log}
else echo "备份数据库${
dblist1}
失败">>${
log}
fidb2stop forcedb2start#连接备份数据库2db2set db2codepage=1386 db2 connect to ${
dblist2}
echo "开始备份${
dblist2}
">>${
log}
echo "正在备份......">>${
log}
db2 backup db ${
dblist2}
to "${
bkpath}
"if [ -d "${
backfile2}
" ];
then echo "成功备份数据库${
dblist2}
">>${
log}
else echo "备份数据库${
dblist2}
失败">>${
log}
fi