db2数据联邦基础命令

db2数据联邦基础命令

 

1.db2 编目节点:  www.zzzyk.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.zzzyk.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> @