DB2 数据库创建、表的ixf文件导出导入示例
1.创建数据库
[db2inst1@localhost~]$db2setdb2codepage=1208#设置编码
[db2inst1@localhost~]$db2createdatabasewmsautomaticstorageyesusingcodesetUTF-8territorycnpagesize32768#创建wms数据库
//指定db2数据库安装目录
db2createdbxxdbon/app/dbdatausingCODEPAGE"GBK"country"Zh_CN"
2.导出表的ixf文件(如:exportReportData.sh)
toDir=/home/cpsinst/bup/
tab="UNTECK_ATTACHMENT_HISUNTECK_BUSI_LOGUNTECK_DICT_ENTRYUNTECK_DICT_TYPEUNTECK_LOGIN_LOGUNTECK_MENUUNTECK_OPERATIONUNTECK_ORGANIZATIONUNTECK_PRIMARYKEYUNTECK_RESOURCEUNTECK_ROLEUNTECK_ROLE_RESOURCEUNTECK_USERUNTECK_USER_ROLE"
db2connecttocpsdb
db2setschema='ODSUSER'
fortabTempin$tab
do
echo$tabTemp
db2"exportto${toDir}/${tabTemp}.IXFofIXFselect*from${tabTemp}"
done
3.导入表的ixf文件
db2connecttomyetldb;
db2setschema=odsuser;
db2IMPORTFROMETL_BUSI_TYPE.IXFOFIXFMODIFIEDBYFORCECREATECOMMITCOUNT10000replace_createINTOETL_BUSI_TYPE
db2IMPORTFROMETL_BUSI_TYPE_TOSEND.IXFOFIXFMODIFIEDBYFORCECREATECOMMITCOUNT10000replace_createINTOETL_BUSI_TYPE_TOSEND
db2IMPORTFROMETL_CONTACT_PEPOLE.IXFOFIXFMODIFIEDBYFORCECREATECOMMITCOUNT10000replace_createINTOETL_CONTACT_PEPOLE