db2常用操作

1. db2建立遠端節點編目及删除

db2 catalog tcpip node nodeName remote remoteIp server remotePort

db2 list node directory

eg. db2 catalog tcpip node TESTND remote 123.123.123.123 server 60008

db2 uncatalog node TESTND

2. db2建立資料庫編目及删除

db2 catalog db dbName as dbAlisName at node nodeName

db2 list db directory

e.g db2 catalog db TESTDB as  TESTDB at node TESTND

db2 uncatalog db TESTDB

3. db2導出資料