DB2 Federated Database 一例（类似于Oracle的DBLink）

要从数据库 smp 访问 数据库ismd中的ismd.sellers表

# catalog node and databasedb2 catalog tcpip node node_dev remote 192.168.1.101 server 50001db2 catalog db ismxdev as ismxlink at node node_devdb2 terminate# modify system parameterdb2 update dbm cfg using FEDERATED YESdb2stop forcedb2start# connect to smpdb2 connect to smp# create wrapperdb2 create wrapper DRDA# create server definitiondb2 "create server ismd_dev type db2/udb version '9.7' wrapper DRDA authid \"db2inst1\" password \"db2inst1\" options (add dbname 'ismd_dev')"# create user mappingdb2 "create user mapping for db2inst1 server ismd_dev options(remote_authid 'db2inst1', remote_password 'db2inst1')"# create nickname for remote tabledb2 create nickname ismd.sellers for ismd_dev.ismd.sellers