在已经安装DB2客户端的机器上添加server编目:
语法
然后添加上面的database:
测试:
语法
db2 => catalog tcpip node node_name remote hostname|ip_address
server service_name|port_number [remote_instance instance_name]
[system system_name] [ostype os_type]
然后添加上面的database:
CATALOG DATABASE database-name [AS alias] [ON path | AT NODE node-name]
[AUTHENTICATION {SERVER | CLIENT | DCS | DCE SERVER PRINCIPAL principalname
| KERBEROS TARGET PRINCIPAL principalname | SERVER_ENCRYPT | DCS_ENCRYPT
| DATA_ENCRYPT | GSSPLUGIN}] [WITH "comment-string"]
测试:
--catalog node
[db2inst@rhel5 sqllib]$ db2 "catalog tcpip node tower06 remote 172.21.21.21 server 50000"
--catalog database,后来补充
[db2inst2@server1 ~]$ db2 catalog db sample at node LOC