DB2编目

进入：db2cmd命令行

//第一步：编目远程节点

//db2 uncatalog node itil 

db2 uncatalog node itil 

//itil:远程节点名

db2 catalog tcpip node itil remote 192.168.5.73 server 50000 remote_instance  db2 system  dpsvr

db2 catalog tcpip node tc remote 192.168.0.15 server 50008 remote_instance  db2 system  dpsvr

//第二步：编目数据库

//db2 uncatalog database dbcrea 

//dbcrea:数据库实例名；tcdbcrea:本地数据库实例名(url下的jdbc:db2:inst2tc)

db2 catalog database dbcrea as tcdbcrea at node  itil

db2 catalog database tradeCtr as inst2tc at node  tc

//测试数据库连接 

//db2 connect to tcdbcrea user user_name USING password

db2 connect to inst2tc user tc using business