参考：https://copyfuture.com/blogs-details/20201231224307473y
https://blog.csdn.net/u013914485/article/details/38265129?utm_medium=distribute.pc_relevant.none-task-blog-2~default~baidujs_baidulandingword~default-1-38265129-blog-122701582.pc_relevant_3mothn_strategy_recovery&spm=1001.2101.3001.4242.2&utm_relevant_index=4
db:CZYTEST ip:172.16.43.162 us:db2inst1 ps:db2inst1 db:CZYTEST ip:172.16.43.187 us:db2inst1 ps:db2inst1
1、187服务器操作：
1、创建CZYTEST db2 create db CZYTEST
2、162服务器操作
（1）前提开启联邦支持
db2 update dbm cfg using federated yes 重启db2 db2stop db2start
（2）创建nickname
db2 connect to sample user db2inst1 using db2inst1 1、创建node db2 catalog tcpip node nodedc remote 172.16.43.187 server 50000 REMOTE_INSTANCE CZYTEST db2 terminate #删除node db2 uncatalog node 2、创建数据库 别名 db2 catalog database CZYTEST at node nodedc db2 terminate #删除db db2 uncatalog db db2 connect to CZYTEST user db2inst1 using db2inst1 3、创建wrapper db2 create wrapper DRDA 4、创建连接到对方数据库的server db2 "create Server dbsrv type DB2/UDB version 11.5 wrapper "DRDA" authid "db2inst1" password "db2inst1" options (NODE 'nodedc',dbname 'CZYTEST')" #删除server db2 DROP SERVER dbsrv 5、用户mapping的创建-用户对用户 db2 "create user mapping for "db2inst1" server dbsrv options (remote_authid 'db2inst1' , remote_password 'db2inst1')" #删除mapping db2 drop User Mapping for db2inst1 server dbsrv 6、创建连接到对方表的nickname db2 "create nickname CZYTEST.NEWTABLE_V for dbsrv.CZYTEST.NEWTABLE"
标签：db2inst1,db2,创建,db,server,CZYTEST,nickname From： https://www.cnblogs.com/lina-2159/p/16904117.html