#--匯出模式 MBS 下的所有表

i_dbname=MBDB1
i_schema=MBS
i_expdir=/db2data1/export

i_time=`date +%Y%m%d%H%M`
i_schema_len=`echo ${#i_schema}`
i_tab_file=/tmp/${i_dbname}_${i_schema}.txt

db2 connect to $i_dbname

i_tab_len=`db2 -x " select max(length(tabname)) from syscat.tables where tabschema='${i_schema}'"`
i_tab_len=`echo $i_tab_len`

db2 -x "select char(tabschema,${i_schema_len}) || '.' || char(tabname,$i_tab_len)
from syscat.tables where tabschema='${i_schema}' " > $i_tab_file

mkdir -p $i_expdir
cd $i_expdir
for i_tab in `cat $i_tab_file`
do
  db2 "export to ${i_tab}_${i_time}.ixf of ixf
    lobs to $i_expdir lobfile ${i_tab}_${i_time}.lob modified by lobsinfile
    messages  ${i_tab}_${i_time}.msg
    select * from  ${i_tab} "
done

exit 0

DB2匯出模式 MBS 下的所有表

相關文章