DB2读书笔记

查看表空间

1.GET SNAPSHOT FOR TABLESPACES ON <database name>

2.LIST TABLESPACES (show details)

注意：

容器只能建在本地盘，不能创建在网络映射盘符，NFS文件系统或GPFS文件系统。

查看索引

select * from syscat.indexes where tabname = upper(‘表名’)

DB2常用命令

1．启动数据库

     db2start

2．停止数据库

     db2stop force

3．连接数据库

     db2 connect to o_yd user db2 using pwd

4．读数据库管理程序配置

     db2 get dbm cfg

5．写数据库管理程序配置

     db2 update dbm cfg using 参数名 参数值

6．读数据库的配置

     db2 connect to o_yd user db2 using pwd

     db2 get db cfg for o_yd

7．写数据库的配置

     db2 connect to o_yd user db2 using pwd

     db2 update db cfg for o_yd using 参数名 参数值

8．关闭所有应用连接

     db2 “force application all”

     db2 “force application (ID1,ID2,,,Idn)”

(db2 list application for db o_yd show detail)

9．备份数据库

     db2 force application all

     db2 backup db o_yd to d:

    (db2 initialize tape on //./tape0)

    (db2 rewind tape on //./tape0)

    db2 backup db o_yd to //./tape0

10．恢复数据库

    db2 restore db o_yd from d: to d:

    db2 restore db o_yd from //./tape0 to d:

11．绑定存储过程

   db2 connect to o_yd user db2 using pwd

   db2 bind c:/dfplus.bnd

  拷贝存储过程到服务器上的C:/sqllib/function目录中

12．整理表

    db2 connect to o_yd user db2 using pwd

    db2 reorg table ydd

    db2 runstats on table ydd with distribution and indexes all

13．导出表数据

     db2 export to c:/dftz.txt of del select * from dftz

     db2 export to c:/dftz.ixf of ixf select * from dftz

14．导入表数据

import from c:/123.txt of del  insert into ylbx.czyxx

db2 import to c:/dftz.txt of del commitcount 5000 messages  c:/dftz.msg insert into dftz

db2 import to c:/dftz.ixf of ixf commitcount 5000 messages c:/dftz.msg insert into dftz

db2 import to c:/dftz.ixf of ixf commitcount 5000 insert into dftz

db2 import to c:/dftz.ixf of ixf commitcount 5000 insert_update into dftz

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)

db2 import to c:/dftz.ixf of ixf commitcount 5000 replace_create into dftz  (