[DB2] 常用命令3(待续)

--=================================db2数据导入导出============================================
导出:   db2 "export to 文件名.del of del select * from 表名"  (del为定界ASC2文件)
        db2 "export to 文件名.ixf of ixf select * from 表名"  (ixf为集成交换格式文件，DB2之间传输时首选)
导入：  db2 "import from 文件名.ixf of ixf insert/replace/create/.. into 表名"
(load) db2 "load from 文件名.del of del insert/replace/.. into 表名" (日志极少，速度更快)
--============================================================================================

--=================================db2事件观察器, 缓冲区查看修改================================
db2 "create event monitor moni_test1 for statements write to file '/home/db2inst1'"
db2 "set event monitor moni_test1 state 1"   --打开观察器,关闭时设置状态为0即可
db2evmon -path /home/db2inst1                --查看观察器
db2 get monitor switches                     --db2监测资源使用情况,以缓冲区为例,可知内存使用情况
db2 update monitor switches using BUFFERPOOL off, LOCK off,
    SORT off, STATEMENT off, TIMESTAMP off, TABLE off, UOW off
db2 get snapshot for bufferpools on wisgexp
db2 "select * from syscat.bufferpools"
-- 下面为创建和修改缓冲区(数据库的每个分区)
db2 create bufferpool "BP_8K_TMP" database partition group "IBMTEMPGROUP" size 51200 pagesize 8192 not extended storage
db2 "alter bufferpool BP_8K_ALL immediate size 51200";
--============================================================================================