1．啟動數(shù)據(jù)庫Fm
db2start{?[
2．停止數(shù)據(jù)庫_:
db2stop!
3．連接數(shù)據(jù)庫5o
db2 connect to o_yd user db2 using pwd<t
4．讀數(shù)據(jù)庫管理程序配置Y[S):
db2 get dbm cfgE`M
5．寫數(shù)據(jù)庫管理程序配置G8&`zS
db2 update dbm cfg using 參數(shù)名 參數(shù)值a9E.s(
6．讀數(shù)據(jù)庫的配置 >@E
db2 connect to o_yd user db2 using pwd7<O
db2 get db cfg for o_ydp5%@
7．寫數(shù)據(jù)庫的配置a)Xm
db2 connect to o_yd user db2 using pwdv6Lk)
db2 update db cfg for o_yd using 參數(shù)名 參數(shù)值_JWDt
8．關(guān)閉所有應(yīng)用連接<<b9
db2 force application all:U+GJf
db2 force application ID1,ID2,,,Idn MODE ASYNCVSuQQh
(db2 list application for db o_yd show detail)d9*
9．備份數(shù)據(jù)庫H4"j
db2 force application alllK]
db2 backup db o_yd to d::zD&P!
(db2 initialize tape on \\.\tape0)u&9k
(db2 rewind tape on \\.\tape0)Id2l
db2 backup db o_yd to \\.\tape0a`B
10．恢復(fù)數(shù)據(jù)庫X
db2 restore db o_yd from d: to d: GN2*
db2 restore db o_yd from \\.\tape0 to d:&V
11．綁定存儲過程gN?W>
db2 connect to o_yd user db2 using pwdA{0#
db2 bind c:\dfplus.bnd[HsL
拷貝存儲過程到服務(wù)器上的C:\sqllib\function目錄中NBA${a
12．整理表U>K
db2 connect to o_yd user db2 using pwdpNjeOM
db2 reorg table ydd#a/3q
db2 runstats on table ydd with distribution and indexes allSlG
?新視野 -- 我們的新視野，我們的天地　　B
13．導(dǎo)出表數(shù)據(jù)0'TR
db2 export to c:\dftz.txt of del select * from dftzz
db2 export to c:\dftz.ixf of ixf select * from dftzRsV
14．導(dǎo)入表數(shù)據(jù)T2CCi
import from c:\123.txt of del insert into ylbx.czyxxiU&}5
db2 import to c:\dftz.txt of del commitcount 5000 messages c:\dftz.msg insert into dftzPs
db2 import to c:\dftz.ixf of ixf commitcount 5000 messages c:\dftz.msg insert into dftz\f
db2 import to c:\dftz.ixf of ixf commitcount 5000 insert into dftz}lC
db2 import to c:\dftz.ixf of ixf commitcount 5000 insert_update into dftz~26|
db2 import to c:\dftz.ixf of ixf commitcount 5000 replace into dftz^
db2 import to c:\dftz.ixf of ixf commitcount 5000 create into dftz (僅IXF)'A)
db2 import to c:\dftz.ixf of ixf commitcount 5000 replace_create into dftz (僅IXF)3S
?新視野 -- 我們的新視野，我們的天地　　&/
15．執(zhí)行一個批處理文件uBsc
db2 –tf 批處理文件名R8
（文件中每一條命令用 ；結(jié)束）.
16．自動生成批處理文件UasvY
建文本文件：temp.sqlQov{Op
select 'runstats on table DB2.' || tabname || ' with distribution and detailed indexes all;' from syscat.tables where tabschema='DB2' and type='T';jA
db2 –tf temp.sql>runstats.sql"3z.
17．自動生成建表（視圖）語句|v]O=V
在服務(wù)器上：C:\sqllib\misc目錄中sZ4G#
db2 connect to o_yd user db2 using pwdt[G
db2look –d o_yd –u db2 –e –p –c c:\o_yd.txtRw
18．其他命令Qp,%
grant dbadm on database to user bbJv`'l
?新視野 -- 我們的新視野，我們的天地　　t
19select * from czyxx fetch first 1 rows onlyYU)
20db2look –d ylbx –u db2admin –w –asd –a –e –o a.txt21. 顯示當(dāng)前用戶所有表 {0
?新視野 -- 我們的新視野，我們的天地　　v$Q
　　list tables 3\^])
22.列出所有的系統(tǒng)表 s>
?新視野 -- 我們的新視野，我們的天地　　ykr}K
　　list tables for system.J<
23.查看表結(jié)構(gòu) ^RE/m
　　db2 describe select * from user.tablesB?N