db2 数据创建联邦服务 游标导入数据

1、修改数据库参数
db2 update dbm cfg using FEDERATED YES;
2、重启数据库 db2stop  force
3、增加连接远程数据库的节点（如果存在就不需要重建）
db2 catalog tcpip node edw remote 154.164.6.22 server 60000
db2 catalog database edw at node edw
4、创建wrapper
db2 "create wrapper drda library 'libdb2drda.so'"
5、进入commend模式执行
CREATE SERVER edwdb TYPE DB2/UDB VERSION '10.5' WRAPPER drda AUTHID "edwinst" PASSWORD "edwinst" OPTIONS(ADD DBNAME 'EDW',PASSWORD 'Y')
6、
db2 "create user mapping for pasinst server edwdb options(remote_authid 'edwinst',remote_password 'edwinst')"
7、
db2 "create nickname edw.BCFMCMBI for edwdb.core.BCFMCMBI";

1、创建游标

db2 declare c1 cursor for select * from edwdb.CUSTOMER_ASSETS_INPUT

2、load 数据

db2 load from c1 of cursor replace into edw.CUSTOMER_ASSETS_INPUT