db2数据联邦基础命令
1.db2 编目节点: www.2cto.com
db2 CATALOG TCPIP NODE REMOTE SERVER
50000 REMOTE_INSTANCE DB2 OSTYPE AIX
取消编目节点:
db2 uncatalog node
2.db2 编目
数据库:
db2 CATALOG DATABASE AS AT NODE AUTHENTICATION SERVER
取消编目数据库:
db2 uncatalog database
3.创建wrappers
create wrapper localda library 'libdb2drda.so'
www.2cto.com
4.创建server
CREATE SERVER
TYPE
DB2 / UDB
VERSION '9.1'
WRAPPER LOCALDA
AUTHORIZATION
PASSWORD 154221348321515183610552
OPTIONS
( ADD NODE ,
ADD DBNAME
) @
5.创建 nickname
CREATE NICKNAME
FOR .. @