onpladm遷移數(shù)據(jù)簡單應(yīng)用 [復(fù)制鏈接]

電梯直達

1樓 [收藏(0)] [報告]

發(fā)表于 2012-11-03 09:36 |只看該作者 |倒序瀏覽

本帖最后由卐卍于 2012-11-15 15:46 編輯

運行sh down.sh databasename

卸載.sh

INFORMIXDIR=/home/informix
PATH=$PATH:$HOME/bin:.:$INFORMIXDIR/bin
INFORMIXSERVER=test
export INFORMIXDIR PATH INFORMIXSERVER
DBDATE=mdy4
export DBDATE
starttime=`date +%Y%m%d_%H:%M:%S`
printf "Begin time:$starttime\n"
filepath=/home/test/nfsshare/$1
rm -rf $filepath
mkdir $filepath
cd $filepath
dbaccess $1<<!
unload to $1.unl
select tabname from systables where tabid>'99' and tabtype='T';
!
onpladm create project p$1
tables=$(cut -d '|' -f1 $PWD/$1.unl)
for tablesname in $tables
do
onpladm create job $tablesname -p p$1 -d $tablesname.unl -D $1 -t $tablesname -fu
onpladm run job $tablesname -p p$1 -fu
onpladm delete job $tablesname -p p$1 -fu
done
onpladm delete project p$1
chmod 777 *.unl
endrun=`date +%Y%m%d_%H:%M:%S`
printf "End time:$endrun\n"

復(fù)制代碼

裝載.sh

INFORMIXDIR=/home/informix
PATH=$PATH:$HOME/bin:.:$INFORMIXDIR/bin
INFORMIXSERVER=test
export INFORMIXDIR PATH INFORMIXSERVER
DBDATE=mdy4
export DBDATE
starttime=`date +%Y%m%d_%H:%M:%S`
printf "Begin time:$starttime\n"
filepath=/nfsshare/$1
cd $filepath
onpladm create project p$1
tables=$(cut -d '|' -f1 $PWD/$1.unl)
for tablesname in $tables
do
onpladm create job $tablesname -p p$1 -d $tablesname.unl -D $1 -t $tablesname -fl
onpladm run job $tablesname -p p$1 -fl
onpladm delete job $tablesname -p p$1 -fl
done
onpladm delete project p$1
cd /tmp
onpladm create project pi$1
tables=$(grep "16110" *.log | cut -d '.' -f1)
cd $filepath
for tablesname in $tables
do
onpladm create job $tablesname -p pi$1 -d $tablesname.unl -D $1 -t $tablesname -flc
onpladm run job $tablesname -p pi$1 -flc
onpladm delete job $tablesname -p pi$1 -flc
done
onpladm delete project pi$1
endrun=`date +%Y%m%d_%H:%M:%S`
printf "End time:$endrun\n"

復(fù)制代碼

積分 0, 距離下一級還需積分

亚洲av成人无遮挡网站在线观看,少妇性bbb搡bbb爽爽爽,亚洲av日韩精品久久久久久,兔费看少妇性l交大片免费,无码少妇一区二区三区