用途:aix下db2建表脚本备份与同步命令
系统:aix 6.1
步骤:
1、生成db2建表脚本,保留最近7天的记录;
2、压缩脚本;
3、将脚本备份到ftp服务器;
#!/bin/sh
# 1.add execute permission
# chmod 744 backup_job.sh
# 2.crontab -e
# 0 0 * * * nohup sh /home/db2inst1/backup/backup_job.sh &
fn=db_name.$(date +%u).sql
db2look -d db_name -e -i db_user -w db_pwd -o $fn
gzip -f $fn
ftp -n <<- EOF
open 192.0.0.1 21
user ftp_user ftp_pwd
cd backup_folder
bin
put $fn.gz
bye
EOF
exit 0