db2 catlog的新建
郝修为
2023-12-01
db2 catalog tcpip node NODE02 remote xxxx server xxxx
db2 catalog db HL07D002 as pricedb2 at node NODE02 authentication SERVER_ENCRYPT
db2 list db directory | grep -ip HL07D002
db2 list node directory | grep -ip NODE02
db2 list db directory | grep -ip NODE02
db2 list db directory > /localwork/home/w318500/dbcat.backup/after_xxx_3262
db2 list node directory >> /localwork/home/w318500/dbcat.backup/after_xxx_3262
db2 catalog tcpip node DB2_INSTANCE remote DB2_SERVER server DB2_PORT
db2 catalog db DATABASE as DB_Alias名 at node DB2_INSTANCE authentication server_encrypt
diff /localwork/home/w318500/dbcat.backup/before_xxx_3262 /localwork/home/w318500/dbcat.backup/after_xxx3262
db2 connect to PRICEDB2 user xxx using xxx