db2=> connect to loancs1 user db2admin using db2 (连接数据库)
db2=> quit
d:进入d盘:把数据备份放到d盘里面
db2 export to kyed.ixf of ixf select * from loan.lg_kyed (数据备份)
db2 export to ztkyed.ixf of ixf select * from loan.lg_ztkyed
db2 delete from loan.lg_kyed(删除以前数据库里面的数据)
db2 import from kyed.ixf of ixf insert into loan.lg_kyed(将数据导入)
db2 import from tmpkyde.ixf of ixf create into loan.tmplg_kyed(此过程包括了新增和插入数据)
db2=> quit
d:进入d盘:把数据备份放到d盘里面
db2 export to kyed.ixf of ixf select * from loan.lg_kyed (数据备份)
db2 export to ztkyed.ixf of ixf select * from loan.lg_ztkyed
db2 delete from loan.lg_kyed(删除以前数据库里面的数据)
db2 import from kyed.ixf of ixf insert into loan.lg_kyed(将数据导入)
db2 import from tmpkyde.ixf of ixf create into loan.tmplg_kyed(此过程包括了新增和插入数据)