DB2 数据库创建、表的ixf文件导出导入示例
1.创建数据库
[db2inst1@localhost ~]$ db2set db2codepage=1208 #设置编码
[db2inst1@localhost ~]$ db2 create database wms automatic storage yes using codeset utf-8territory cn pagesize 32768 #创建wms数据库
//指定db2数据库安装目录
db2 create db xxdb on /app/dbdata using codepage "gbk" country "zh_cn"
2.导出表的ixf文件(如:exportreportdata.sh)
todir=/home/cpsinst/bup/
tab="unteck_attachment_his unteck_busi_log unteck_dict_entry unteck_dict_type unteck_login_log unteck_menu unteck_operation unteck_organization unteck_primarykey unteck_resource unteck_role unteck_role_resource unteck_user unteck_user_role"
db2 connect to cpsdb
db2 set schema='odsuser'
for tabtemp in $tab
do
echo $tabtemp
db2 "export to ${todir}/${tabtemp}.ixf of ixf select * from ${tabtemp}"
done
3. 导入表的ixf文件
db2 connect to myetldb;
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