多数据库备份脚本

解决多数据库手工备份问题：

#!/usr/bin/ksh
. /app/db2inst1/sqllib/db2profile
DIR=/app/db2inst1/backup
cd $DIR/
db2 list db directory |grep "Database name "|awk '{print $4}' > db.list
while read DBNM
do
  db2 backup db $DBNM online to $DIR/autobak/ COMPRESS INCLUDE LOGS
  find $DIR/autobak -name "*.001" -mtime +1 -exec rm {} ;
done < db.list


可以创建定时任务，自动进行备份。收起