9999热视频三级毛片AV区|日韩欧美精品狼友观看视频|av在线成人免费AA片|日韩三级AV电影|久久亚洲私人国产精品vA|亚洲无码卡一卡二卡三|手机在线免费看黄色片|婷婷尹人在线婷婷五月手机网|99爱在线播放|欧美成人色情视频品

1.創(chuàng)建數(shù)據(jù)庫

[db2inst1@localhost ~]$ db2set db2codepage=1208 #設置編碼

[db2inst1@localhost ~]$ db2 create database wms automatic storage yes using codeset UTF-8territory cn pagesize 32768 #創(chuàng)建wms數(shù)據(jù)庫

//指定db2數(shù)據(jù)庫安裝目錄

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

更多信息請查看IT技術專欄