db2连接数据库语句

db2 catalog tcpip node local_db remote 172.31.111.48 server 50000
db2 catalog db local_db at node dbnode
db2 list db directory
db2 uncatalog db loca1_db
db2 catalog db dydw as dw1 at node local_db
db2 connect to dw1 user dwmm using dwmm
---------------------------------------------------------------
连接db2数据库
db2 catalog tcpip node local_db remote 172.31.111.48 server 50000
db2 catalog db local_db(节点名) at node dbnode(别名)
db2 list db directory(查看节点)
db2 uncatalog db loca1_db(删除节点)
db2 catalog db dydw(数据库名称) as dw1(别名) at node local_db(节点名)
db2 connect to zgdw_yy user dwmu using dwmu

route add -p 172.31.93.0 mask 255.255.255.0 172.31.20.1
route add -p 172.31.92.0 mask 255.255.255.0 172.31.20.1
route add -p 172.31.83.0 mask 255.255.255.0 172.31.20.1
route add -p 172.16.2.0 mask 255.255.255.0 172.31.20.1
route add -p 172.16.7.0 mask 255.255.255.0 172.31.20.1
route add -p 172.31.81.0 mask 255.255.255.0 172.31.20.1

 

db2 list node directory 查看当前连的数据库

db2 catalog tcpip node zgdwdev2 remote 172.31.93.100 server 50030
db2 uncatalog db zgdwdev2
db2 catalog db zgdw as zgdwdev2 at node zgdwdev2
db2 uncatalog node zgdwdev2
db2 catalog tcpip node zgdwdev2 remote 172.31.93.100 server 60030
db2 terminate刷新
db2 connect to zgdwdev2 user dwmu using dwmu连接到数据库