windows下，导出、导入数据库表的ixf文件

来源：互联网发布：highwire press数据库编辑：程序博客网时间：2024/06/04 01:17

第一步：查询数据库所有用户表

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

......

0 0