应用数据库:localdb,IP:<应用IP>应用schema:localschema,应用密码:localschema, 管理员用户密码:adminuser/adminpwd
对方数据库:remotedb,IP:<remoteIP>对方schema:remoteschema,对方密码:remoteschemapwd
telnet <remoteIP>
db2
connect to localdb user <adminuser> using <adminpwd>
察看<应用IP>机器的节点项
list database directory 或者 list node directory
创建节点
catalog tcpip node <remotedb> remote <remoteIP> server 50000
catelog db remotedb at node remotedb
terminate
创建wrapper
update dbm cfg using federated yes
db2stop force
db2start
connect to localdb user <adminuser> using <adminpwd>
create wrapper drda
创建server
create server "myserver" type db2/aix version '<remote db version>'
wrapper "drda" authorization "remoteuser" password "remotepwd"
options(add dbname 'remotedb',add node 'remotenode')
创建user mapping
create user mapping for "localschema" server "myserver"
options(remote_authid 'remoteschema', remote_password 'remoteschemapwd')
创建nickname
create nickname "localschema"."myNickname"
for "myserver"."remoteschema"."<tablename>"
DB2 联合数据库 的配置步骤
最新推荐文章于 2021-04-13 10:19:17 发布