db2數據聯邦基礎命令
1.db2 編目節點: www.2cto.com
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'
www.2cto.com
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> @
