第一步:查询数据库所有用户表
select table_name from sysibm.tables where table_schema = 'ODSUSER'
第二步:构造export语句
db2 connect to report
db2 set schema='ODSUSER'
db2 export to D:\数据导出\report\UNTECK_ATTACHMENT.IXF of IXF select * from UNTECK_ATTACHMENT
db2 export to D:\数据导出\report\UNTECK_DICT_ENTRY.IXF of IXF select * from UNTECK_DICT_ENTRY
db2 export to D:\数据导出\report\UNTECK_DICT_TYPE.IXF of IXF select * from UNTECK_DICT_TYPE
db2 export to D:\数据导出\report\UNTECK_LOGIN_LOG.IXF of IXF select * from UNTECK_LOGIN_LOG
db2 export to D:\数据导出\report\UNTECK_MENU.IXF of IXF select * from UNTECK_MENU
db2 export to D:\数据导出\report\UNTECK_OPERATION.IXF of IXF select * from UNTECK_OPERATION
db2 export to D:\数据导出\report\UNTECK_ORGANIZATION.IXF of IXF select * from UNTECK_ORGANIZATION
db2 export to D:\数据导出\report\UNTECK_PRIMARYKEY of IXF select * from UNTECK_PRIMARYKEY
db2 export to D:\数据导出\report\UNTECK_RESOURCE.IXF of IXF select * from UNTECK_RESOURCE
db2 export to D:\数据导出\report\UNTECK_ROLE of IXF select * from UNTECK_ROLE
db2 export to D:\数据导出\report\UNTECK_ROLE_RESOURCE.IXF of IXF select * from UNTECK_ROLE_RESOURCE
db2 export to D:\数据导出\report\UNTECK_USER.IXF of IXF select * from UNTECK_USER
db2 export to D:\数据导出\report\UNTECK_USER_ROLE.IXF of IXF select * from UNTECK_USER_ROLE
第三步:打开windows cmd 执行export语句
第四步:导入表的ixf文件(注意在ixf文件的目录下执行)
db2 connect to report2;
db2 set schema=odsuser;
db2 IMPORT FROM ETL_BUSI_TYPE.IXF OF IXF MODIFIED BY FORCECREATE COMMITCOUNT 10000 replace_create INTO ETL_BUSI_TYPE
db2 IMPORT FROM ETL_BUSI_TYPE_TOSEND.IXF OF IXF MODIFIED BY FORCECREATE COMMITCOUNT 10000 replace_create INTO ETL_BUSI_TYPE_TOSEND
db2 IMPORT FROM ETL_CONTACT_PEPOLE.IXF OF IXF MODIFIED BY FORCECREATE COMMITCOUNT 10000 replace_create INTO ETL_CONTACT_PEPOLE
......