当前位置:   article > 正文

db2 with ur迁移Oracle,AIX下DB2数据库的导出导入脚本

export to of del with ur

导出

-----------------------------------------------

if [ $# -lt 4 ]

then

echo "Usage: $0 "

exit 1

fi

TBL=$1

EXP=$1.data

db2 connect to $2 user $3 using $4

db2 "export to $EXP of del modified by coldel: select * from $TBL with ur" > unload.log

nexp=`grep "Number of rows exported" unload.log | awk -F: '{print $2}'`

echo " ok ! ($nexp)\n"

db2 connect reset > /dev/null

rm -f unload.log

-----------------------------------------------

导入

-----------------------------------------------

if [ $# -lt 4 ]

then

echo "Usage: $0 "

exit 1

fi

TBL=$1

DATA=$1.data

EXP=$1.exp

sed 's/:$//g' $DATA > $EXP

chmod a+r $EXP

db2 connect to $2 user $3 using $4

db2 "load from $EXP of del modified by coldel: usedefaults replace into $TBL nonrecoverable" > load.log

nread=`grep "Number of rows read" load.log | awk -F= '{print $2}'`

nload=`grep "Number of rows committed" load.log | awk -F= '{print $2}'`

echo " ok ! ($nread/$nload)\n"

rm -f $EXP

db2 connect reset > /dev/null

rm -f load.log

-----------------------------------------------

声明:本文内容由网友自发贡献,不代表【wpsshop博客】立场,版权归原作者所有,本站不承担相应法律责任。如您发现有侵权的内容,请联系我们。转载请注明出处:https://www.wpsshop.cn/w/从前慢现在也慢/article/detail/938718?site
推荐阅读
相关标签
  

闽ICP备14008679号