美文网首页
DB2 COMMAND LINE

DB2 COMMAND LINE

作者: 奋斗的迈腾 | 来源:发表于2017-10-13 16:39 被阅读0次

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

相关文章

网友评论

      本文标题:DB2 COMMAND LINE

      本文链接:https://www.haomeiwen.com/subject/iknzyxtx.html