db2数据联邦基础命令

db2数据联邦基础命令
如需帮助,请发邮件到 lyc557@163.com
1.db2 编目节点:
db2 CATALOG TCPIP NODE <NODENAME> REMOTE <IP> SERVER
50000 REMOTE_INSTANCE DB2 OSTYPE AIX
取消编目节点:
db2 uncatalog node <node_name>

2.db2 编目数据库:
db2 CATALOG DATABASE <dbname> AS <dbaliasname> AT NODE <NODENAME> AUTHENTICATION SERVER
取消编目数据库:
db2 uncatalog database <db_name>

3.创建wrappers
create wrapper localda library 'libdb2drda.so'

4.创建server
CREATE SERVER <SERVERNAME>
TYPE DB2 / UDB
VERSION '9.1'
WRAPPER LOCALDA
AUTHORIZATION <SCHEMANAME>
PASSWORD 154221348321515183610552
OPTIONS
( ADD NODE <nodename> ,
ADD DBNAME <dbname>
) @

5.创建 nickname
CREATE NICKNAME <nickname>
FOR <SERVERNAME>.<SCHEMANAME>.<tablename> @
如需帮助,请发邮件到 lyc557@163.com