备份db2schema数据

select  ‘insert into migdev_backup20160820.‘||tabname||‘(select * from migdev.‘||tabname ||‘);‘ from syscat.tables  where  tabschema =‘migdev‘;

select  ‘delete from migdev_backup2016082020.‘||tabname||‘;‘from syscat.tables.tables where Tabschema =‘migdev_Backup20160820‘；

备份db2schema数据

标签：