dbload大批量导入数据 shell脚本 根据表列表文件导入 速度超快

echo "请输入PICC流程控制系统[数据库]名称:" read prpdb LPLCEXPDIR=$PWD/LPLCEXP if [ -d $LPLCEXPDIR ] then echo "the directry 'LPLCEXP' is exist!" rm -r $LPLCEXPDIR/* else mkdir $LPLCEXPDIR fi mkdir $LPLCEXPDIR/log Ctrpath=$PWD echo $Ctrpath echo "开始导入数据" `date "+%Y-%m-%d %H:%M:%S"` >> $Ctrpath/j_out.log echo "开始导入数据" `date "+%Y-%m-%d %H:%M:%S"` for tname in $(<./shandong.unl) do echo $tname echo "select ncols num from systables where tabname='$tname'"|dbaccess $prpdb > $Ctrpath/list.txt num=`awk 'NR==5{print $0}' $Ctrpath/list.txt` echo "file /home/picclk/LQH/$tname.unl delimiter '|' $num; insert into $tname; ">>j_$tname.ctl echo "start '$tname': "`date "+%Y-%m-%d %H:%M:%S"` >> $Ctrpath/j_out.log dbload -d $prpdb -c j_$tname.ctl -n 10000 -l j_$tname.err -e 10000000 >$Ctrpath/j_out.log & echo "finish '$tname': "`date "+%Y-%m-%d %H:%M:%S"` >> $Ctrpath/j_out.log done echo "开始导入数据" `date "+%Y-%m-%d %H:%M:%S"` echo "数据导入完成" `date "+%Y-%m-%d %H:%M:%S"`>> $Ctrpath/j_out.log