SHELL中自动备份DB2架构

#!/bin/sh
. ~/.bash_profile;
dt=$(date +"%Y%m%d%H%M%S");
nul="/dev/null";
db=zxjxdbs;
outfl="/day/back/${db}_$dt.sql";

db2 connect to $db>$nul;
db2look -d $db -e -f -i zxjx -w 111111 -o $outfl;
db2 connect reset>$nul;
db2 terminate>$nul;

 

posted @ 2020-04-04 15:11  silencemaker1221  阅读(167)  评论(0编辑  收藏  举报