【数据库】Linux db2常用指令库 实做教学

【簡介】

如何安裝db2，可參考此篇文章:
【數據庫】Centos 7 安裝DB2 Express-C 詳細教學

一、連接db2數據庫

1.查看所有實例列表

[root@localhost Desktop]# db2ilist
db2inst

2.查看當前實例

[root@localhost Desktop]# db2 get instance
 The current database manager instance is:  db2inst

3.列出所有數據庫

[db2inst@localhost Desktop]$  db2 list db directory
 System Database Directory
 
 Number of entries in the directory = 1

 Database 1 entry:

 Database alias                       = SAMPLE
 Database name                        = SAMPLE
 Local database directory             = /home/db2inst
 Database release level               = 14.00
 Comment                              =
 Directory entry type                 = Indirect
 Catalog database partition number    = 0
 Alternate server hostname            =
 Alternate server port number         =

4.連接數據庫

[db2inst@localhost expc]$ db2 connect to sample
   
   Database Connection Information

 Database server        = DB2/LINUXX8664 11.1.4.4
 SQL authorization ID   = DB2INST
 Local database alias   = SAMPLE

二、常見db2查询指令

1.列出所有表名

[db2inst@localhost ~]$ db2 list tables

2.查看數據庫表空间分配狀況

[db2inst@localhost ~]$ db2 list tablespaces show detail

3.列出所有數據庫

[db2inst@localhost ~]$ db2 list db directory

4.列出所有啟動的數據庫

[db2inst@localhost ~]$ db2 list active databases

5.查看版本

[db2inst@localhost ~]$ db2level

三、創建、刪除db2數據庫

1.創建數據庫-指定編碼

[db2inst@localhost ~]$ db2 create db test using codeset utf-8 territory CN

2.刪除數據庫

[db2inst@localhost ~]$ db2 drop database test
DB20000I  The DROP DATABASE command completed successfully.

四、啟動、關閉db2數據庫

1.啟動db2

[db2inst@localhost ~]$ db2start

2.關閉db2實例上的所有應用

[db2inst@localhost Desktop]$ db2 force application all
DB20000I  The FORCE APPLICATION command completed successfully.
DB21024I  This command is asynchronous and may not be effective immediately.

3.關閉db2

[db2inst@localhost Desktop]$ db2stop
SQL1064N  DB2STOP processing was successful.