1. DB2 connet to database name
2.?
3.LIST COMMAND OPTIONS
4.UPDATE COMMAND OPTIONS
5.LIST NODE DIRECTORY
6.LIST DATABASE DIRECTORY(one node map to many databases)
7.CHANGE
8.HISTORY
9.RUNCMD
10.EDIT(9 10 NEED THE NUMBER OF 8 : e editor vi 2(history number))
set DB2_CLP_EDITOR="vi" Then can use e 2(means use default editor)
12.db2look-- DB2 statistics and DDL extraction tool command
db2look -d NT018007 -e -nofed -t XINGTEST (To see the create sql of table "XINGTEST")
13.DESCRIBE TABLE TABLE_NAME