1．启动数据库Fm
db2start{?[
2．停止数据库_:
db2stop!
3．连接数据库5o
db2 connect to o_yd user db2 using pwd<t
4．读数据库管理程序配置Y[S):
db2 get dbm cfgE`M
5．写数据库管理程序配置G8&`zS
db2 update dbm cfg using 参数名 参数值a9E.s(
6．读数据库的配置 >@E
db2 connect to o_yd user db2 using pwd7<O
db2 get db cfg for o_ydp5%@
7．写数据库的配置a)Xm
db2 connect to o_yd user db2 using pwdv6Lk)
db2 update db cfg for o_yd using 参数名 参数值_JWDt
8．关闭所有应用连接<<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．备份数据库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．恢复数据库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
拷贝存储过程到服务器上的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．导出表数据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．导入表数据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．执行一个批处理文件uBsc
db2 –tf 批处理文件名R8
（文件中每一条命令用 ；结束）.
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
在服务器上：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. 显示当前用户所有表 {0
©新视野 -- 我们的新视野，我们的天地　　v$Q
　　list tables 3\^])
22.列出所有的系统表 s>
©新视野 -- 我们的新视野，我们的天地　　ykr}K
　　list tables for system.J<
23.查看表结构 ^RE/m
　　db2 describe select * from user.tablesB?N