378 发表于 2016-11-17 10:38:16

DB2编目

  进入:db2cmd命令行
  //第一步:编目远程节点
  //db2 uncatalog node itil
  db2 uncatalog node itil
  //itil:远程节点名
  db2 catalog tcpip node itil remote 192.168.5.73 server 50000 remote_instancedb2 systemdpsvr
  db2 catalog tcpip node tc remote 192.168.0.15 server 50008 remote_instancedb2 systemdpsvr
  //第二步:编目数据库
  //db2 uncatalog database dbcrea
  //dbcrea:数据库实例名;tcdbcrea:本地数据库实例名(url下的jdbc:db2:inst2tc)
  db2 catalog database dbcrea as tcdbcrea at nodeitil
  db2 catalog database tradeCtr as inst2tc at nodetc
  //测试数据库连接
  //db2 connect to tcdbcrea user user_name USING password
  db2 connect to inst2tc user tc using business
页: [1]
查看完整版本: DB2编目