32, 打开某个数据库监视内容 db2 -v update monitor switches using bufferpoolon
33, 获取数据库快照 db2 -v get snapshot for all databases > snap.out db2 -v get snapshot for dbm>> snap.out db2 -v get snapshot for all bufferpools>> snap.out db2 -v terminate
34, 重置数据库快照 db2 -v reset monitor all
35, 计算缓冲池命中率 理想情况下缓冲池命中率在 95% 以上,计算公式如下: (1 -((buffer pool data physical reads + buffer pool index physical reads) / (buffer pool data logical reads + pool index logical reads))) *100%
36, 创建 db2 实例 db2icrt < 实例名称 >
37, 删除 db2 实例 db2idrop < 实例名称 >
38, 设置当前 db2 实例 set db2intance=db2
39, 显示 db2 拥有的实例 db2ilist
40, 恢复离线增量备份数据库的命令 DB2 RESTORE DATABASE YNDC INCREMENTAL AUTOMATIC FROM D:backupautobakdb2 TAKEN AT 20060314232015
44, 给表增加列 ALTER TABLE STAFF ADD COLUMN PNHONE VARCHAR(20)
45, 数据迁移方法 1 export 脚本示例 db2 connect to testdb user test password test db2 "export to aa1.ixf of ixf select * from table1" db2 "export to aa2.ixf of ixf select * from table2" db2 connect reset import 脚本示例 db2 connect to testdb user test password test db2 "load from aa1.ixf of ixf replace into table1 COPY NO without prompting " db2 "load from aa2.ixf of ixf replace into table2 COPY NO without prompting " db2 connect reset v