db2 连接 mysql_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连接到数据库