#!/usr/bin/sh
function usage()
{
echo "usage: `basename $0` options [table-list]"
echo "options:"
echo " -d database data path"
}
DATA_PATH=./data/
err_flg=0
while getopts ":d:" optname
do
case $optname in
"d")
DATA_PATH=$OPTARG
;;
":")
err_flg=1
err_msg="no argument value for option $OPTARG"
;;
*)
err_flg=1
err_msg="unexpected option(s)"
;;
esac
done
if [ $err_flg -eq 1 ]
then
echo $err_msg
usage
exit 1
fi
LIST_FILE=1_tables.lst
if [ ! -f ${LIST_FILE} ] ; then
echo "ERROR:文件${LIST_FILE}丢失,导入终止"
exit -1
fi
db2 connect to testdb1 user db2inst1 using db2inst1
if [ $? -ne 0 ];then
echo "ERROR:数据库连接失败,请检查数据库名,数据库用户及密码"
exit -1
fi
while read T_NAME
do
if [ ! -f ${DATA_PATH}/${T_NAME}.del ]; then
echo "ERROR:表${T_NAME}的数据文件不存在"
continue;
fi
echo "import ${T_NAME}..."
db2 "import from ${DATA_PATH}/${T_NAME}.del of del modified by delprioritychar replace into ${T_NAME}"
if [ $? -eq 0 ];then
echo "INFO:导入${T_NAME}成功"
else
echo "ERROR:导入${T_NAME}失败"
fi
done < ${LIST_FILE}