1.catalog遠端資料庫到本地
db2 catalog tcpip node nodeName remote 10.1.5.111 server 50000
db2 catalog db databaseName at node nodeName
2.顯示所有資料庫資訊
db2 list db directory
3.登入資料庫
db2 connect to databaseName user userName using pwd
4.顯示本地所有節點資訊
db2 list node directory
5.删除節點上的資料庫
db2 uncatalog db databaseName
6.删除節點
db2 uncatalog node nodeName
7.查詢序列
SELECT * FROM SYSCAT.SEQUENCES ORDER BY CREATE_TIME DESC FETCH FIRST 10 ONLY ROWS